ad_window

606 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_window_id numeric 10 null
ad_importtemplate.ad_window_id adwindow_adimporttemplate R
ad_infowindow.ad_window_id adwindow_adinfowindow R
ad_infowindow.po_window_id powindow_adinfowindow R
ad_issue.ad_window_id adwindow_adissue N
ad_menu.ad_window_id adwindow_admenu R
ad_package_exp_common.ad_window_id adwindow_adpackageexpcommon R
ad_package_exp_detail.ad_window_id adwindow_adpackageexpdetail R
ad_preference.ad_window_id ad_window_preference R
ad_printformat.ad_window_id adwindow_adprintformat R
ad_recentitem.ad_window_id adwindow_adrecentitem C
ad_ref_table.ad_window_id adwindow_adreftable R
ad_searchdefinition.ad_window_id adwindow_adsearchdefinition R
ad_searchdefinition.po_window_id powindow_adsearchdefinition R
ad_statuslineusedin.ad_window_id adwindow_adstatuslineusedin R
ad_tab.ad_window_id ad_window_tab C
ad_table.ad_window_id ad_window_table N
ad_table.po_window_id adwindowpo_adtable R
ad_toolbarbuttonrestrict.ad_window_id adwindow_adtoolbarbuttonrestri R
ad_userdef_info.ad_window_id adwindow_aduserdefinfo R
ad_userdef_info.po_window_id powindow_aduserdefinfo R
ad_userdef_win.ad_window_id adwindow_aduserdefwin R
ad_userquery.ad_window_id adwindow_aduserquery R
ad_wf_node.ad_window_id adwindow_adwfnode R
ad_window_access.ad_window_id adwindow_adwindowaccess C
ad_window_trl.ad_window_id ad_windowtrl C
ad_workbenchwindow.ad_window_id adwindow_adworkbenchwindow R
ad_zoomcondition.ad_window_id adwindow_adzoomcondition R
asp_clientexception.ad_window_id adwindow_aspclientexception R
asp_window.ad_window_id adwindow_aspwindow R
pa_dashboardcontent.ad_window_id adwindow_padashboardcontent R
pa_documentstatus.ad_window_id adwindow_padocumentstatus R
pp_order_node.ad_window_id adwindow_ppordernode R
ad_client_id numeric 10 null
ad_client.ad_client_id windowclient R
ad_org_id numeric 10 null
ad_org.ad_org_id windoworg R
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
windowtype bpchar 1 √ null
issotrx bpchar 1 'Y'::bpchar
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adwindow R
processing bpchar 1 √ null
ad_image_id numeric 10 √ null
ad_image.ad_image_id adimage_adwindow R
ad_color_id numeric 10 √ null
ad_color.ad_color_id adcolor_adwindow R
isdefault bpchar 1 'N'::bpchar
winheight numeric 10 √ null
winwidth numeric 10 √ null
isbetafunctionality bpchar 1 'N'::bpchar
ad_window_uu varchar 36 √ NULL::character varying
titlelogic varchar 255 √ NULL::character varying
predefinedcontextvariables varchar 4000 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_window_pkey Primary key Asc ad_window_id
ad_window_name Must be unique Asc/Asc ad_client_id + name
ad_window_uu_idx Must be unique Asc ad_window_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation