IDP INTEGER NOT NULL ,
NOMBRE VARCHAR2(30) ,
APELLIDO VARCHAR2(30) ,
EDAD INTEGER ,
CORREO VARCHAR2(30) ,
IDC INTEGER ,
CONSTRAINT PERSONAS_PK PRIMARY KEY
(
IDP
)
ENABLE
);
ALTER TABLE PERSONAS
ADD FOREIGN KEY(IDC)REFERENCES CIUDADES (IDC);
CREATE TABLE CIUDADES (
IDC INTEGER NOT NULL,
NOMC VARCHAR2(30) ,
IDPA INTEGER ,
CONSTRAINT CIUDADES_PK PRIMARY KEY
(
IDC
)
ENABLE
);
ALTER TABLE CUIDADES
ADD FOREIGN KEY(IDC)REFERENCES PAIS (IDPA);
CREATE TABLE FACGEN (
IDF INTEGER NOT NULL ,
IDP INTEGER,
FECHA DATE ,
CONSTRAINT FACGEN_PK PRIMARY KEY
(
IDF
)
ENABLE
);
ALTER TABLE FACGEN
ADD FOREIGN KEY(IDP)REFERENCES PERSONAS (IDP);
CREATE TABLE ARTICULOS (
IDA INTEGER NOT NULL ,
DESCRIPCION VARCHAR2(30),
U_MEDIA VARCHAR2(30) ,
CONSTRAINT ARTICULOS_PK PRIMARY KEY
(
IDA
)
ENABLE
);
CREATE TABLE PAIS (
IDPA INTEGER NOT NULL,
NOMPA VARCHAR2(30) ,
CONSTRAINT PAIS_PK PRIMARY KEY
(
IDPA
)
ENABLE
);
CREATE TABLE FACDET (
IDF INTEGER,
IDA INTEGER,
CANTIDAD INTEGER ,
VAL_UNIT INTEGER ,
VAL_TOT INTEGER
);
ALTER TABLE FACDET
ADD FOREIGN KEY(IDA)REFERENCES ARTICULOS (IDA);
ALTER TABLE FACDET
ADD FOREIGN KEY(IDF)REFERENCES FACGEN (IDF);