Oracle

Solo disponible en BuenasTareas
  • Páginas : 3 (734 palabras )
  • Descarga(s) : 0
  • Publicado : 19 de agosto de 2012
Leer documento completo
Vista previa del texto
ORACLE:


HOJA 1


CREATE TABLE"ACUDIENTE_ESTUD"
( "ID_ACUD" VARCHAR2(15),
"COD_TIP_ACUD" VARCHAR2(2),
PRIMARY KEY("ID_ACUD", "COD_TIP_ACUD"))

CREATE TABLE"CONCEPTO"
( "COD_CONCEPTO"VARCHAR2(4),
"DESC_CONCEPTO" VARCHAR2(70),
"VALOR" NUMBER(10,0),
PRIMARYKEY("COD_CONCEPTO"))

CREATE TABLE"DETALLE_SERVICIO"
( "NUM_DOC" NUMBER(12,0),
"COD_TIP_DOC" NUMBER(4,0),"COD_CONCEPTO" VARCHAR2(4),
"CANT" NUMBER(4,0),
"VALOR" NUMBER(10,0),
PRIMARY KEY("NUM_DOC", "COD_TIP_DOC", "COD_CONCEPTO"))

CREATE TABLE"ESTUDIANTE"
( "ID_EST" VARCHAR2(15),
"NOMB" VARCHAR2(70),"APELL" VARCHAR2(70),
"DIR" VARCHAR2(120),
"TEL" VARCHAR2(15),
"ID_ACUD" VARCHAR2(15),
"ID_MADRE" VARCHAR2(15),
"ID_PADRE" VARCHAR2(15),
PRIMARY KEY("ID_EST"))


CREATETABLE"INVENTARIO"
( "COD_TIP_DOC" VARCHAR2(4),
"NUM_DOC" NUMBER(12,0),
"NUM_MATRICULA" NUMBER(12,0),
"FECHA" VARCHAR2(10),
"COD_CONCEPTO" VARCHAR2(4),
"VALOR" NUMBER(10,0),
"CANT" NUMBER(4,0),
"SALDO"NUMBER(10,0),
PRIMARY KEY("COD_TIP_DOC", "NUM_DOC", "NUM_MATRICULA"))

CREATE TABLE"MATRICULA"
( "NUM_MATRICULA" NUMBER(12,0),
"COD_TIP_DOC" NUMBER(4,0),
"FECHA" VARCHAR2(10),
"ID_EST"VARCHAR2(15),
"VALOR" NUMBER(10,0),
"OBSERVACIONES" VARCHAR2(255),
PRIMARY KEY("NUM_MATRICULA", "COD_TIP_DOC"))


CREATE TABLE"PADRE_ACUDIENTE"
( "ID_ACUD" VARCHAR2(15),
"NOMB" VARCHAR2(70),"APELL" VARCHAR2(70),
"DIR" VARCHAR2(120),
"TEL" VARCHAR2(15),
PRIMARY KEY("ID_ACUD"))

CREATE TABLE"PAGO_SERVICIO"
( "NUM_DOC" NUMBER(12,0),
"COD_TIP_DOC" VARCHAR2(4),
"NUM_MATRICULA"NUMBER(12,0),
"FECHA" VARCHAR2(10),
"ID_EST" VARCHAR2(15),
"OBSERVACIONES" VARCHAR2(255),
PRIMARY KEY("NUM_DOC", "COD_TIP_DOC"))

CREATE TABLE"TIPO_ACUDIENTE"
( "COD_TIP_ACUD" VARCHAR2(2),"DESC_TIP_ACUD" VARCHAR2(50),
PRIMARY KEY("COD_TIP_ACUD"))

CREATE TABLE"TIPO_DOCUMENTO"
( "COD_TIP_DOC" VARCHAR2(4),
"DESC_TIP_DOC" VARCHAR2(70),
"NUM_CONSECUTIVO" NUMBER(12,0),
PRIMARY...
tracking img