eee

Tables (12)

Inspector

  • inspector_id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR
  • name — VARCHAR
  • email — VARCHAR
  • status — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — BOOLEAN
  • deleted_at — TIMESTAMP

Untitled

  • inspect_order_id — BIGINT — Primary key — NOT NULL
  • inspector_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • user_id2 — VARCHAR(255) — NOT NULL
  • id2 — BIGINT

brands

  • brand_id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • logo_url — VARCHAR(255)

buying_bids

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • product_size_id — BIGINT
  • price — INT — NOT NULL — 구매 희망가
  • status — VARCHAR(20) — LIVE, MATCHED, CANCELLED
  • deadline — TIMESTAMP — 입찰 마감기한
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • isdeleted — BOOLEAN
  • address — VARCHAR(20)
  • payment — VARCHAR(20)

orders

  • id — BIGINT — Primary key
  • buyer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • product_size_id — BIGINT
  • price — INT — NOT NULL — 최종 거래 가격
  • status — VARCHAR(50) — PENDING_SHIPMENT, ARRIVED_AT_CENTER, IN_INSPECTION, INSPECTION_PASSED, INSPECTION_FAILED, SHIPPED_TO_BUYER, COMPLETED,…
  • tracking_number — VARCHAR(100) — 판매자 -> 플랫폼 운송장
  • inspection_result — VARCHAR(255) — 검수 소견
  • final_tracking_number — VARCHAR(100) — 플랫폼 -> 구매자 운송장
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP — 상태 변경 시간
  • inspector_id — BIGINT — NOT NULL

product_sizes

  • id — BIGINT — Primary key
  • product_id — BIGINT — NOT NULL
  • size — VARCHAR(50) — NOT NULL — 230, 240, XL, L 등

products

  • product_id — BIGINT — Primary key — NOT NULL
  • brand_id — BIGINT — Foreign key → brands.brand_id
  • name — VARCHAR(255) — NOT NULL
  • model_number — VARCHAR(100) — 모델 번호
  • category — VARCHAR(50)
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP

reviews

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id — NOT NULL
  • content — TEXT
  • rating — INT — 1~5점
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP

selling_bids

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • product_size_id — BIGINT
  • price — INT — NOT NULL — 판매 희망가
  • status — VARCHAR(20) — LIVE, MATCHED, CANCELLED
  • deadline — TIMESTAMP — 입찰 마감기한
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • isdeleted — BOOLEAN

staffs

  • staff_id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR
  • name — VARCHAR
  • email — VARCHAR
  • employee_id — BIGINT
  • role — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — BOOLEAN

users

  • user_id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR
  • nickname — VARCHAR
  • email — VARCHAR
  • account_number — VARCHAR
  • address — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • isdeleted — BOOLEAN

wishlists

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id — NOT NULL