SNS_DB
Tables (8)
CHAT_ROOMS
- room_id — TEXT
- room_type — TEXT — NOT NULL
- name — TEXT
- created_by_user_id — TEXT — NOT NULL
- created_at — TEXT
- last_message_id — TEXT
- last_message_preview — TEXT
- updated_at — TEXT
FRIENDSHIPS
- friendship_id — TEXT
- user_id_1 — TEXT — NOT NULL
- user_id_2 — TEXT — NOT NULL
- status — TEXT — NOT NULL
- created_at — TEXT
- updated_at — TEXT
MEDIA_FILES
- media_id — TEXT
- uploader_user_id — TEXT — NOT NULL
- file_type — TEXT — NOT NULL
- file_url — TEXT — NOT NULL
- thumbnail_url — TEXT
- file_size — INTEGER
- created_at — TEXT
MESSAGES
- message_id — TEXT
- room_id — TEXT — NOT NULL
- sender_id — TEXT — NOT NULL
- message_type — TEXT — NOT NULL
- content — TEXT — NOT NULL
- timestamp — TEXT
- status — TEXT — NOT NULL
- created_at — TEXT
ROOM_MESSAGES_BY_USER
- user_id — TEXT — Primary key — NOT NULL
- room_id — TEXT — Primary key — NOT NULL
- last_read_message_id — TEXT
- unread_count — INTEGER
- last_updated_at — TEXT
ROOM_PARTICIPANTS
- room_participant_id — TEXT
- room_id — TEXT — NOT NULL
- user_id — TEXT — NOT NULL
- joined_at — TEXT
- left_at — TEXT
- notification_enabled — INTEGER
- is_admin — INTEGER
- last_read_timestamp — TEXT
USERS
- user_id — TEXT
- email — TEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- nickname — TEXT — NOT NULL
- profile_image_url — TEXT
- status_message — TEXT
- phone_number — TEXT
- created_at — TEXT
- updated_at — TEXT
- last_login_at — TEXT
USER_SETTINGS
- setting_id — TEXT
- user_id — TEXT — NOT NULL
- notification_sound — TEXT
- theme_preference — TEXT
- privacy_level — TEXT
- created_at — TEXT
- updated_at — TEXT