한경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