-- Sequence: reservation_id_seq

-- DROP SEQUENCE reservation_id_seq;

CREATE SEQUENCE reservation_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE reservation_id_seq
  OWNER TO postgres;


-- Table: reservation

-- DROP TABLE reservation;

CREATE TABLE reservation
(
  id smallint NOT NULL DEFAULT nextval('reservation_id_seq'::regclass),
  name character varying(255),
  date timestamp without time zone,
  CONSTRAINT reservation_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE reservation
  OWNER TO postgres;
COMMENT ON TABLE reservation
  IS 'Tabla para guardar los tipos de reservas para una cita.';

INSERT INTO "public"."reservation" ("id", "name", "date") VALUES ('1', 'Presencial', '2016-12-26 20:34:47');
INSERT INTO "public"."reservation" ("id", "name", "date") VALUES ('2', 'Telefónica', '2016-12-26 20:35:07');