SchemaSpy Analysis of idempiere9.adempiere - ColumnsReport Views Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:55 +0100
Legend:
Primary key columns
Columns with indexes
 

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