Table: task_alert

Previous: task_account

Unanet Data Model

Next: task_alert_recipient

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	alert_key	decimal(15)
2.		project_key	decimal(15)		project	fk_task_alert1
3.		task_key	decimal(15)		task	fk_task_alert2
4.		alert_type	decimal(2)
5.		threshold	decimal(3)
6.		created	datetime

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
project_key	project	project_key	fk_task_alert1
task_key	task	task_key	fk_task_alert2

Referenced from

Table	Column	Foreign Key Name
task_alert_recipient	alert_key	fk_task_alert_recipient1

Check Constraints

Name	Definition
cc_ta_alert_type	([alert_type]=(11) OR [alert_type]=(10) OR [alert_type]=(9) OR [alert_type]=(8) OR [alert_type]=(7) OR [alert_type]=(6) OR [alert_type]=(5) OR [alert_type]=(4) OR [alert_type]=(3) OR [alert_type]=(2) OR [alert_type]=(1) OR [alert_type]=(0))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_task_alert	true	alert_key	Asc
idx_task_alert1	true	task_key	Asc
		alert_type
idx_task_alert2	false	project_key	Asc