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