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)