mgmt info sys
Tables (4)
CouponBook
- CustomerId (PK) — Int — Foreign key → Customer.CustomerId — NOT NULL
- coupon_count (Field) — Int
Customer
- CustomerId (PK) — Int — Primary key — NOT NULL
- is_registered (Field) — Boolean
- visit_num (Field2) — Int
- grade (Field3) — String
- nickname (Field4) — String
Order (Untitled)
- OrderId (Key) — Int — Primary key — NOT NULL
- CustomerId (PK) — Int — Foreign key → Customer.CustomerId — NOT NULL
- is_primary (Field) — Boolean
- menuId (FK) — Int — Foreign key → menu.menuId — NOT NULL
- ordertime (Field2) — DATETIME
menu
- menuId (Key) — Int — Primary key — NOT NULL
- name (Field) — String
- calorie (Field2) — Float
- price (Field3) — Int