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