marketKurly

Tables (23)

BASKETS

  • basket_id — bigint — Primary key — NOT NULL
  • item_id — bigint — Foreign key → ITEMS.item_id — NOT NULL
  • deliver_id — bigint — Foreign key → ORDERS.order_id — NOT NULL
  • user_id — bigint — Foreign key → ORDERS.user_id — NOT NULL
  • Key — bigint — Foreign key → ORDERS.deliver_address_id — NOT NULL
  • Key (Key2) — bigint — Foreign key → ORDERS.Key — NOT NULL
  • count — int
  • basket_no — int
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

CATEGORIES

  • id — bigint — Primary key — NOT NULL
  • item_id — bigint — Foreign key → ITEMS.item_id — NOT NULL
  • title — varchar(20)

COUPONS

  • coupon_id — int — Primary key — NOT NULL
  • coupon_name — varchar(45)
  • discount — int
  • expired_date — timestamp
  • created_at — timestamp
  • is_used — bool

DELIVER_ADDRESSES

  • deliver_address_idd (deliver_address_id) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • Key — bigint — Foreign key → USERS.level_id — NOT NULL
  • address — varchar(255)
  • detail_address — varchar(255)

EVENTS

  • id — int — Primary key — NOT NULL
  • coupon_id — int — Foreign key → COUPONS.coupon_id — NOT NULL
  • user_id — int
  • description — varchar(255)
  • status — int
  • deadline — timestamp
  • created_at — timestamp
  • created_at (updated_at) — timestamp

EVENT_PARTICIPANTS

  • Key — bigint — Primary key — NOT NULL
  • event_id — bigint — Foreign key → EVENTS.id — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • Field (status) — bigint
  • Field (description) — varchar(45)
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

ITEMS

  • item_id — bigint — Primary key — NOT NULL
  • item_no — int — Primary key — 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 — Primary key — NOT NULL
  • item_id — bigint — Foreign key → 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_IMGS

  • id — int — Primary key — NOT NULL
  • item_id — bigint — Foreign key → ITEMS.item_id — NOT NULL
  • img_url — text
  • status — varchar(20)

ITEM_QUESTIONS

  • Key — bigint — Primary key — NOT NULL
  • item_id — bigint — Foreign key → 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

KURLYPASSES

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • disount (discount) — int
  • description — text

KURLY_QNAS

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • title — varchar(45)
  • description — text
  • status — varchar(20)

LEVELS

  • Key — bigint — Primary key — 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 — Primary key — 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

NOUSERS

  • Key — bigint — Primary key — NOT NULL
  • Field (nouser_no) — int
  • Field (address) — varchar(255)
  • Field (is_notified) — int
  • Field2 (is_night_notified) — tinyint

ORDERS

  • order_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • payment_id — bigint — Foreign key → PAYMENTS.id — NOT NULL
  • deliver_address_id — bigint — Foreign key → DELIVER_ADDRESSES.deliver_address_idd — NOT NULL
  • Key — bigint — Foreign key → 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 — Primary key — NOT NULL
  • discount — int
  • card_type — varchar(20)
  • description — varchar(45)
  • status — varchar(20)

PRESENTS

  • present_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • order_id — bigint — Foreign key → ORDERS.order_id — NOT NULL
  • user_id2 — int
  • created_at — timestamp
  • updated_at — timestamp
  • status — varchar(25)
  • message — varchar(255)
  • messenger — varchar(25

REVIEWS

  • review_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → ORDERS.order_id — NOT NULL
  • user_id — int — Foreign key → ORDERS.user_id — NOT NULL
  • Key — bigint — Foreign key → ORDERS.Key — NOT NULL
  • score — int
  • image — blob
  • description — text
  • title — varchar(45)
  • status — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp

SEARCHES

  • Key (id) — bigint — Primary key — NOT NULL
  • search — varchar(20)
  • count — int

SMALCATEGORIES (SMALLCATEGORIES)

  • Key — bigint — Primary key — NOT NULL
  • id — bigint — Foreign key → CATEGORIES.id — NOT NULL
  • item_id — bigint — Foreign key → CATEGORIES.item_id — NOT NULL
  • title — varchar(20)

USERS

  • id — bigint — Primary key — NOT NULL
  • level_id — bigint — Foreign key → 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 — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • item_id — int — Foreign key → USERS.level_id — NOT NULL