CC
Tables (12)
available_lang
- available_lang_id — INT — Primary key — NOT NULL
- lang — VARCHAR(255) — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
chat_room
- room_id — INT — Primary key — NOT NULL
- room_name — VARCHAR(50)
- created_at — DATETIME — NOT NULL
desired_lang
- desired_lang_id — INT — Primary key — NOT NULL
- lang — VARCHAR(255) — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
message
- message_id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- sent_at — DATETIME — NOT NULL
- user_id — INT — Foreign key — NOT NULL
- room_id — INT — Foreign key — NOT NULL
participate
- participate_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- room_id — INT — Foreign key → chat_room.room_id — NOT NULL
post
- post_id — INT — Primary key — NOT NULL
- post_title — VARCHAR(255)
- post_content — VARCHAR(255)
- language — VARCHAR(255)
- face_to_face — VARCHAR(255)
- day_of_week — BIGINT
- time_info — DATETIME
- user_id — INT — Foreign key → users.user_id — NOT NULL
- room_id — INT — Foreign key → chat_room.room_id — NOT NULL
report
- repost_id — INT — Primary key — NOT NULL
- report_reason — VARCHAR(255)
- reported_user — INT — Foreign key → users.user_id — NOT NULL
- report_user — INT — Foreign key → users.user_id — NOT NULL
student_database
- student_id (Key) — Primary key — NOT NULL
- student_id — VARCHAR(255)
- student_name — VARCHAR(255) — NOT NULL
- major — VARCHAR(255) — NOT NULL
user_authentication
- student_id — INT — Primary key — NOT NULL
- student_name — VARCHAR(255) — NOT NULL
- major — VARCHAR(255) — NOT NULL
user_chat
- room_id — INT — Foreign key — NOT NULL
- Key — Foreign key → chat_room.room_id — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
users
- user_id — INT — Primary key — NOT NULL
- password — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birthday — DATE — NOT NULL
- school — VARCHAR(50) — NOT NULL
- student_id — INT — NOT NULL
- major — VARCHAR(50) — NOT NULL
- spoken_language — VARCHAR(50) — NOT NULL
- target_language — VARCHAR(50) — NOT NULL
weekly
- weekly_id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key — NOT NULL
- week — VARCHAR(255)
- Key — Foreign key → post.post_id — NOT NULL