Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- column "inv_no" referenced in foreign key constraint does not exist
- CREATE TABLE invoice(
- inv_no INTEGER NOT NULL,
- cust_id INTEGER NOT NULL,
- inv_date DATE NOT NULL,
- CONSTRAINT PK_invoice_inv_no PRIMARY KEY(inv_no),
- CONSTRAINT FK_customer_cust_id FOREIGN KEY(cust_id) REFERENCES customer(cust_id)
- );
- CREATE TABLE invoiceLine(
- inv_line_no INTEGER NOT NULL,
- inv_line_qty INTEGER NOT NULL,
- CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
- CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_no) REFERENCES invoice(inv_no)
- );
- 1
- CREATE TABLE invoiceLine(
- inv_line_no INTEGER NOT NULL,
- inv_line_qty INTEGER NOT NULL,
- CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
- CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_line_no) REFERENCES invoice(inv_no)
- );
- CREATE TABLE invoiceLine(
- inv_line_no INTEGER NOT NULL,
- inv_line_qty INTEGER NOT NULL,
- inv_no Integer Not Null,
- CONSTRAINT PK_invoiceLine_inv_line_no PRIMARY KEY(inv_line_no),
- CONSTRAINT FK_invoice_inv_no FOREIGN KEY(inv_no) REFERENCES invoice(inv_no)
- );
Add Comment
Please, Sign In to add comment