한경DB구조도
테이블 (8)
BAEMIN (TB_ITEM_BAEMIN)
- order_no (Key) — 기본 키 — NOT NULL
- shop_id (Key2) — 외래 키 → SHOP.shop_id — NOT NULL
- status (Field) — Int
- pay_amount (Field2) — Int
- order_amount (Field3) — Int
- delivery_amount (Field4) — Int
- order_time (Field5) — Datetime
- accpt_time (Field6) — Datetime
- arrive_time (Field7) — Datetime
- discount_amount (Field8) — Int
- menu_discount_amount (Field9) — Int
- takeout_discount_amount (Field10) — Int
- employee_discount_amount (Field11) — Int
- menu_item (Field12) — Char
CPEATS (TB_ITEM_CPEATS)
- abbr_order_no (Key) — Char — 기본 키 — NOT NULL
- shop_id (Key2) — 외래 키 → SHOP.shop_id — NOT NULL
- status (Field) — Int
- totalAmount (Field2) — Int
- salePrice (Field4) — Int
- discountPrice (Field5) — Int
- createdAt (Field6) — Datetime
- reviewRating (Field7) — Int
- items (Field8) — Char
Comment (CopyOfUntitled3)
- comment_id (Key) — Int — 기본 키 — NOT NULL
- image (Field3) — char
- time (Field) — Datetime
- score (Field2) — Int
- writer (Field4) — char
- platform (Field5) — char
DONGWON (CopyOfTB_ITEM_BAEMIN)
- order_no (Key) — 기본 키 — NOT NULL
- shop_id (Key2) — 외래 키 → SHOP.shop_id — NOT NULL
- receiving (Field) — Datetime
- order_code (Field2) — Char
- order_name (Field3) — Char
- unit_price (Field4) — Int
- receiving_price (Field5) — Int
- vat (Field6) — Int
- total_price (Field7) — Int
- available_loans (Field8) — Int
- expected_receiving (Field9) — Datetime
MENU (Untitled3)
- menu_id (Key) — Int — 기본 키 — NOT NULL
- menu_name (Field) — Char
- menu_price (Field2) — Int
SHOP (Untitled2)
- shop_id (Key) — Int — 기본 키 — NOT NULL
- baemin_code (Field) — Char
- yogiyo_code (Field2) — Char
- cpeats_code (Field3) — Char
- location (Field4) — Char
USER (Untitled)
- user_id (Key2) — Int — 기본 키 — NOT NULL
- shop_id (Key) — Int — 외래 키 → SHOP.shop_id — NOT NULL
- user_pw (Field8) — Char
- user_name (Field2) — Char
- baemin_id (Field3) — Int
- baemin_pw (Field) — Char
- cp_eats_id (Field4) — Int
- cp_eats_pw (Field5) — Char
- yogiyo_id (Field6) — Int
- yogiyo_pw (Field7) — Char
- is_admin (Field9) — Int
YOGIYO (TB_ITEM_YOGIYO)
- order_no (Key) — 기본 키 — NOT NULL
- shop_id (Key2) — 외래 키 → SHOP.shop_id — NOT NULL
- status (Field) — Int
- order_time (Field2) — Datetime
- payment_type (Field3) — Char
- pay_amount (Field4) — Int
- delivery_amount (Field5) — Int
- discount_amount (Field6) — Int
- discount_HK_amount (Field7) — Int
- discount_yogiyo_amount (Field8) — Int
- reviewRating (Field9) — Int
- non_reply (Field10) — Int