ad_chart

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_chart_id numeric 10 null
ad_chart_trl.ad_chart_id adchart_adcharttrl C
ad_chartdatasource.ad_chart_id adchart_adchartdatasource R
ad_column.ad_chart_id adchart_adcolumn R
ad_field.ad_chart_id adchart_adfield R
ad_field_v.ad_chart_id Implied Constraint R
ad_field_vt.ad_chart_id Implied Constraint R
ad_userdef_field.ad_chart_id adchart_aduserdeffield R
pa_dashboardcontent.ad_chart_id adchart_padashboardcontent R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
charttype varchar 2 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ NULL::character varying
isactive bpchar 1 √ NULL::bpchar
name varchar 60 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
winheight numeric 10 √ NULL::numeric
isdisplaylegend bpchar 1 'Y'::bpchar
chartorientation bpchar 1 'V'::bpchar
istimeseries bpchar 1 'N'::bpchar
timeunit bpchar 1 √ NULL::bpchar
timescope numeric 10 √ null
domainlabel varchar 60 √ NULL::character varying
rangelabel varchar 60 √ NULL::character varying
ad_chart_uu varchar 36 √ NULL::character varying
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entityt_adchart R

Indexes

Constraint Name Type Sort Column(s)
ad_chart_key Primary key Asc ad_chart_id
ad_chart_uu_idx Must be unique Asc ad_chart_uu

Check Constraints

Constraint Name Constraint
ad_chart_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_chart_istimeseries_check ((istimeseries = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_chart_isdisplaylegend_check ((isdisplaylegend = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation