jshoyos / soen390-team01

MIT License
0 stars 0 forks source link

Design and create the order and procurement related entities #43

Closed t-andrews closed 3 years ago

t-andrews commented 3 years ago

The Accounting feature will require the following entities. They should be added as tables in the database:

Customer: Attribute Type
customer_id long
name string
address string
phone_number string
Vendor: Attribute Type
vendor_id long
name string
address string
phone_number string
Order: Attribute Type
order_id long
item_id long
customer_id long
payment_id string
item_quantity integer
state string
Procurement: Attribute Type
procurement_id long
item_id long
vendor_id long
payment_id long
item_quantity integer
state string
Payment: Attribute Type
payment_id long
amount price
state string