Advertisement
Guest User

Untitled

a guest
May 6th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. ORA-02256: number of referencing columns must match referenced columns
  2.  
  3. CREATE TABLE FLIGHT (
  4. FLIGHT_ID NUMBER(3),
  5. AIRCRAFT_ID VARCHAR(8),
  6. FLIGHT_DATE DATE,
  7. CONSTRAINT PK_flight_comp_pk PRIMARY KEY (FLIGHT_ID,FLIGHT_DATE),
  8. CONSTRAINT FK_flight_route_ID FOREIGN KEY (FLIGHT_ID)
  9. REFERENCES FLIGHT_ROUTE(ROUTE_ID),
  10. CONSTRAINT FK_flight_serial_ID FOREIGN KEY (AIRCRAFT_ID)
  11. REFERENCES AIRCRAFT(AIRCRAFT_ID)
  12. );
  13.  
  14. CREATE TABLE RESERVATIONS (
  15. CUSTOMER_ID NUMBER(4),
  16. FLIGHT_ID NUMBER(3),
  17. QTY_RESERVED_SEATS NUMBER(3),
  18. CONSTRAINT PK_reservations PRIMARY KEY (CUSTOMER_ID,FLIGHT_ID),
  19. CONSTRAINT FK_reservations_customer_ID FOREIGN KEY (CUSTOMER_ID)
  20. REFERENCES CUSTOMER(CUSTOMER_ID),
  21. CONSTRAINT FK_reservations_flight_ID FOREIGN KEY (FLIGHT_ID)
  22. REFERENCES FLIGHT(FLIGHT_ID,FLIGHT_DATE)
  23. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement