Skip to content

Instantly share code, notes, and snippets.

@amartinezg
Last active October 17, 2019 12:17
Show Gist options
  • Select an option

  • Save amartinezg/54541bddf6571c42e4ee4921fc21895c to your computer and use it in GitHub Desktop.

Select an option

Save amartinezg/54541bddf6571c42e4ee4921fc21895c to your computer and use it in GitHub Desktop.
Creación de tablas
CREATE TABLE ESTADOS_PRESTADORES (
ID
NOMBRE
CONSTRAINT
);
CREATE TABLE MODALIDADES (
ID
NOMBRE
);
CREATE TABLE TIPO_COMUNAS (
ID
TIPO
CONSTRAINT
);
CREATE TABLE COMUNAS (
ID
NOMBRE
TIPO_COMUNA_ID
CONSTRAINT
);
CREATE TABLE BARRIOS(
ID
NOMBRE
COMUNA_ID
CONSTRAINT
);
CREATE TABLE PRESTADORES(
ID
NOMBRE
FECHA_CONTRATACION
VALOR_CONTRATO
ESTADO_ID
CONSTRAINT
);
CREATE TABLE SEDES(
ID
SEDE
TELEFONO
DIRECCION
CUPOS_DISPUESTOS
BARRIO_ID
MODALIDAD_ID
PRESTADOR_ID
CONSTRAINT
CONSTRAINT
CONSTRAINT
CONSTRAINT
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment