Open Invoicing psi-database foreign key

Today in the PSI QQ group chatting up the topic of the database foreign key, I wrote this blog post, said I on the database foreign key considerations.

1, the database design should use foreign keys.

2, very cup with, PSI database design so far, no foreign key.

3, PSI will gradually put the database foreign key to fill up.

4, some places really can not add foreign keys. Here's an example:

4.1 t_warehouse_org in the org_id field, that can store the ID of the t_org, but also can store the T_user ID, this time, the foreign key cannot be added.

The Ref_number field in 4.2 T_inventory_detail can store the values of Ref_number fields for multiple documents

4.3 should be receivable, deal with, there is a similar situation inside

Open Invoicing psi-database foreign key