Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ORA-02256: number of referencing columns must match referenced columns
- CREATE TABLE FLIGHT (
- FLIGHT_ID NUMBER(3),
- AIRCRAFT_ID VARCHAR(8),
- FLIGHT_DATE DATE,
- CONSTRAINT PK_flight_comp_pk PRIMARY KEY (FLIGHT_ID,FLIGHT_DATE),
- CONSTRAINT FK_flight_route_ID FOREIGN KEY (FLIGHT_ID)
- REFERENCES FLIGHT_ROUTE(ROUTE_ID),
- CONSTRAINT FK_flight_serial_ID FOREIGN KEY (AIRCRAFT_ID)
- REFERENCES AIRCRAFT(AIRCRAFT_ID)
- );
- CREATE TABLE RESERVATIONS (
- CUSTOMER_ID NUMBER(4),
- FLIGHT_ID NUMBER(3),
- QTY_RESERVED_SEATS NUMBER(3),
- CONSTRAINT PK_reservations PRIMARY KEY (CUSTOMER_ID,FLIGHT_ID),
- CONSTRAINT FK_reservations_customer_ID FOREIGN KEY (CUSTOMER_ID)
- REFERENCES CUSTOMER(CUSTOMER_ID),
- CONSTRAINT FK_reservations_flight_ID FOREIGN KEY (FLIGHT_ID)
- REFERENCES FLIGHT(FLIGHT_ID,FLIGHT_DATE)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement