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