talkbattle

Tables (8)

chat_message

  • message_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('sent','delivered','read')
  • created_at — DATETIME

chat_participant

  • room_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • joined_at — DATETIME
  • last_read_at — DATETIME

chat_room

  • room_id — BIGINT
  • room_type — ENUM('private','group') — NOT NULL
  • created_at — DATETIME

comment

  • comment_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • parent_type — ENUM('post', 'comment') — NOT NULL
  • parent_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • status — TINYINT — 1:활성, 0:삭제
  • created_at — DATETIME
  • updated_at — DATETIME

member_info

  • member_id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • email — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • password_hash — VARCHAR(255)
  • status — TINYINT — NOT NULL — 0:비인증, 1:일반, 2:휴면, 99:탈퇴
  • created_at — DATETIME
  • updated_at — DATETIME

member_profile

  • profile_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • profile_type — ENUM('default','custom') — NOT NULL
  • profile_url — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

member_sms_auth

  • sms_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • code — VARCHAR(6) — NOT NULL
  • created_at — DATETIME
  • expires_at — DATETIME — NOT NULL

member_sns

  • sns_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • provider — ENUM('google','kakao','naver','apple') — NOT NULL
  • sns_uid — VARCHAR(100) — NOT NULL
  • access_token — VARCHAR(255)
  • refresh_token — VARCHAR(255)
  • connected_at — DATETIME