Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE HABITACION(ID_HABITACION INTEGER NOT NULL,
- CANT_CAMAS INTEGER NOT NULL,
- CONSTRAINT PK_HABITACION PRIMARY KEY(ID_HABITACION));
- CREATE TABLE PROFESION(CODIGO_PROFESION INTEGER NOT NULL,
- NOMBRE VARCHAR2(200) NOT NULL,
- CONSTRAINT PK_CODIGO_PROFESION primary key(CODIGO_PROFESION));
- CREATE TABLE HUESPED(RUT_PASAPORTE VARCHAR2(40) NOT NULL,
- NOMBRES VARCHAR2(200) NOT NULL,
- APELLIDO_PATERNO VARCHAR2(150) NOT NULL,
- APELLIDO_MATERNO VARCHAR2(150) NOT NULL,
- TELEFONO INTEGER NOT NULL,
- CODIGO_PROFESION INTEGER NOT NULL,
- CONSTRAINT PK_HUESPED PRIMARY KEY(RUT_PASAPORTE),
- CONSTRAINT FK_PROFESION FOREIGN KEY(CODIGO_PROFESION) REFERENCES PROFESION(CODIGO_PROFESION));
- CREATE TABLE RESERVA(NUMERO_RESERVA INTEGER NOT NULL,
- FECHA_LLEGADA DATE NOT NULL,
- FECHA_SALIDA DATE NOT NULL,
- TOTAL_A_PAGAR INTEGER NOT NULL,
- DIAS_ARRIENDO INTEGER,
- MESES_ARRIENDO INTEGER,
- ID_HABITACION INTEGER NOT NULL,
- RUT_PASAPORTE VARCHAR2(40) NOT NULL,
- CONSTRAINT PK_RESERVA PRIMARY KEY(NUMERO_RESERVA),
- CONSTRAINT FK_HABITACION FOREIGN KEY(ID_HABITACION) REFERENCES HABITACION(ID_HABITACION),
- CONSTRAINT FK_HUESPED FOREIGN KEY(RUT_PASAPORTE) REFERENCES HUESPED(RUT_PASAPORTE));
- CREATE TABLE DIARIO(ID_HABITACION INTEGER NOT NULL,
- VALOR_DIA INTEGER NOT NULL,
- BAÑO_COMPRATIDO CHAR(1) NOT NULL,
- CONSTRAINT PK_DIARIO PRIMARY KEY(ID_HABITACION),
- CONSTRAINT FK_DIARIO_HABITACION FOREIGN KEY(ID_HABITACION) REFERENCES HABITACION(ID_HABITACION));
- CREATE TABLE MENSUAL(ID_HABITACION INTEGER NOT NULL,
- COSTO_MES INTEGER NOT NULL,
- CONSTRAINT PK_MENSUAL PRIMARY KEY(ID_HABITACION),
- CONSTRAINT FK_MENSUAL_HABITACION FOREIGN KEY(ID_HABITACION) REFERENCES HABITACION(ID_HABITACION));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement