Database Schema - Team-LANS/lepta GitHub Wiki

#ER Model ##Original The Lepta Database should look like this:

##Adaption In order to be implemented with hibernate and h2, a few changes must be made: ER Model

#Schema (Key, Unique, Normal)

User (User_Id, User_Name, Color, Password)
Bill (Bill_Id, Bill_Name, Status, Timestamp, User_Id)
Item (Item_Id, Description, Price)
Owner (User_Id, Item_Id)

#Attributes

ID: Integer
COLOR: Enum
DESCRIPTION: String
NAME: String
PASSWORD:
PRICE: Double
STATUS: Enum, new, assigned or archived
TIMESTAMP: Date