Mullate

Tables (6)

Admin

  • admin_id (Key) — int — Primary key — NOT NULL
  • userId (Field) — string
  • password (Field2) — string

Cart

  • cart_id (Key) — int — Primary key — NOT NULL
  • menu_id (Key2) — int — Foreign key → Menu.menu_id — NOT NULL
  • session_id (Field) — string
  • quantity (Field2) — int
  • created_at (Field3) — datetime

Category

  • category_id (Key) — int — Primary key — NOT NULL
  • name (Field) — string
  • order (Field2) — int
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

Menu

  • menu_id (Key) — int — Primary key — NOT NULL
  • category_id (Key2) — int — Foreign key → Category.category_id — NOT NULL
  • name (Field) — string
  • price (Field2) — int
  • image (Field3) — string
  • order (Field4) — int
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

Order

  • order_id (Key) — int — Primary key — NOT NULL
  • session_id (Field) — string
  • type (Field2) — enum("매장", "포장")
  • status (Field3) — string
  • create_at (Field4) — datetime

OrderItem

  • orderItem_id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → Order.order_id — NOT NULL
  • menu_id (Key3) — int — Foreign key → Menu.menu_id — NOT NULL
  • quantity (Field) — int
  • price (Field2) — int