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