ad_scheduler

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_scheduler_id numeric 10 null
ad_scheduler_para.ad_scheduler_id adscheduler_adschedulerpara C
ad_schedulerlog.ad_scheduler_id adscheduler_log C
ad_schedulerrecipient.ad_scheduler_id adscheduler_recipient R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
ad_process_id numeric 10 null
ad_process.ad_process_id adprocess_adscheduler C
frequencytype bpchar 1 √ null
frequency numeric 10 √ null
datelastrun timestamptz 35,6 √ null
datenextrun timestamptz 35,6 √ null
supervisor_id numeric 10 null
ad_user.ad_user_id aduser_adscheduler R
keeplogdays numeric 10 null
processing bpchar 1 √ null
weekday bpchar 1 √ null
scheduletype bpchar 1 'F'::bpchar
monthday numeric 10 √ null
isignoreprocessingtime bpchar 1 √ 'N'::bpchar
cronpattern varchar 255 √ NULL::character varying
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id adtable_adscheduler R
record_id numeric 10 √ NULL::numeric
ad_scheduler_uu varchar 36 √ NULL::character varying
ad_schedule_id numeric 10 NULL::numeric
ad_schedule.ad_schedule_id adschedule_adscheduler R
r_mailtext_id numeric 10 √ NULL::numeric
r_mailtext.r_mailtext_id rmailtext_adscheduler R
reporttype varchar 5 √ null
ad_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_adscheduler R
cof_armazenamentonuvem_id numeric 10 √ NULL::numeric
cof_armazenamentonuvem.cof_armazenamentonuvem_id cofarmazenamentonuvem_adschedu R
reportoutputtype varchar 4 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_scheduler_pkey Primary key Asc ad_scheduler_id
ad_scheduler_uu_idx Must be unique Asc ad_scheduler_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation