expo - 준영
테이블 (6)
tbl_category (카테고리)
- category_id (Key) — INT — 기본 키 — NOT NULL
- category_name (Field) — VARCHAR
- create (Field2) — DATETIME
- update (Field3) — DATETIME
tbl_detail (주문상세)
- detail_Id (Key) — INT — 기본 키 — NOT NULL
- menu_Id (Key2) — INT — 외래 키 → tbl_menu.menu_id — NOT NULL
- order_Id (Key3) — INT — 외래 키 → tbl_order.order_Id — NOT NULL
- user_id (Key32) — INT — 외래 키 → tbl_menu.user_id — NOT NULL
- quantity (Field3) — INT
- option (Field) — VARCHAR
- create (Field2) — DATETIME
- update (Field4) — DATETIME
tbl_menu (메뉴)
- menu_id (Key) — INT — 기본 키 — NOT NULL
- category_id (Key2) — INT — 외래 키 → tbl_category.category_id — NOT NULL
- user_id (Key3) — INT — 외래 키 → tbl_user.user_id — NOT NULL
- coffe (Field) — VARCHAR
- price (Field3) — INT
- status (Field4) — ENUM
- create (Field2) — DATETIME
- update (t) — DATETIME
tbl_order (주문)
- order_Id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → tbl_user.user_id — NOT NULL
- total_amount (Field2) — INT
- order_status (Field4) — ENUM
- create (Field5) — DATETIME
- update (Field6) — DATETIME
tbl_payment (Untitled6)
- payment_Id (Key) — INT — 기본 키 — NOT NULL
- order_id (Key2) — INT — 외래 키 → tbl_order.order_Id — NOT NULL
- payment_method (Field) — VARCHAR
- amount (Field2) — INT
- create (Field3) — DATETIME
- update (Field4) — DATETIME
tbl_user (Untitled)
- user_id (Key) — INT — 기본 키 — NOT NULL
- password (Field) — VARCHAR
- username (Field2) — VARCHAR
- create (Field3) — DATETIME
- update (Field4) — DATETIME
- role (Field5) — ENUM
- company (Field6) — VARCHAR