Prototype

Tables (11)

ChatMessage (chatmessage)

  • ChatMessage ID (message_id) — INT(11) — Primary key — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • ChatRoom ID (chatroom_id) — INT(11) — Foreign key → ChatRoom.ChatRoom ID — NOT NULL
  • Content (message_content) — VARCHAR(255)
  • Message Time (message_time) — DateTime

ChatRoom (chatroom)

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

ChatRoomJoin (chatroom_join)

  • ChatRoom Join ID (join_id) — INT(11) — Primary key — NOT NULL
  • ChatRoom ID (chatroom_id) — INT(11) — Foreign key → ChatRoom.ChatRoom ID — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Join Date (join_at) — DateTime

Comments (comments)

  • Comment ID (comment_id) — INT(11) — Primary key — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Post ID (post_id) — INT(11) — Foreign key → Posts.Post ID — NOT NULL
  • Content (comment_content) — VARCHAR(255)
  • Comment Time (comment_time) — DateTime

Follow (follow_info)

  • Key (follow_id) — INT(11) — Primary key — NOT NULL
  • Follower (follower) — VARCHAR(255) — Foreign key → User.User ID — NOT NULL
  • Following (following) — VARCHAR(255) — Foreign key → User.User ID — NOT NULL
  • Folllow Time (follow_time) — DateTime

Posts (posts)

  • Post ID (post_id) — INT(11) — Primary key — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Title (post_title) — VARCHAR(255)
  • Content (post_content) — VARCHAR(255)
  • Post Time (post_time) — DateTime

Project (project)

  • Project ID (project_id) — INT(11) — Primary key — NOT NULL
  • Project Title (project_title) — VARCHAR(255)
  • Project Abstract (project_abstract) — VARCHAR(255)
  • Create Date (create_at) — DateTime
  • Update Date (update_at) — DateTime

ProjectJoin (project_join)

  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Project ID (project_id) — INT(11) — Foreign key → Project.Project ID — NOT NULL
  • Join Date (join_time) — DateTime

ProjectPost (project_post)

  • PostID (post_id) — INT(11) — Primary key — NOT NULL
  • Project ID (project_id) — INT(11) — Foreign key → Project.Project ID — NOT NULL
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Post Type (post_type) — CHAR(2)
  • Post Title (post_tite) — VARCHAR(255)
  • Post Content (post_content) — VARCHAR(255)
  • Post Time (post_time) — DateTime

Terms (user_terms)

  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Service Usage (terms_service_usage) — BOOLEAN
  • Privacy Info (terms_privacy_info) — BOOLEAN
  • Event Notice (terms_event_notice) — BOOLEAN

User (user_info)

  • User ID (user_id) — INT(11) — Primary key — NOT NULL
  • Name (user_name) — VARCHAR(255)
  • Password (user_password) — VARCHAR(255)
  • Phone Number (user_phone_number) — VARCHAR(255)
  • Gender (user_gender) — CHAR(2)
  • Birthday (user_birthday) — VARCHAR(255)
  • Region (user_resion) — VARCHAR(255)
  • Research Field (user_research_field) — VARCHAR(255)
  • Update Date (update_at) — DateTime
  • Create Date (create_at) — DateTime