hello-foreigner

Tables (9)

chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • last_message_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

chat_users

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

chats

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • is_filtered — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

feeds

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • image — VARCHAR(255)
  • content — TEXT — NOT NULL
  • num_of_likes — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

interests

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

likes

  • id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feeds.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

translate_chats

  • id — BIGINT — Primary key — NOT NULL
  • chat_id — BIGINT — Foreign key → chats.id — NOT NULL
  • content — TEXT — NOT NULL
  • langudage (language) — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

user_interests

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • interest_id — BIGINT — Foreign key → interests.id — NOT NULL
  • score — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • country — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • preferred_language — VARCHAR(10) — NOT NULL
  • major — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME