October 10, 2018 Meeting notes

[FarahZaqout]

Meeting to finalize the planning phase:

We finalized the schema as follows:

https://my.vertabelo.com/model/3GEnVnVJLy2ilmVgfWjuvSdRsp9kWhsn

In item details:

(item id, fabric, color, size) are together a unique constraint.
default for fabric and size should be set to: no fabric, no size.

in item pricing table:

(item id and start date) should be a unique constraint.

payment method:

does the pattern check come from the payment method's official api or not?

Technical spike needed:

use inner join to get one column's value or duplicate that info in another table.