bikemarket
Tables (5)
chat_messages
- id — BIGINT
- room_id — BIGINT — NOT NULL
- sender_id — UUID — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_rooms
- id — BIGINT
- product_id — BIGINT — NOT NULL
- buyer_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
favorites
- user_id — UUID — Primary key — NOT NULL
- product_id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
products
- id — BIGINT
- seller_id — UUID — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- price — INT — NOT NULL
- image_urls — TEXT — NOT NULL
- category — VARCHAR(30) — NOT NULL
- location — VARCHAR(50) — NOT NULL
- status — product_status — NOT NULL
- view_count — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
profiles
- id — UUID
- nickname — VARCHAR(20) — NOT NULL
- profile_image_url — TEXT
- location — VARCHAR(50)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL