alerts_projectalert


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('alerts_projectalert_id_seq'::regclass)
alerts_alertrecipient.alert_id alerts_alertrecipien_alert_id_e751a912_fk_alerts_pr R
alerts_notification.project_alert_id alerts_notification_project_alert_id_26a4df64_fk_alerts_pr R
timespan_minutes int2 5 √ null
quantity int2 5 √ null
created timestamptz 35,6 null
project_id int4 10 null
projects_project.id alerts_projectalert_project_id_d72e26b7_fk_projects_project_id R
name varchar 255 null
uptime bool 1 null

Indexes

Constraint Name Type Sort Column(s)
alerts_projectalert_pkey Primary key Asc id
alerts_projectalert_created_2fc73449 Performance Asc created
alerts_projectalert_project_id_d72e26b7 Performance Asc project_id

Check Constraints

Constraint Name Constraint
alerts_projectalert_quantity_check ((quantity >= 0))
alerts_projectalert_timespan_minutes_check ((timespan_minutes >= 0))

Relationships

Close relationships within degrees of separation