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