짓다

테이블 (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