test
Tables (12)
auction_images
- auction_id — BIGINT — Primary key — NOT NULL
- image_id — BIGINT — Primary key — NOT NULL
auctions
- id — BIGINT
- seller_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- start_price — INT — NOT NULL
- buy_now_price — INT — NOT NULL
- upper_limit_price — INT — NOT NULL
- lower_limit_price — INT
- current_highest_bid — INT
- bid_count — INT — NOT NULL
- is_bid_public — SMALLINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed — SMALLINT — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
bids
- id — BIGINT
- auction_id — BIGINT — NOT NULL
- bidder_id — BIGINT — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
categories
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- parent_id — BIGINT
chat_messages
- id — BIGINT
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- type — VARCHAR(10) — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_rooms
- id — BIGINT
- room_uuid — CHAR(36) — NOT NULL
- product_type — VARCHAR(20) — NOT NULL
- product_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
images
- id — BIGINT
- url — VARCHAR(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
post_images
- post_id — BIGINT — Primary key — NOT NULL
- image_id — BIGINT — Primary key — NOT NULL
posts
- id — BIGINT — Primary key
- seller_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- price — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- deleted — SMALLINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
reputation_events
- id — BIGINT
- target_user_id — BIGINT — NOT NULL
- event_type — VARCHAR(20) — NOT NULL
- ref_type — VARCHAR(20) — NOT NULL
- ref_id — BIGINT — NOT NULL
- delta — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
reputations
- id — BIGINT
- user_id — BIGINT — NOT NULL
- score — DECIMAL(4,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- is_active — SMALLINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL