Guest User

Untitled

a guest
Jan 21st, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. column "inv_no" referenced in foreign key constraint does not exist
  2.  
  3. CREATE TABLE invoice(
  4.  
  5. inv_no INTEGER NOT NULL,
  6. cust_id INTEGER NOT NULL,
  7. inv_date DATE NOT NULL,
  8. CONSTRAINT PK_invoice_inv_no PRIMARY KEY(inv_no),
  9. CONSTRAINT FK_customer_cust_id FOREIGN KEY(cust_id) REFERENCES customer(cust_id)
  10. );
  11.  
  12. CREATE TABLE invoiceLine(
  13.  
  14. inv_line_no INTEGER NOT NULL,
  15. inv_line_qty INTEGER NOT NULL,
  16. CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
  17. CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_no) REFERENCES invoice(inv_no)
  18. );
  19.  
  20. 1
  21.  
  22. CREATE TABLE invoiceLine(
  23.  
  24. inv_line_no INTEGER NOT NULL,
  25. inv_line_qty INTEGER NOT NULL,
  26. CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
  27. CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_line_no) REFERENCES invoice(inv_no)
  28. );
  29.  
  30. CREATE TABLE invoiceLine(
  31.  
  32. inv_line_no INTEGER NOT NULL,
  33. inv_line_qty INTEGER NOT NULL,
  34. inv_no Integer Not Null,
  35. CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
  36. CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_no) REFERENCES invoice(inv_no)
  37. );
Add Comment
Please, Sign In to add comment