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