ad_form

68 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_form_id numeric 10 null
ad_form_access.ad_form_id adform_adformaccess C
ad_form_trl.ad_form_id adform_adformtrl R
ad_issue.ad_form_id adform_adissue N
ad_menu.ad_form_id adform_admenu R
ad_package_exp_common.ad_form_id adform_adpackageexpcommon R
ad_package_exp_detail.ad_form_id adform_adpackageexpdetail R
ad_preference.ad_form_id adform_adpreference R
ad_process.ad_form_id adform_adprocess R
ad_wf_node.ad_form_id adform_adwfnode R
ad_workbenchwindow.ad_form_id adform_adworkbenchwindow R
asp_clientexception.ad_form_id adform_aspclientexception R
asp_form.ad_form_id adform_aspform R
pa_documentstatus.ad_form_id adform_padocumentstatus R
pp_order_node.ad_form_id adform_ppordernode 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
help varchar 2000 √ null
accesslevel bpchar 1 null
classname varchar 60 √ null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adform R
isbetafunctionality bpchar 1 'N'::bpchar
jspurl varchar 120 √ null
ad_form_uu varchar 36 √ NULL::character varying
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adform R
imageurl varchar 120 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_form_pkey Primary key Asc ad_form_id
ad_form_uu_idx Must be unique Asc ad_form_uu

Check Constraints

Constraint Name Constraint
ad_form_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation