경자

테이블 (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