test
Tables (14)
address
- user_id — BIGINT — Foreign key → users.user_id
- address — VARCHAR(255) — NOT NULL
- dong — VARCHAR(255) — NOT NULL
- point — VARCHAR(255)
- sido — VARCHAR(255) — NOT NULL
- sigungu — VARCHAR(255) — NOT NULL
chat_events
- id — BIGINT
- chat_id — BIGINT — NOT NULL
- post_id — BIGINT
chat_images
- id — BIGINT
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- chat_id — BIGINT — NOT NULL
chat_last_read
- room_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- chat_id — BIGINT — NOT NULL
chats
- id — BIGINT
- chat_type — VARCHAR(20) — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- is_done — BOOLEAN
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
images
- id — BIGINT
- created_at — DATETIME — NOT NULL
- main_image — BOOLEAN — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- saved_name — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- post_id — BIGINT — NOT NULL
likes
- id — BIGINT
- created_at — DATETIME — NOT NULL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
post_progress
- id — BIGINT
- post_status — VARCHAR(20) — NOT NULL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
posts
- id — BIGINT
- content — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- price — INT — NOT NULL
- product_category — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- updated_at — DATETIME — NOT NULL
- user_id — BIGINT — NOT NULL
refresh_tokens
- user_id — BIGINT
- token — VARCHAR(255) — NOT NULL
room_progress
- id — BIGINT
- room_progress — VARCHAR(20) — NOT NULL
- target_post — BIGINT — NOT NULL
- request_user_id — BIGINT — NOT NULL
rooms
- id — BIGINT
- is_active — BOOLEAN — NOT NULL
- buyer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
user_verify
- user_id — BIGINT
- expires_at — DATETIME — NOT NULL
- token — VARCHAR(255) — NOT NULL
- verity_type — VARCHAR(20)
users
- user_id — BIGINT — Primary key
- created_at — DATETIME — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- provider — VARCHAR(20)
- role — VARCHAR(20)
- updated_at — DATETIME — NOT NULL
- verify — BOOLEAN