Draft1

Tables (16)

Chat Message (chatmessage)

  • Message ID (message_id) — INT(11) — Primary key — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • Chatroom ID (chatroom_id) — INT(11) — Foreign key → Chat Room.chatroom_id — NOT NULL
  • Message Content (message_content) — VARCHAR(255)
  • message_time — DateTime

Chat Room (chatroom)

  • chatroom_id — INT(11) — Primary key — NOT NULL

Chat Room Join (chatroom_join)

  • join_id — INT(11) — Primary key — NOT NULL
  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • chatroom_id — INT(11) — Foreign key → Chat Room.chatroom_id — NOT NULL
  • join_at — DateTime

Comments (comments)

  • comment_id — INT(11) — Primary key — NOT NULL
  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • post_id — INT(11) — Foreign key → posts.post_id — NOT NULL
  • comment_content — VARCHAR(255)
  • comment_time — DateTime

Project Join (project_join)

  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • project_id — INT(11) — Foreign key → project.project_id — NOT NULL
  • join_time — DateTime

User Information (user_info)

  • user_id — INT(11) — Primary key — NOT NULL
  • user_name — VARCHAR(255)
  • user_password — VARCHAR(255)
  • user_phone_number — VARCHAR(255)
  • user_gender — CHAR(2)
  • user_birthday — VARCHAR(255)
  • user_resion — VARCHAR(255)
  • user_research_field — VARCHAR(255)
  • update_at — DateTime
  • create_at — DateTime

field_project

  • field_id — INT(11) — Foreign key → research_field/tag/keyword.field_id — NOT NULL
  • project_id — INT(11) — Foreign key → project.project_id — NOT NULL

follow_info

  • follow_id — INT(11) — Primary key — NOT NULL
  • following (following_id) — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • follower (follower_id) — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • follow_time — DateTime

posts

  • post_id — INT(11) — Primary key — NOT NULL
  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • post_title — VARCHAR(255)
  • post_content — VARCHAR(255)
  • post_time — DateTime

project

  • project_id — INT(11) — Primary key — NOT NULL
  • project_title — VARCHAR(255)
  • project_abstract — VARCHAR(255)
  • create_at — DateTime
  • update_at — DateTime

project_post

  • post_id — INT(11) — Primary key — NOT NULL
  • project_id — INT(11) — Foreign key → project.project_id — NOT NULL
  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • post_type — CHAR(2)
  • post_tite — VARCHAR(255)
  • post_content — VARCHAR(255)
  • post_time — DateTime

research_field/tag/keyword (research_field)

  • field_id — INT(11) — Primary key — NOT NULL
  • field_name — VARCHAR(255) — NOT NULL
  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL

research_post

  • post_id — INT(11) — Foreign key → posts.post_id — NOT NULL
  • field_id — INT(11) — Foreign key → research_field/tag/keyword.field_id — NOT NULL

task

  • task_id — INT(11) — Primary key — NOT NULL
  • task_name (taks_name) — VARCHAR(255)
  • create_at — DATETIME
  • update_at — DATETIME
  • status — CHAR(1)
  • project_id — INT(11) — Foreign key → project.project_id — NOT NULL

task_join

  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • task_id — INT(11) — Foreign key → task.task_id — NOT NULL

user_terms

  • user_id — INT(11) — Foreign key → User Information.user_id — NOT NULL
  • terms_service_usage — BOOLEAN
  • terms_privacy_info — BOOLEAN
  • terms_event_notice — BOOLEAN