kakaotalk
Tables (7)
Chat_room (채팅방)
- room_id (방_ID) — SERIAL — Primary key — NOT NULL
- room_type (방_유형) — VARCHAR(20) — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
Chat_room_member (채팅방참여자)
- membership_id (참여_ID) — SERIAL — Primary key — NOT NULL
- room_id (방_ID) — INT — Foreign key → Chat_room.room_id — NOT NULL
- user_id (사용자_ID) — INT — Foreign key → User.user_id — NOT NULL
- last_read_message_id (마지막_읽은_메시지_ID) — INT — Foreign key → Message.message_id
- joined_at (참여_일시) — TIMESTAMP — NOT NULL
Friend_Request (친구 요청)
- request_id (요청_id) — SERIAL — Primary key — NOT NULL
- sender_id (발신자_ID) — INT — Foreign key → User.user_id — NOT NULL
- receiver_id (수신자_ID) — INT — Foreign key → User.user_id — NOT NULL
- status (상태) — VARCHAR(20) — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
Friendship (친구관계)
- friendship_id (친구관계_ID) — SERIAL — Primary key — NOT NULL
- user_id (사용자_ID) — INT — Foreign key → User.user_id — NOT NULL
- friend_id (친구_ID) — INT — Foreign key → User.user_id — NOT NULL
Message (메시지)
- message_id (메시지_ID) — SERIAL — Primary key — NOT NULL
- room_id (방_ID) — INT — Foreign key → Chat_room.room_id — NOT NULL
- sender_id (발신자_ID) — INT — Foreign key → User.user_id — NOT NULL
- content (내용) — TEXT — NOT NULL
- message_type (메시지_유형) — VARCHAR(20) — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
Profile (프로필)
- profile_id (프로필_id) — SERIAL — Primary key — NOT NULL
- user_id (사용자_id) — INT — Foreign key → User.user_id — NOT NULL
- profile_img_url (프로필_이미지_URL) — VARCHAR(2083)
- background_img_url (배경_이미지_URL) — VARCHAR(2083)
- status_message (상태_메시지) — VARCHAR(255)
- updated_at (업데이트_일시) — TIMESTAMP — NOT NULL
User (사용자)
- user_id (사용자_ID) — SERIAL — Primary key — NOT NULL
- username (이름) — VARCHAR(50) — NOT NULL
- email (이메일) — VARCHAR(100) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- created_at (생성날짜) — TIMESTAMP — NOT NULL
- last_login (마지막로그인) — TIMESTAMP