SHARE
TWEET

hospitalario_asignacion

gallopelado Jun 5th, 2020 1,212 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE public.hospitalario_asignacion
  2. (
  3.     codigo_establecimiento character varying(16) COLLATE pg_catalog."default" NOT NULL,
  4.     codigo_asignacion character varying(10) COLLATE pg_catalog."default" NOT NULL,
  5.     codigo_paciente character varying(20) COLLATE pg_catalog."default" NOT NULL,
  6.     tipo_documento character varying(1) COLLATE pg_catalog."default",
  7.     hospitalario_fecha date,
  8.     hospitalario_hora time without time zone,
  9.     codigo_medico character varying(10) COLLATE pg_catalog."default",
  10.     medico_suplente character varying(10) COLLATE pg_catalog."default",
  11.     cancelar_hospitalario character varying(1) COLLATE pg_catalog."default",
  12.     fecha_cancelar_hospitalario character varying(1) COLLATE pg_catalog."default",
  13.     hora_cancelar_hospitalario time without time zone,
  14.     estado character varying(1) COLLATE pg_catalog."default",
  15.     primera_consulta_anho character varying(1) COLLATE pg_catalog."default",
  16.     referido character varying(2) COLLATE pg_catalog."default",
  17.     serefiere_local character varying(2) COLLATE pg_catalog."default",
  18.     codigo_servicio integer NOT NULL,
  19.     edad_paciente integer NOT NULL,
  20.     tipo_edad integer NOT NULL,
  21.     cod_departamento_residencia character(2) COLLATE pg_catalog."default",
  22.     cod_distrito_residencia character(3) COLLATE pg_catalog."default",
  23.     cod_barrio_residencia character(3) COLLATE pg_catalog."default",
  24.     area character varying(3) COLLATE pg_catalog."default",
  25.     codigo_edificio character varying(3) COLLATE pg_catalog."default",
  26.     codigo_piso character varying(4) COLLATE pg_catalog."default",
  27.     codigo_sala character varying(4) COLLATE pg_catalog."default",
  28.     codigo_cama character varying(4) COLLATE pg_catalog."default",
  29.     nombre_cama character varying(64) COLLATE pg_catalog."default",
  30.     tipo_cama character varying(1) COLLATE pg_catalog."default",
  31.     btimestamp character varying(15) COLLATE pg_catalog."default",
  32.     seguro_medico character varying(8) COLLATE pg_catalog."default",
  33.     creacion_fecha date,
  34.     creacion_hora time without time zone,
  35.     creacion_usuario character varying(10) COLLATE pg_catalog."default",
  36.     modificacion_fecha date,
  37.     modificacion_hora time without time zone,
  38.     modificacion_usuario character varying(10) COLLATE pg_catalog."default",
  39.     CONSTRAINT hospitalario_asignacion_pk PRIMARY KEY (codigo_establecimiento, codigo_asignacion)
  40. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top