마켓컬리
테이블 (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