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