ver2
Tables (6)
change_event
- change_id — INT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
- severity — VARCHAR(20)
- effective_date — DATE
- created_by_user_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
change_task_link
- id — INT — Primary key — NOT NULL
- change_id — INT — NOT NULL
- task_id — INT — NOT NULL
- link_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
rule
- rule_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(100)
- severity_min — VARCHAR(20)
- keyword_like — VARCHAR(100)
- default_title — VARCHAR(200) — NOT NULL
- default_due_in_days — INT
- default_owner_user_id — INT
- priority — INT
- is_active — BOOLEAN — NOT NULL
task
- task_id — INT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
- priority — VARCHAR(20)
- due_date — DATE
- owner_user_id — INT
- created_at — DATETIME — NOT NULL
team
- team_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- team_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- position — VARCHAR(100)