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)