hospitalario_asignacion

CREATE TABLE public.hospitalario_asignacion
(
    codigo_establecimiento character varying(16) COLLATE pg_catalog."default" NOT NULL,
    codigo_asignacion character varying(10) COLLATE pg_catalog."default" NOT NULL,
    codigo_paciente character varying(20) COLLATE pg_catalog."default" NOT NULL,
    tipo_documento character varying(1) COLLATE pg_catalog."default",
    hospitalario_fecha date,
    hospitalario_hora time without time zone,
    codigo_medico character varying(10) COLLATE pg_catalog."default",
    medico_suplente character varying(10) COLLATE pg_catalog."default",
    cancelar_hospitalario character varying(1) COLLATE pg_catalog."default",
    fecha_cancelar_hospitalario character varying(1) COLLATE pg_catalog."default",
    hora_cancelar_hospitalario time without time zone,
    estado character varying(1) COLLATE pg_catalog."default",
    primera_consulta_anho character varying(1) COLLATE pg_catalog."default",
    referido character varying(2) COLLATE pg_catalog."default",
    serefiere_local character varying(2) COLLATE pg_catalog."default",
    codigo_servicio integer NOT NULL,
    edad_paciente integer NOT NULL,
    tipo_edad integer NOT NULL,
    cod_departamento_residencia character(2) COLLATE pg_catalog."default",
    cod_distrito_residencia character(3) COLLATE pg_catalog."default",
    cod_barrio_residencia character(3) COLLATE pg_catalog."default",
    area character varying(3) COLLATE pg_catalog."default",
    codigo_edificio character varying(3) COLLATE pg_catalog."default",
    codigo_piso character varying(4) COLLATE pg_catalog."default",
    codigo_sala character varying(4) COLLATE pg_catalog."default",
    codigo_cama character varying(4) COLLATE pg_catalog."default",
    nombre_cama character varying(64) COLLATE pg_catalog."default",
    tipo_cama character varying(1) COLLATE pg_catalog."default",
    btimestamp character varying(15) COLLATE pg_catalog."default",
    seguro_medico character varying(8) COLLATE pg_catalog."default",
    creacion_fecha date,
    creacion_hora time without time zone,
    creacion_usuario character varying(10) COLLATE pg_catalog."default",
    modificacion_fecha date,
    modificacion_hora time without time zone,
    modificacion_usuario character varying(10) COLLATE pg_catalog."default",
    CONSTRAINT hospitalario_asignacion_pk PRIMARY KEY (codigo_establecimiento, codigo_asignacion)
)