ad_schedule

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_schedule_id numeric 10 NULL::numeric
ad_alertprocessor.ad_schedule_id adschedule_adalertprocessor R
ad_scheduler.ad_schedule_id adschedule_adscheduler R
ad_workflowprocessor.ad_schedule_id adschedule_adworkflowprocessor R
c_acctprocessor.ad_schedule_id adschedule_cacctprocessor R
r_requestprocessor.ad_schedule_id adschedule_rrequestprocessor R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
cronpattern varchar 255 √ NULL::character varying
description varchar 225 √ NULL::character varying
frequency numeric 10 √ NULL::numeric
frequencytype bpchar 1 √ NULL::bpchar
isactive varchar 1 'Y'::character varying
monthday numeric 10 √ NULL::numeric
runonlyonip varchar 60 √ NULL::character varying
scheduletype bpchar 1 √ 'F'::bpchar
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
weekday bpchar 1 √ NULL::bpchar
name varchar 60 NULL::character varying
ad_schedule_uu varchar 36 √ NULL::character varying
isignoreprocessingtime bpchar 1 'N'::bpchar
issystemschedule bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_schedule_key Primary key Asc ad_schedule_id
ad_schedule_uu_idx Must be unique Asc ad_schedule_uu

Check Constraints

Constraint Name Constraint
ad_schedule_isignoreprocessingtime_check ((isignoreprocessingtime = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_schedule_issystemschedule_check ((issystemschedule = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation