temp
Tables (8)
comment (Untitled8)
- comment_id (Key) — Primary key — NOT NULL
- task_id (Key2) — Foreign key → task.task_id — NOT NULL
- registrant_account (Field3)
- created_at (Field)
- content (Field2)
milestone (Untitled7)
- milestone_id (Key) — Primary key — NOT NULL
- milestone (Field)
- project_id (Key2) — Foreign key → project.project_id — NOT NULL
project (Untitled)
- project_id (Key) — Primary key — NOT NULL
- status_id (Key2) — Foreign key → project_status.status_id — NOT NULL
- project_name (Field)
project_authority (Untitled5)
- authority_id (Key) — Primary key — NOT NULL
- authority_name (Field)
project_member (Untitled4)
- account_id (Key2) — Primary key — NOT NULL
- project_id (Key) — Foreign key → project.project_id — NOT NULL
- authority_id (Key3) — Foreign key → project_authority.authority_id — NOT NULL
project_status (Untitled6)
- status_id (Key) — Primary key — NOT NULL
- status (Field)
tag (Untitled3)
- tag_id (Key) — Primary key — NOT NULL
- project_id (Key2) — Foreign key → project.project_id — NOT NULL
- tag_name (Field)
task (Untitled2)
- task_id (Key) — Primary key — NOT NULL
- milestone_id (Key2) — Foreign key → milestone.milestone_id — NOT NULL
- project_id (Key3) — Foreign key → project.project_id — NOT NULL
- tag_id (Key4) — Foreign key → tag.tag_id — NOT NULL
- title (Field4)
- content (Field)
- registrant_account (Field3)
- created_at (Field2)
- expire_date (Field5)