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