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