Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | null |
|
|
|||||||||
| ad_org_id | numeric | 10 | null |
|
|
|||||||||
| c_calendar_id | numeric | 10 | null |
|
|
|||||||||
| created | timestamp | 29,6 | statement_timestamp() |
|
|
|||||||||
| createdby | numeric | 10 | null |
|
|
|||||||||
| description | varchar | 255 | √ | NULL::character varying |
|
|
||||||||
| isactive | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isactivitydim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isbpartnerdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| iscampaigndim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isglbudgetdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| islocfromdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isloctodim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isorgtrxdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isproductdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isprojectdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isprojectphasedim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isprojecttaskdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| issalesregiondim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| issubacctdim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isuser1dim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isuser2dim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| name | varchar | 60 | null |
|
|
|||||||||
| pa_reportcube_id | numeric | 10 | null |
|
|
|||||||||
| updated | timestamp | 29,6 | statement_timestamp() |
|
|
|||||||||
| updatedby | numeric | 10 | null |
|
|
|||||||||
| processing | bpchar | 1 | 'N'::bpchar |
|
|
|||||||||
| lastrecalculated | timestamp | 29,6 | √ | null |
|
|
||||||||
| isuserelement2dim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| isuserelement1dim | bpchar | 1 | √ | NULL::bpchar |
|
|
||||||||
| pa_reportcube_uu | varchar | 36 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pa_reportcube_key | Primary key | Asc | pa_reportcube_id |
| pa_reportcube_uu_idx | Must be unique | Asc | pa_reportcube_uu |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| pa_reportcube_isprojectphasedim_check | ((isprojectphasedim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isuserelement2dim_check | ((isuserelement2dim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_issalesregiondim_check | ((issalesregiondim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_processing_check | ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isuser1dim_check | ((isuser1dim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_islocfromdim_check | ((islocfromdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isbpartnerdim_check | ((isbpartnerdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isprojectdim_check | ((isprojectdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isorgtrxdim_check | ((isorgtrxdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isproductdim_check | ((isproductdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isactivitydim_check | ((isactivitydim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isglbudgetdim_check | ((isglbudgetdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isuserelement1dim_check | ((isuserelement1dim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isuser2dim_check | ((isuser2dim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_iscampaigndim_check | ((iscampaigndim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isprojecttaskdim_check | ((isprojecttaskdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_isloctodim_check | ((isloctodim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| pa_reportcube_issubacctdim_check | ((issubacctdim = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |