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