CREATE TABLE citas (
	id_cit int8 NOT NULL DEFAULT nextval(('sec_id_cit'::text)::regclass),
	id_usu int4 NOT NULL,
	id_emp int4 NOT NULL,
	id_suc int4 NOT NULL,
	id_dep int4 NOT NULL,
	id_sec int4 NOT NULL,
	fecha_cit date NOT NULL,
	hora_inicio_cit time NOT NULL,
	hora_fin_cit time NOT NULL,
	patente_cit varchar(15) NOT NULL,
	id_mbi int4 NOT NULL,
	modelo_cit varchar(100) NOT NULL,
	ano_cit int4,
	actividad_cit varchar(1) NOT NULL,
	cliente_cit varchar(100) NOT NULL,
	fono_cit varchar(201),
	descripcion_cit text,
	tiempo_cit numeric,
	direccion_cit varchar(200),
	id_tci int4,
	id_bie int8,
	id_otr int8,
	id_usu_cit int4,
	email_cit varchar(100),
	confirma_cit bool,
	celular_cit varchar(20),
	cedula_cit varchar(20),
	sistem_agendam_cit int4
);


CREATE TABLE citas (
	id_cit int8 NOT NULL DEFAULT nextval(('sec_id_cit'::text)::regclass),
	id_usu int4 NOT NULL,
	id_emp int4 NOT NULL,
	id_suc int4 NOT NULL,
	id_dep int4 NOT NULL,
	id_sec int4 NOT NULL,
	fecha_cit date NOT NULL,
	hora_inicio_cit time NOT NULL,
	hora_fin_cit time NOT NULL,
	patente_cit varchar(15) NOT NULL,
	id_mbi int4 NOT NULL,
	modelo_cit varchar(100) NOT NULL,
	ano_cit int4,
	actividad_cit varchar(1) NOT NULL,
	cliente_cit varchar(100) NOT NULL,
	fono_cit varchar(201),
	descripcion_cit text,
	tiempo_cit numeric,
	direccion_cit varchar(200),
	id_tci int4,
	id_bie int8,
	id_otr int8,
	id_usu_cit int4,
	email_cit varchar(100),
	confirma_cit bool,
	celular_cit varchar(20),
	cedula_cit varchar(20),
	sistem_agendam_cit int4
);