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