p00
Tables (6)
Order (Order Table)
- oid (Order Id) — int — Primary key — NOT NULL
- pid (Product Id/Set Menu Id) — int
- oquan (Quantity of product in Order) — int
- otp (Order Total Price) — int
- otime (Order Date and time) — datetime
- otno (Order Table Number) — int — if takeout: 0 rest: 1-20
Payment (Payment Table)
- payid (Payment Id) — int — Primary key — NOT NULL
- oid (Order Id) — int
- paymethod (Payment Method) — int — enum('credit_card', 'cash', 'mobile_payment')
- paystat (Payment Status) — int — enum('completed', 'pending', 'failed', 'cancelled')
- rec_link (Receipt Link) — varchar(255)
- paytime (Payment Date and Time) — datetime
- uid (User who paid) — int
Product (Product Table)
- pid (Product Number) — int — Primary key — NOT NULL — Additionals (i.e. extra shot) is also considered as product
- pname (Product Name) — varchar(30)
- pimg (Product Image) — varchar(225)
- pprice (Product Price) — int
- pteam (Product Team) — int — 0: Admin 1: Bakery 2: Barista 3: Dining enum('bakery', 'barista', 'dining')
- pcat (Product Category) — int — This would vary by team
- pstatus (Product Status) — int — 0: Not For Sale 1: For Sale 2: Deleted Permanently enum('available', 'out of sale', 'deleted')
- pdate (Product Input Date) — datetime
- pclick (Product Sold) — int
Set_Menu (Set Menu Table)
- id (ai id) — int — Primary key — NOT NULL
- smid (Set Menu Id) — int
- pid (Main Product Id) — int
- sop (Set Menu Option) — int — 1: Yes 0: No
- sprice (Set Menu Option Price) — int
- stp (Set Menu Total Price) — int
User (User Table)
- uid (User Number) — int — Primary key — NOT NULL
- uname (User username) — varchar(15)
- urn (User Real Name) — varchar(50)
- upwd (User Password) — varchar(16)
- urole (User Permission) — int — 0: Admin/Team Leader 1: No Permission
- ujoin (User Join Date) — datetime
staff (Staff Table)
- jid (Staff Number) — int — Primary key — NOT NULL
- jname (Username) — varchar(15)
- jrn (Staff Real Name) — varchar(50)
- jpwd (Staff Password) — varchar(16)
- jteam (Staff Team) — int — 0: Admin 1: Bakery 2: Barista 3: Dining enum('bakery', 'barista', 'dining')
- jrole (Staff Permission) — int — 0: Admin/Team Leader 1: No Permission
- jjoin (Staff Join Date) — datetime
- jleave (Staff Leave Date) — datetime