ad_infowindow

67 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_infowindow_id numeric 10 null
ad_column.ad_infowindow_id adinfowindow_adcolumn N
ad_ctxhelp.ad_infowindow_id Implied Constraint R
ad_field_v.ad_infowindow_id Implied Constraint R
ad_field_vt.ad_infowindow_id Implied Constraint R
ad_infocolumn.ad_infowindow_id adinfowindow_adinfocolumn C
ad_infoprocess.ad_infowindow_id adinfowindow_adinfoprocess C
ad_inforelated.ad_infowindow_id adinfowindow_adinforelated R
ad_inforelated.relatedinfo_id relatedinfo_adinforelated R
ad_infowindow_access.ad_infowindow_id adinfowindow_adinfowindowacces C
ad_infowindow_trl.ad_infowindow_id adinfowindow_adinfowindowtrl C
ad_menu.ad_infowindow_id adinfowindow_admenu R
ad_package_exp_detail.ad_infowindow_id adinfowindow_adpackageexpdetai R
ad_preference.ad_infowindow_id ad_infowindow_preference R
ad_ref_table.ad_infowindow_id adinfowindow_adreftable R
ad_userdef_info.ad_infowindow_id adinfowindow_aduserdefinfo C
ad_wf_node.ad_infowindow_id adinfowindow_adwfnode 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
ad_table_id numeric 10 null
ad_table.ad_table_id adtable_adinfowindow R
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adinfowindow R
fromclause varchar 2000 null
otherclause varchar 2000 √ null
processing bpchar 1 √ null
ad_infowindow_uu varchar 36 √ NULL::character varying
whereclause varchar 2000 √ NULL::character varying
isdefault bpchar 1 'N'::bpchar
isdistinct bpchar 1 'N'::bpchar
orderbyclause varchar 2000 √ NULL::character varying
isvalid bpchar 1 'N'::bpchar
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adinfowindow R
imageurl varchar 120 √ NULL::character varying
seqno numeric 10 √ NULL::numeric
isshowindashboard bpchar 1 'Y'::bpchar
ad_process_id numeric 10 √ NULL::numeric
ad_process.ad_process_id adprocess_adinfowindow R
maxqueryrecords numeric 10 (0)::numeric
isloadpagenum bpchar 1 √ 'Y'::bpchar
cof_fieldstyle_id numeric 10 √ NULL::numeric
pagingsize numeric 10 '0'::numeric
ad_window_id numeric 10 √ NULL::numeric
ad_window.ad_window_id adwindow_adinfowindow R
po_window_id numeric 10 √ NULL::numeric
ad_window.ad_window_id powindow_adinfowindow R

Indexes

Constraint Name Type Sort Column(s)
ad_infowindow_pkey Primary key Asc ad_infowindow_id
ad_infowindow_unique_name Must be unique Asc/Asc ad_client_id + name
ad_infowindow_uu_idx Must be unique Asc ad_infowindow_uu

Check Constraints

Constraint Name Constraint
ad_infowindow_isdistinct_check ((isdistinct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infowindow_isdefault_check ((isdefault = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infowindow_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infowindow_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infowindow_isloadpagenum_check ((isloadpagenum = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infowindow_isshowindashboard_check ((isshowindashboard = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation