SchemaSpy Analysis of idempiere9.adempiere - ColumnsReport Views | Generated by Quality Systems & Solutions |
Generated on 2021-12-25 14:55 +0100 |
| |||||
|
idempiere9.adempiere contains 235 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
ad_process | accesslevel | bpchar | 1 | |||
ad_table | accesslevel | bpchar | 1 | |||
ad_column | ad_chart_id | numeric | 10 | √ | NULL::numeric | |
ad_column | ad_client_id | numeric | 10 | |||
ad_process | ad_client_id | numeric | 10 | |||
ad_process_para | ad_client_id | numeric | 10 | |||
ad_reportview | ad_client_id | numeric | 10 | |||
ad_reportview_col | ad_client_id | numeric | 10 | |||
ad_reportview_column | ad_client_id | numeric | 10 | √ | NULL::numeric | |
ad_table | ad_client_id | numeric | 10 | |||
ad_viewcolumn | ad_client_id | numeric | 10 | |||
ad_viewcomponent | ad_client_id | numeric | 10 | |||
ad_column | ad_column_id | numeric | 10 | |||
ad_reportview_col | ad_column_id | numeric | 10 | √ | null | |
ad_reportview_column | ad_column_id | numeric | 10 | |||
ad_column | ad_column_uu | varchar | 36 | √ | NULL::character varying | |
ad_process | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_column | ad_element_id | numeric | 10 | √ | null | |
ad_process_para | ad_element_id | numeric | 10 | √ | null | |
ad_process_para | ad_fieldgroup_id | numeric | 10 | √ | NULL::numeric | |
ad_process | ad_form_id | numeric | 10 | √ | null | |
ad_column | ad_org_id | numeric | 10 | |||
ad_process | ad_org_id | numeric | 10 | |||
ad_process_para | ad_org_id | numeric | 10 | |||
ad_reportview | ad_org_id | numeric | 10 | |||
ad_reportview_col | ad_org_id | numeric | 10 | |||
ad_reportview_column | ad_org_id | numeric | 10 | |||
ad_table | ad_org_id | numeric | 10 | |||
ad_viewcolumn | ad_org_id | numeric | 10 | |||
ad_viewcomponent | ad_org_id | numeric | 10 | |||
ad_process | ad_printformat_id | numeric | 10 | √ | null | |
ad_column | ad_process_id | numeric | 10 | √ | null | |
ad_process | ad_process_id | numeric | 10 | |||
ad_process_para | ad_process_id | numeric | 10 | |||
ad_process_para | ad_process_para_id | numeric | 10 | |||
ad_process_para | ad_process_para_uu | varchar | 36 | √ | NULL::character varying | |
ad_process | ad_process_uu | varchar | 36 | √ | NULL::character varying | |
ad_column | ad_reference_id | numeric | 10 | |||
ad_process_para | ad_reference_id | numeric | 10 | |||
ad_column | ad_reference_value_id | numeric | 10 | √ | null | |
ad_process_para | ad_reference_value_id | numeric | 10 | √ | null | |
ad_reportview_col | ad_reportview_col_id | numeric | 10 | |||
ad_reportview_col | ad_reportview_col_uu | varchar | 36 | √ | NULL::character varying | |
ad_reportview_column | ad_reportview_column_uu | varchar | 36 | √ | NULL::character varying | |
ad_process | ad_reportview_id | numeric | 10 | √ | null | |
ad_reportview | ad_reportview_id | numeric | 10 | |||
ad_reportview_col | ad_reportview_id | numeric | 10 | |||
ad_reportview_column | ad_reportview_id | numeric | 10 | |||
ad_reportview | ad_reportview_uu | varchar | 36 | √ | NULL::character varying | |
ad_column | ad_table_id | numeric | 10 | |||
ad_reportview | ad_table_id | numeric | 10 | |||
ad_table | ad_table_id | numeric | 10 | |||
ad_viewcomponent | ad_table_id | numeric | 10 | |||
ad_table | ad_table_uu | varchar | 36 | √ | NULL::character varying | |
ad_column | ad_val_rule_id | numeric | 10 | √ | null | |
ad_process_para | ad_val_rule_id | numeric | 10 | √ | null | |
ad_table | ad_val_rule_id | numeric | 10 | √ | null | |
ad_column | ad_val_rule_lookup_id | numeric | 10 | √ | NULL::numeric | |
ad_viewcolumn | ad_viewcolumn_id | numeric | 10 | |||
ad_viewcolumn | ad_viewcolumn_uu | varchar | 36 | √ | NULL::character varying | |
ad_viewcolumn | ad_viewcomponent_id | numeric | 10 | |||
ad_viewcomponent | ad_viewcomponent_id | numeric | 10 | |||
ad_viewcomponent | ad_viewcomponent_uu | varchar | 36 | √ | NULL::character varying | |
ad_table | ad_window_id | numeric | 10 | √ | null | |
ad_process | ad_workflow_id | numeric | 10 | √ | null | |
ad_process | allowmultipleexecution | bpchar | 1 | √ | 'P'::bpchar | |
ad_column | callout | varchar | 255 | √ | null | |
ad_process | classname | varchar | 255 | √ | null | |
ad_column | columnname | varchar | 30 | |||
ad_process_para | columnname | varchar | 30 | |||
ad_viewcolumn | columnname | varchar | 30 | NULL::character varying | ||
ad_column | columnsql | varchar | 4000 | √ | null | |
ad_viewcolumn | columnsql | varchar | 2000 | √ | null | |
ad_table | copycolumnsfromtable | varchar | 1 | √ | null | |
ad_table | copycomponentsfromview | bpchar | 1 | √ | NULL::bpchar | |
ad_process | copyfromprocess | bpchar | 1 | √ | NULL::bpchar | |
ad_column | created | timestamp | 29,6 | now() | ||
ad_process | created | timestamp | 29,6 | now() | ||
ad_process_para | created | timestamp | 29,6 | now() | ||
ad_reportview | created | timestamp | 29,6 | now() | ||
ad_reportview_col | created | timestamp | 29,6 | now() | ||
ad_reportview_column | created | timestamp | 29,6 | |||
ad_table | created | timestamp | 29,6 | now() | ||
ad_viewcolumn | created | timestamp | 29,6 | statement_timestamp() | ||
ad_viewcomponent | created | timestamp | 29,6 | statement_timestamp() | ||
ad_column | createdby | numeric | 10 | |||
ad_process | createdby | numeric | 10 | |||
ad_process_para | createdby | numeric | 10 | |||
ad_reportview | createdby | numeric | 10 | |||
ad_reportview_col | createdby | numeric | 10 | |||
ad_reportview_column | createdby | numeric | 10 | |||
ad_table | createdby | numeric | 10 | |||
ad_viewcolumn | createdby | numeric | 10 | |||
ad_viewcomponent | createdby | numeric | 10 | |||
ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | |
ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | |
ad_viewcolumn | dbdatatype | bpchar | 1 | √ | NULL::bpchar | |
ad_column | defaultvalue | varchar | 2000 | √ | null | |
ad_process_para | defaultvalue | varchar | 2000 | √ | null | |
ad_process_para | defaultvalue2 | varchar | 2000 | √ | null | |
ad_column | description | varchar | 255 | √ | null | |
ad_process | description | varchar | 255 | √ | null | |
ad_process_para | description | varchar | 255 | √ | null | |
ad_reportview | description | varchar | 255 | √ | null | |
ad_table | description | varchar | 255 | √ | null | |
ad_viewcolumn | description | varchar | 255 | √ | NULL::character varying | |
ad_viewcomponent | description | varchar | 255 | √ | NULL::character varying | |
ad_process_para | displaylogic | varchar | 2000 | √ | null | |
ad_column | entitytype | varchar | 40 | 'D'::character varying | ||
ad_process | entitytype | varchar | 40 | 'D'::character varying | ||
ad_process_para | entitytype | varchar | 40 | 'D'::character varying | ||
ad_reportview | entitytype | varchar | 40 | 'D'::character varying | ||
ad_table | entitytype | varchar | 40 | 'D'::character varying | ||
ad_viewcolumn | entitytype | varchar | 40 | 'U'::character varying | ||
ad_viewcomponent | entitytype | varchar | 40 | 'U'::character varying | ||
ad_process | executiontype | bpchar | 1 | √ | NULL::bpchar | |
ad_column | fieldlength | numeric | 10 | √ | null | |
ad_process_para | fieldlength | numeric | 10 | |||
ad_column | fkconstraintname | varchar | 30 | √ | NULL::character varying | |
ad_column | fkconstrainttype | bpchar | 1 | √ | 'N'::bpchar | |
ad_column | formatpattern | varchar | 22 | √ | null | |
ad_viewcomponent | fromclause | varchar | 2000 | NULL::character varying | ||
ad_reportview_col | functioncolumn | varchar | 60 | |||
ad_column | help | varchar | 2000 | √ | null | |
ad_process | help | varchar | 2000 | √ | null | |
ad_process_para | help | varchar | 2000 | √ | null | |
ad_table | help | varchar | 2000 | √ | null | |
ad_viewcolumn | help | varchar | 2000 | √ | NULL::character varying | |
ad_viewcomponent | help | varchar | 2000 | √ | NULL::character varying | |
ad_table | importtable | bpchar | 1 | √ | null | |
ad_column | infofactoryclass | varchar | 255 | √ | null | |
ad_column | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_process | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_process_para | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_reportview | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_reportview_col | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_reportview_column | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_table | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_viewcolumn | isactive | bpchar | 1 | |||
ad_viewcomponent | isactive | bpchar | 1 | |||
ad_column | isallowcopy | bpchar | 1 | 'Y'::bpchar | ||
ad_column | isallowlogging | bpchar | 1 | √ | 'Y'::bpchar | |
ad_column | isalwaysupdateable | bpchar | 1 | 'N'::bpchar | ||
ad_column | isautocomplete | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isautocomplete | bpchar | 1 | 'N'::bpchar | ||
ad_process | isbetafunctionality | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | iscentrallymaintained | bpchar | 1 | 'Y'::bpchar | ||
ad_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | |
ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | ||
ad_table | isdeleteable | bpchar | 1 | 'Y'::bpchar | ||
ad_process | isdirectprint | bpchar | 1 | √ | 'N'::bpchar | |
ad_column | isencrypted | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isencrypted | bpchar | 1 | 'N'::bpchar | ||
ad_reportview_col | isgroupfunction | bpchar | 1 | 'N'::bpchar | ||
ad_table | ishighvolume | bpchar | 1 | 'N'::bpchar | ||
ad_column | ishtml | bpchar | 1 | √ | 'N'::bpchar | |
ad_column | isidentifier | bpchar | 1 | 'N'::bpchar | ||
ad_column | iskey | bpchar | 1 | 'N'::bpchar | ||
ad_column | ismandatory | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | ismandatory | bpchar | 1 | 'N'::bpchar | ||
ad_column | isparent | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isrange | bpchar | 1 | 'N'::bpchar | ||
ad_process | isreport | bpchar | 1 | 'Y'::bpchar | ||
ad_column | issecure | bpchar | 1 | 'N'::bpchar | ||
ad_table | issecurityenabled | bpchar | 1 | 'N'::bpchar | ||
ad_column | isselectioncolumn | bpchar | 1 | 'N'::bpchar | ||
ad_process | isserverprocess | bpchar | 1 | √ | null | |
ad_column | issyncdatabase | bpchar | 1 | √ | 'N'::bpchar | |
ad_column | istoolbarbutton | bpchar | 1 | 'Y'::bpchar | ||
ad_column | istranslated | bpchar | 1 | 'N'::bpchar | ||
ad_viewcomponent | isunionall | bpchar | 1 | 'N'::bpchar | ||
ad_column | isupdateable | bpchar | 1 | 'Y'::bpchar | ||
ad_table | isview | bpchar | 1 | 'N'::bpchar | ||
ad_process | jasperreport | varchar | 255 | √ | null | |
ad_table | loadseq | numeric | 10 | √ | null | |
ad_column | mandatorylogic | varchar | 2000 | √ | null | |
ad_process_para | mandatorylogic | varchar | 2000 | √ | NULL::character varying | |
ad_column | name | varchar | 60 | |||
ad_process | name | varchar | 60 | |||
ad_process_para | name | varchar | 60 | |||
ad_reportview | name | varchar | 60 | |||
ad_table | name | varchar | 60 | |||
ad_viewcomponent | name | varchar | 50 | |||
ad_reportview | orderbyclause | varchar | 2000 | √ | null | |
ad_viewcomponent | otherclause | varchar | 2000 | √ | NULL::character varying | |
ad_column | pa_dashboardcontent_id | numeric | 10 | √ | NULL::numeric | |
ad_column | placeholder | varchar | 255 | √ | NULL::character varying | |
ad_process_para | placeholder | varchar | 255 | √ | NULL::character varying | |
ad_process_para | placeholder2 | varchar | 255 | √ | NULL::character varying | |
ad_table | po_window_id | numeric | 10 | √ | null | |
ad_process | procedurename | varchar | 60 | √ | null | |
ad_table | processing | bpchar | 1 | √ | NULL::bpchar | |
ad_process_para | query | varchar | 2000 | √ | NULL::character varying | |
ad_column | readonlylogic | varchar | 2000 | √ | null | |
ad_process_para | readonlylogic | varchar | 2000 | √ | null | |
ad_viewcomponent | referenced_table_id | numeric | 10 | √ | NULL::numeric | |
ad_table | replicationtype | bpchar | 1 | 'L'::bpchar | ||
ad_column | seqno | numeric | 10 | √ | null | |
ad_process_para | seqno | numeric | 10 | |||
ad_viewcolumn | seqno | numeric | 10 | √ | NULL::numeric | |
ad_viewcomponent | seqno | numeric | 10 | √ | NULL::numeric | |
ad_column | seqnoselection | numeric | 10 | √ | NULL::numeric | |
ad_process | showhelp | bpchar | 1 | √ | 'Y'::bpchar | |
ad_process | statistic_count | numeric | 10 | √ | null | |
ad_process | statistic_seconds | numeric | 0 | √ | null | |
ad_table | tablename | varchar | 40 | |||
ad_column | updated | timestamp | 29,6 | now() | ||
ad_process | updated | timestamp | 29,6 | now() | ||
ad_process_para | updated | timestamp | 29,6 | now() | ||
ad_reportview | updated | timestamp | 29,6 | now() | ||
ad_reportview_col | updated | timestamp | 29,6 | now() | ||
ad_reportview_column | updated | timestamp | 29,6 | |||
ad_table | updated | timestamp | 29,6 | now() | ||
ad_viewcolumn | updated | timestamp | 29,6 | statement_timestamp() | ||
ad_viewcomponent | updated | timestamp | 29,6 | statement_timestamp() | ||
ad_column | updatedby | numeric | 10 | |||
ad_process | updatedby | numeric | 10 | |||
ad_process_para | updatedby | numeric | 10 | |||
ad_reportview | updatedby | numeric | 10 | |||
ad_reportview_col | updatedby | numeric | 10 | |||
ad_reportview_column | updatedby | numeric | 10 | |||
ad_table | updatedby | numeric | 10 | |||
ad_viewcolumn | updatedby | numeric | 10 | |||
ad_viewcomponent | updatedby | numeric | 10 | |||
ad_process | value | varchar | 40 | |||
ad_column | valuemax | varchar | 20 | √ | null | |
ad_process_para | valuemax | varchar | 20 | √ | null | |
ad_column | valuemin | varchar | 20 | √ | null | |
ad_process_para | valuemin | varchar | 20 | √ | null | |
ad_column | version | numeric | 0 | |||
ad_column | vformat | varchar | 255 | √ | null | |
ad_process_para | vformat | varchar | 255 | √ | null | |
ad_reportview | whereclause | varchar | 2000 | √ | null | |
ad_viewcomponent | whereclause | varchar | 2000 | √ | NULL::character varying | |
ad_process | workflowvalue | varchar | 40 | √ | null |