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