todo_list_project
Tables (13)
Comment Table (t_comment)
- Unique ID (id) — int — Primary key — NOT NULL
- Parent comment ID (parent_id) — int
- Comment (comment) — int
- Created Datetime (created_at) — timestamp
- Comment Type (comment_type) — varchar
- Task ID (task_id) — int
- Comment creator (user_id) — int — Foreign key → User table.User ID — NOT NULL
- Comment replied user (reply_user_id) — int — Foreign key → User table.User ID — NOT NULL
Feedback table (t_feedback)
- Task ID (id) — int — Primary key — NOT NULL
- Feedback description (description) — text
- Created Datetime (created_at) — timestamp
- Updated Datetime (updated_at) — timestamp
- Started Datetime (started_at) — timestamp
- End Datetime (end_at) — timestamp
- Expires Datetime (expires_at) — timestamp
- Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
- STATUS (status) — varchar
- Review (review) — int
- Field
Files table (t_files)
- File ID (id) — int — Primary key — NOT NULL
- Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
- Task Type (task_type) — varchar
- File Name (file_name) — varchar
- File Type (file_type) — varchar
- Created Date (created_at) — timestamp
- Field
Menu Roles Table (t_menu_roles)
- Unique ID (id) — int — Primary key — NOT NULL
- Role ID (role_id) — int — Foreign key → Role table.Role ID — NOT NULL
- Menu ID (menu_id) — int — Foreign key → Menu table.Menu ID — NOT NULL
Menu table (t_menu)
- Menu ID (id) — int — Primary key — NOT NULL
- Menu Name (menu_name) — varchar
- URL (url) — varchar
Notification Type table (t_notification_types)
- Unique ID (id) — int — Primary key — NOT NULL
- Notification type name (type_name) — varchar
- Field
Notification table (t_notifications)
- Unique Notification ID (id) — int — Primary key — NOT NULL
- Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
- Notification Type ID (type_id) — int — Foreign key → Notification Type table.Unique ID — NOT NULL
- Receiver User ID (receiver_id) — int — Foreign key → User table.User ID — NOT NULL
- Actor User ID (actor_id) — int — Foreign key → User table.User ID — NOT NULL
- Notification Title (title) — varchar
- Notification Message (message) — varchar
- Shows whether the notification has already been viewed/read (read_yn) — varchar
- Created Datetime (created_at) — timestamp
Project table (t_project)
- Project ID (id) — int — Primary key — NOT NULL
- Project Name, Title (name) — varchar
- Project Description (description) — varchar
- Created datetime (created_at) — timestamp
- Updated Datetime (updated_at) — timestamp
Project users table (t_project_users)
- Project users ID (id) — int — Primary key — NOT NULL
- Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
- A number used to identify each employee in the project. (user_id) — int — Foreign key → User table.User ID — NOT NULL
- Created datetime (created_at) — timestamp
- Field
Role table (t_roles)
- Role ID (id) — int — Primary key — NOT NULL
- Role name (role) — varchar
- Created datetime (created_at) — timestamp
- Field
Task table (t_task)
- Task ID (id) — int — Primary key — NOT NULL
- Task description (description) — text
- Created Datetime (created_at) — timestamp
- Updated Datetime (updated_at) — timestamp
- Started Datetime (started_at) — timestamp
- End Datetime (end_at) — timestamp
- Expires Datetime (expires_at) — timestamp
- Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
- Feedback ID (feedback_id) — int — Foreign key → Feedback table.Task ID — NOT NULL
User table (t_users)
- User ID (id) — int — Primary key — NOT NULL
- User Name (name) — varchar
- User Email (email) — varchar
- User Phone (phone) — varchar
- Is the user being used? (use_yn) — varchar
- User Profile File ID (profile) — varchar
- User Password (password) — varchar
- User created datetime (created_at) — timestamp
- User profile updated datetime (updated_at) — timestamp
- User Role ID (role_id) — int — Foreign key → Role table.Role ID — NOT NULL
Users task table (t_task_users)
- Unique ID (id) — int — Primary key — NOT NULL
- Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
- User ID (user_id) — int — Foreign key → User table.User ID — NOT NULL