pa_dashboardcontent

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_dashboardcontent_id numeric 10 null
ad_column.pa_dashboardcontent_id padashboardcontent_adcolumn R
ad_userdef_field.pa_dashboardcontent_id padashboardcontent_aduserdeffi R
pa_dashboardcontent_access.pa_dashboardcontent_id padashboardcontacc_padashboard R
pa_dashboardcontent_trl.pa_dashboardcontent_id padashboardcontent_padashboard R
pa_dashboardpreference.pa_dashboardcontent_id padashboardcontent_padashpref R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
isactive bpchar 1 null
name varchar 120 null
ad_window_id numeric 10 √ null
ad_window.ad_window_id adwindow_padashboardcontent R
description varchar 255 √ null
html text 2147483647 √ null
line numeric 0 √ null
pa_goal_id numeric 10 √ null
pa_goal.pa_goal_id pagoal_padashboardcontent R
columnno numeric 10 √ (1)::numeric
zulfilepath varchar 255 √ null
iscollapsible bpchar 1 'Y'::bpchar
goaldisplay bpchar 1 √ 'T'::bpchar
pa_dashboardcontent_uu varchar 36 √ NULL::character varying
isshowindashboard bpchar 1 'Y'::bpchar
ad_process_id numeric 10 √ NULL::numeric
ad_process.ad_process_id adprocess_padashboardcontent R
isembedreportcontent bpchar 1 'N'::bpchar
processparameters varchar 2000 √ NULL::character varying
iscollapsedbydefault bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ 0
ad_user.ad_user_id aduser_padashboardcontent R
ad_role_id numeric 10 √ 0
ad_role.ad_role_id adrole_padashboardcontent R
isshowinlogin bpchar 1 √ 'Y'::bpchar
ad_chart_id numeric 10 √ NULL::numeric
ad_chart.ad_chart_id adchart_padashboardcontent R
isshowtitle bpchar 1 'Y'::bpchar
ad_statusline_id numeric 10 √ NULL::numeric
ad_statusline.ad_statusline_id adstatusline_padashboardconten R
ismaximizable bpchar 1 'Y'::bpchar
ad_printformat_id numeric 10 √ NULL::numeric
ad_printformat.ad_printformat_id adprintformat_padashboardconte R
help varchar 2000 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
pa_dashboardcontent_key Primary key Asc pa_dashboardcontent_id
pa_dashboardcontent_uu_idx Must be unique Asc pa_dashboardcontent_uu

Check Constraints

Constraint Name Constraint
pa_dashboardcontent_isshowindashboard_check ((isshowindashboard = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_iscollapsible_check ((iscollapsible = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_isembedreportcontent_check ((isembedreportcontent = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_isshowinlogin_check ((isshowinlogin = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_ismaximizable_check ((ismaximizable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_isshowtitle_check ((isshowtitle = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_dashboardcontent_iscollapsedbydefault_check ((iscollapsedbydefault = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation