ktb-6팀-erd1

테이블 (5)

chat_message

  • id — bigint — 기본 키 — NOT NULL — ULID 값으로 생성
  • chatroom_id — bigint — 외래 키 → chatroom.id — NOT NULL
  • content — varchar(500) — NOT NULL
  • sender_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL

chatroom

  • id — bigint — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • seller_id — bigint — 외래 키 → users.id — NOT NULL
  • buyer_id — bigint — 외래 키 → users.id — NOT NULL
  • last_message_id — bigint
  • seller_last_read_message_id — bigint
  • seller_last_read_at — datetime(6)
  • buyer_last_read_message_id — bigint
  • buyer_last_read_at — datetime(6)
  • created_at — datetime(6) — NOT NULL

post

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — varchar(2000) — NOT NULL
  • rental_fee — bigint — NOT NULL
  • fee_unit — enumerate — NOT NULL — 'HOUR'과 'DAY' 중 선택
  • rental_status — enumerate — NOT NULL — "AVAILABLE'과 'RENT_OUT' 중 선택', `is_deleted` boolean NOT NULL DEFAULT false, `created_at` datetime(6) NOT NULL, `updated…

post_image

  • id — bigint — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • image_url — varchar(250) — NOT NULL
  • sort_order — tinyint — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

users

  • id — bigint — 기본 키 — NOT NULL
  • login_id — varchar(20) — NOT NULL
  • password — varchar(100) — NOT NULL
  • nickname — varchar(6) — NOT NULL
  • avatar_url — varchar(250) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)