我正在开发一个库存管理系统。在后端,我们使用POSTGRESQL数据库。我们有三张桌子:
1. invoice:
a. invoice_no CHARACTER VARYING(20), //PK stores the invoice no.
b. invoice_date DATE, //stores the invoice date.
c. party INT. //FK party.id the id of the party of the invoice.
2. invoice_item:
a. invoice_no CHARACTER VARYING(20)