FR07 - Database Design and Implemenation

[seendsouza]

Design and implement PostgreSQL for the user data store.

[seendsouza]

Servers Table: Primary Key: Server ID Fields: Server Name

Users Table: Primary Key: Username Fields: Balance (in Starbux) Foreign Keys: Server ID

Quotes Table: Primary Key: UUID Fields: Quote Foreign Keys: Username

Products Table: Primary Key: Product ID Fields: Product Name, Unit Price, Units in Stock, Quantity per Unit

Orders Table: Primary Key: Order ID Fields: Order Time Foreign Key: Username

Orders Details Table: Primary Key: Order ID, Product ID Fields: Unit Price, Quantity