짓다
테이블 (14)
addresses
- address_id — CHAR(13)
- user_id — BIGINT — NOT NULL
- recipient — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- address1 — VARCHAR(255) — NOT NULL
- address2 — VARCHAR(255)
- is_default — BOOLEAN
- created_at — TIMESTAMP
coupons
- coupon_id — BIGINT
- name — VARCHAR(200)
- discount_type — VARCHAR(20)
- discount_value — INT — NOT NULL
- min_amount — INT
- max_discount — INT
- valid_from — DATETIME
- valid_to — DATETIME
- created_at — TIMESTAMP
grades
- grade_code — VARCHAR(20)
- name — VARCHAR(50) — NOT NULL
- point_rate — DECIMAL(5,4)
- description — VARCHAR(255)
- priority — INT
- created_at — TIMESTAMP
inquiries
- inquiry_id — BIGINT
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- answered_at — TIMESTAMP
likes
- user_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 기본 키 — NOT NULL
- created_at — TIMESTAMP
order_detail
- order_detail_id — BIGINT
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- option_value_id — BIGINT
- price — INT — NOT NULL
- quantity — INT — NOT NULL
- subtotal — INT — NOT NULL
orders
- order_id — BIGINT
- user_id — BIGINT — NOT NULL
- address_id — CHAR(13) — NOT NULL
- total_amount — INT — NOT NULL
- discount_total — INT
- final_amount — INT — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payments
- payment_id — BIGINT
- order_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- method — VARCHAR(50)
- status — VARCHAR(20)
- pg_tid — VARCHAR(100)
- paid_at — TIMESTAMP
- created_at — TIMESTAMP
product_images
- image_id — BIGINT
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- is_main — BOOLEAN
- sort_order — INT
- created_at — TIMESTAMP
product_option_values
- option_value_id — BIGINT
- option_id — BIGINT — NOT NULL
- value_name — VARCHAR(100) — NOT NULL
- price_add — INT
- stock — INT
- created_at — TIMESTAMP
product_options
- option_id — BIGINT
- product_id — BIGINT — NOT NULL
- option_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
products
- product_id — BIGINT
- seller_id — BIGINT
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- is_option — BOOLEAN
- stock — INT
- status — VARCHAR(20)
- category — ENUM('가구','조명','인테리어소품','생활','DIY') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_coupons
- user_coupon_id — BIGINT
- user_id — BIGINT — NOT NULL
- coupon_id — BIGINT — NOT NULL
- is_used — BOOLEAN
- used_at — TIMESTAMP
- created_at — TIMESTAMP
users
- user_id — BIGINT
- email — VARCHAR(200) — NOT NULL
- password — VARCHAR(255)
- oauth_provider — ENUM('KAKAO','GOOGLE','NAVER','LOCAL')
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- image_url — VARCHAR(500)
- grade_code — VARCHAR(20)
- point — INT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP