경자
테이블 (7)
category
- id — BIGSERIAL
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
comment (comments)
- id — BIGSERIAL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- parent_id — BIGINT
- like_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
like (likes)
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- post_id — BIGINT
- comment_id — BIGINT
- created_at — TIMESTAMP
- CHECK — ( (post_id IS NOT NULL AND comment_id IS NULL) — NOT NULL
market_chat (market_chats)
- id — BIGSERIAL
- post_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
market_post (market_posts)
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- location_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- images — JSONB
- price — INTEGER — NOT NULL
- category_id — BIGINT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- like_count — INTEGER
- deleted_at — TIMESTAMP
post (posts)
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- category_id (category) — INTEGER — NOT NULL
- view_count — INTEGER
- like_count — INTEGER
- comment_count — INTEGER
- deleted_at — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user (users)
- id — BIGSERIAL
- phone_number — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- email — VARCHAR(100)
- nickname — VARCHAR(50) — NOT NULL
- profile_url — TEXT
- refresh_token — TEXT
- is_verified — BOOLEAN
- last_login_at — TIMESTAMP
- user_role — VARCHAR(20)
- auth_provider — VARCHAR(30)
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP