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