마켓컬리

테이블 (14)

BASKETS

  • basket_id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — 외래 키 → ITEMS.item_id — NOT NULL
  • deliver_id — bigint — 외래 키 → ORDERS.order_id — NOT NULL
  • user_id — bigint — 외래 키 → ORDERS.user_id — NOT NULL
  • Key — bigint — 외래 키 → ORDERS.deliver_address_id — NOT NULL
  • Key (Key2) — bigint — 외래 키 → ORDERS.Key — NOT NULL
  • count — int
  • basket_no — int
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

CATEGORIES

  • id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — 외래 키 → ITEMS.item_id — NOT NULL
  • title — varchar(20)

DELIVER_ADDRESSES

  • deliver_address_idd (deliver_address_id) — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → USERS.id — NOT NULL
  • Key — bigint — 외래 키 → USERS.level_id — NOT NULL
  • address — varchar(255)
  • detail_address — varchar(255)

ITEMS

  • item_id — bigint — 기본 키 — NOT NULL
  • item_no — int — 기본 키 — NOT NULL
  • name — varchar(255)
  • description — text
  • price — int
  • discount_rate — int
  • count_purchase — int
  • created_at — timestamp
  • updated_at — timestamp
  • deadline — timestamp
  • deliver_price — int
  • status — varchar(20)

ITEM_DETAILS

  • Key — bigint — 기본 키 — NOT NULL
  • item_id — bigint — 외래 키 → ITEMS.item_id — NOT NULL
  • item_details_no — int
  • unit — varchar(10)
  • weight — varchar(25)
  • devliver_type (deliver_type) — varchar(25)
  • origin — varchar(20)
  • package_type — varchar(20)
  • expiration_date — timestamp
  • alergy — varchar(25)
  • description — varchar(255)

ITEM_QUESTIONS

  • Key — bigint — 기본 키 — NOT NULL
  • item_id — bigint — 외래 키 → ITEMS.item_id — NOT NULL
  • item_question_no — bigint
  • title — varchar(20)
  • description — varchar(255)
  • user_id — int
  • status — varchar(10)
  • created_at — timestamp
  • updated_at (update_at) — timestamp
  • qna_category — varchar(20)
  • is_secret — tinyint

KURLY_QNAS

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → USERS.id — NOT NULL
  • title — varchar(45)
  • description — text
  • status — varchar(20)

LEVELS

  • Key — bigint — 기본 키 — NOT NULL
  • level_no — int
  • points_rate — bigint
  • description — text
  • next_points — int
  • points — int
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

NOTICES

  • Key — int — 기본 키 — NOT NULL
  • notice_no — int
  • title — string
  • description — text
  • item_no — int
  • is_kurly — tinyint
  • is_notified — tinyint
  • is_pushed — tinyint
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

ORDERS

  • order_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → USERS.id — NOT NULL
  • payment_id — bigint — 외래 키 → PAYMENTS.id — NOT NULL
  • deliver_address_id — bigint — 외래 키 → DELIVER_ADDRESSES.deliver_address_idd — NOT NULL
  • Key — bigint — 외래 키 → USERS.level_id — NOT NULL
  • ordered_at (time) — timestamp
  • deliver_type — varchar(255)
  • status — varchar(255)
  • estimated_time — timestamp
  • total_price — int
  • delivered_at — timestamp
  • deliver_no — varchar(45)
  • is_member — tinyint
  • created_at — timestamp
  • updated_at — timestamp
  • order_no — int
  • point — int
  • discount — int

PAYMENTS

  • id — bigint — 기본 키 — NOT NULL
  • discount — int
  • card_type — varchar(20)
  • description — varchar(45)
  • status — varchar(20)

REVIEWS

  • review_id — int — 기본 키 — NOT NULL
  • order_id — int — 외래 키 → ORDERS.order_id — NOT NULL
  • user_id — int — 외래 키 → ORDERS.user_id — NOT NULL
  • Key — bigint — 외래 키 → ORDERS.Key — NOT NULL
  • score — int
  • image — blob
  • description — text
  • title — varchar(45)
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

USERS

  • id — bigint — 기본 키 — NOT NULL
  • level_id — bigint — 외래 키 → LEVELS.Key — NOT NULL
  • user_no — int
  • username — varchar(45)
  • password — varchar(255)
  • name — varchar(255)
  • email — varchar(255)
  • phone_number — varchar(45)
  • address — varchar(255)
  • birth — timestamp
  • gender — varchar(20)
  • status — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • Field (level) — varchar(25)
  • Field (is_notified) — tinyint
  • Field (is_night_notified) — tinyint

WISHLISTS

  • wishlist_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → USERS.id — NOT NULL
  • item_id — int — 외래 키 → USERS.level_id — NOT NULL