a
Tables (5)
Resource
- Resource_id — int — Primary key — NOT NULL
- id (id2) — int — Foreign key → TaskDependency.id — NOT NULL
- Role_id — int — Foreign key → Role.Role_id — NOT NULL
- User_id — int — Foreign key → Role.User_id — NOT NULL
- Task_id — int — Foreign key → Role.Task_id — NOT NULL
- name — varchar
- task_id — int
Role
- Role_id — int — Primary key — NOT NULL
- User_id — int — Foreign key → User.User_id — NOT NULL
- Task_id — int — Foreign key → User.Task_id — NOT NULL
- name — varchar
Task
- Task_id — int — Primary key — NOT NULL
- name — varchar
- start_date — date
- end_date — date
- duration — int
- progress — int
- priority — varchar
- status — varchar
- parent_id — int
- assignee_id — int
TaskDependency
- id — int — Primary key — NOT NULL
- from_task_id — int
- to_task_id — int
- type — varchar
User
- User_id — int — Primary key — NOT NULL
- Task_id — int — Foreign key → Task.Task_id — NOT NULL
- name — varchar
- role_id — int