중고 경매
테이블 (10)
auction
- id — SERIAL
- product_id — INTEGER — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- /* — 어떤 — NOT NULL
- /* — 어떤 — NOT NULL
- current_winner_id — INTEGER
- status — VARCHAR(20)
bid
- id — SERIAL
- auction_id — INTEGER — NOT NULL
- product_id — INTEGER — NOT NULL
- bidder_id — INTEGER — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- is_winning — BOOLEAN
category
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- parent_category_id — INTEGER
chat_messages
- id — BIGSERIAL
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
favorite
- id — SERIAL
- user_id — INTEGER — NOT NULL
- product_id — INTEGER — NOT NULL
- added_at — TIMESTAMP
- UNIQUE(user_id, — product_id)
notification
- id — SERIAL
- user_id — INTEGER — NOT NULL
- notification_type — VARCHAR(20) — NOT NULL
- system) — )
- reference_id — INTEGER
- content — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
order
- id — SERIAL
- product_id — INTEGER — NOT NULL
- buyer_id — INTEGER — NOT NULL
- seller_id — INTEGER — NOT NULL
- shipping_address_id — INTEGER — NOT NULL
- final_price — DECIMAL(10, 2) — NOT NULL
- order_date — TIMESTAMP
- payment_method — VARCHAR(20) — NOT NULL
- other) — )
- payment_status — VARCHAR(20)
- refunded) — )
- shipping_status — VARCHAR(20)
- returned) — )
- tracking_number — VARCHAR(100)
product
- id — SERIAL
- seller_id — INTEGER — NOT NULL
- category_id — INTEGER
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- base_price — DECIMAL(10, 2) — NOT NULL
- condition — VARCHAR(50) — NOT NULL
- is_sold — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
shipping_address
- id — SERIAL
- user_id — INTEGER — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- address_line1 — VARCHAR(255) — NOT NULL
- address_line2 — VARCHAR(255)
- city — VARCHAR(100) — NOT NULL
- state_province — VARCHAR(100)
- postal_code — VARCHAR(20) — NOT NULL
- country — VARCHAR(100) — NOT NULL
- is_default — BOOLEAN
user
- id — SERIAL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP