Table: project_alert

Previous: project_account

Unanet Data Model

Next: project_alert_prefs

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_project_alert1
3.		alert_type	decimal(2)
4.		threshold	decimal(3)
5.		created	datetime

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
project_key	project	project_key	fk_project_alert1

Referenced from

Table	Column	Foreign Key Name
project_alert_recipient	alert_key	fk_project_alert_recipient1

Check Constraints

Name	Definition
cc_pa_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_project_alert	true	alert_key	Asc
idx_project_alert1	true	project_key	Asc
		alert_type