SchemaSpy Analysis of idempiere11.adempiere - ColumnsSaaS | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:57 +0100 |
| |||||
|
idempiere11.adempiere contains 490 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
ad_field | ad_chart_id | numeric | 10 | √ | NULL::numeric | |
ad_window | ad_color_id | numeric | 10 | √ | null | |
ad_field | ad_column_id | numeric | 10 | √ | null | |
ad_tab | ad_column_id | numeric | 10 | √ | null | |
ad_tab | ad_columnsortorder_id | numeric | 10 | √ | null | |
ad_tab | ad_columnsortyesno_id | numeric | 10 | √ | null | |
ad_form | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_process | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_tab | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_task | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_workflow | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | |
ad_process_para | ad_element_id | numeric | 10 | √ | null | |
asp_clientexception | ad_field_id | numeric | 10 | √ | null | |
ad_field | ad_field_uu | varchar | 36 | √ | NULL::character varying | |
ad_field | ad_fieldgroup_id | numeric | 10 | √ | null | |
ad_process_para | ad_fieldgroup_id | numeric | 10 | √ | NULL::numeric | |
ad_field | ad_fieldstyle_id | numeric | 10 | √ | NULL::numeric | |
ad_process | ad_form_id | numeric | 10 | √ | null | |
asp_clientexception | ad_form_id | numeric | 10 | √ | null | |
ad_form | ad_form_uu | varchar | 36 | √ | NULL::character varying | |
ad_tab | ad_image_id | numeric | 10 | √ | null | |
ad_window | ad_image_id | numeric | 10 | √ | null | |
ad_field | ad_labelstyle_id | numeric | 10 | √ | NULL::numeric | |
ad_process | ad_printformat_id | numeric | 10 | √ | null | |
ad_tab | ad_process_id | numeric | 10 | √ | null | |
asp_clientexception | ad_process_id | numeric | 10 | √ | null | |
asp_clientexception | ad_process_para_id | numeric | 10 | √ | null | |
ad_process_para | ad_process_para_uu | varchar | 36 | √ | NULL::character varying | |
ad_process | ad_process_uu | varchar | 36 | √ | NULL::character varying | |
ad_ref_list | ad_ref_list_uu | varchar | 36 | √ | NULL::character varying | |
ad_field | ad_reference_id | numeric | 10 | √ | null | |
ad_field | ad_reference_value_id | numeric | 10 | √ | null | |
ad_process_para | ad_reference_value_id | numeric | 10 | √ | null | |
ad_process | ad_reportview_id | numeric | 10 | √ | null | |
ad_tab_customization | ad_tab_customization_uu | varchar | 36 | √ | NULL::character varying | |
ad_tab_customization | ad_tab_id | numeric | 10 | √ | NULL::numeric | |
asp_clientexception | ad_tab_id | numeric | 10 | √ | null | |
ad_tab | ad_tab_uu | varchar | 36 | √ | NULL::character varying | |
ad_workflow | ad_table_id | numeric | 10 | √ | null | |
ad_tab | ad_tabtype | varchar | 40 | √ | NULL::character varying | |
asp_clientexception | ad_task_id | numeric | 10 | √ | null | |
ad_task | ad_task_uu | varchar | 36 | √ | NULL::character varying | |
ad_field | ad_val_rule_id | numeric | 10 | √ | null | |
ad_process_para | ad_val_rule_id | numeric | 10 | √ | null | |
ad_field | ad_val_rule_lookup_id | numeric | 10 | √ | NULL::numeric | |
ad_workflow | ad_wf_node_id | numeric | 10 | √ | null | |
asp_clientexception | ad_wf_node_id | numeric | 10 | √ | null | |
ad_workflow | ad_wf_responsible_id | numeric | 10 | √ | null | |
asp_clientexception | ad_window_id | numeric | 10 | √ | null | |
ad_window | ad_window_uu | varchar | 36 | √ | NULL::character varying | |
ad_process | ad_workflow_id | numeric | 10 | √ | null | |
asp_clientexception | ad_workflow_id | numeric | 10 | √ | null | |
ad_workflow | ad_workflow_uu | varchar | 36 | √ | NULL::character varying | |
ad_workflow | ad_workflowprocessor_id | numeric | 10 | √ | null | |
asp_tab | allfields | bpchar | 1 | √ | 'Y'::bpchar | |
ad_field | alwaysupdatablelogic | varchar | 2000 | √ | NULL::character varying | |
asp_clientexception | asp_clientexception_uu | varchar | 36 | √ | NULL::character varying | |
asp_clientlevel | asp_clientlevel_uu | varchar | 36 | √ | NULL::character varying | |
asp_field | asp_field_uu | varchar | 36 | √ | NULL::character varying | |
asp_form | asp_form_uu | varchar | 36 | √ | NULL::character varying | |
asp_level | asp_level_uu | varchar | 36 | √ | NULL::character varying | |
asp_module | asp_module_uu | varchar | 36 | √ | NULL::character varying | |
asp_process_para | asp_process_id | numeric | 10 | √ | null | |
asp_process_para | asp_process_para_uu | varchar | 36 | √ | NULL::character varying | |
asp_process | asp_process_uu | varchar | 36 | √ | NULL::character varying | |
asp_ref_list | asp_ref_list_uu | varchar | 36 | √ | NULL::character varying | |
asp_ref_list | asp_status | bpchar | 1 | √ | 'U'::bpchar | |
asp_field | asp_tab_id | numeric | 10 | √ | null | |
asp_tab | asp_tab_uu | varchar | 36 | √ | NULL::character varying | |
asp_task | asp_task_uu | varchar | 36 | √ | NULL::character varying | |
asp_tab | asp_window_id | numeric | 10 | √ | null | |
asp_window | asp_window_uu | varchar | 36 | √ | NULL::character varying | |
asp_workflow | asp_workflow_uu | varchar | 36 | √ | NULL::character varying | |
ad_form | classname | varchar | 60 | √ | null | |
ad_process | classname | varchar | 255 | √ | null | |
ad_field | columnspan | numeric | 10 | √ | (1)::numeric | |
ad_field | columnsql | varchar | 4000 | √ | null | |
ad_tab | commitwarning | varchar | 2000 | √ | null | |
ad_process | copyfromprocess | bpchar | 1 | √ | NULL::bpchar | |
ad_field | defaultvalue | varchar | 2000 | √ | null | |
ad_process_para | defaultvalue | varchar | 2000 | √ | null | |
ad_process_para | defaultvalue2 | varchar | 2000 | √ | null | |
ad_tab | deleteconfirmationlogic | varchar | 255 | √ | NULL::character varying | |
ad_field | description | varchar | 255 | √ | null | |
ad_form | description | varchar | 255 | √ | null | |
ad_process | description | varchar | 255 | √ | null | |
ad_process_para | description | varchar | 255 | √ | null | |
ad_ref_list | description | varchar | 255 | √ | null | |
ad_tab | description | varchar | 255 | √ | null | |
ad_task | description | varchar | 255 | √ | null | |
ad_window | description | varchar | 255 | √ | null | |
ad_workflow | description | varchar | 255 | √ | null | |
asp_level | description | varchar | 255 | √ | null | |
asp_module | description | varchar | 255 | √ | null | |
ad_field | displaylength | numeric | 10 | √ | null | |
ad_field | displaylogic | varchar | 2000 | √ | null | |
ad_process_para | displaylogic | varchar | 2000 | √ | null | |
ad_tab | displaylogic | varchar | 2000 | √ | null | |
ad_workflow | documentno | varchar | 30 | √ | null | |
ad_workflow | docvaluelogic | varchar | 2000 | √ | null | |
ad_workflow | durationunit | bpchar | 1 | √ | null | |
ad_process | executiontype | bpchar | 1 | √ | NULL::bpchar | |
ad_process | filenamepattern | varchar | 255 | √ | NULL::character varying | |
ad_field | help | varchar | 2000 | √ | null | |
ad_form | help | varchar | 2000 | √ | null | |
ad_process | help | varchar | 2000 | √ | null | |
ad_process_para | help | varchar | 2000 | √ | null | |
ad_tab | help | varchar | 2000 | √ | null | |
ad_task | help | varchar | 2000 | √ | null | |
ad_window | help | varchar | 2000 | √ | null | |
ad_workflow | help | text | 2147483647 | √ | null | |
asp_clientlevel | help | varchar | 2000 | √ | null | |
asp_level | help | varchar | 2000 | √ | null | |
asp_module | help | varchar | 2000 | √ | null | |
ad_form | imageurl | varchar | 120 | √ | NULL::character varying | |
ad_tab | importfields | bpchar | 1 | √ | null | |
ad_field | included_tab_id | numeric | 10 | √ | null | |
ad_tab | included_tab_id | numeric | 10 | √ | null | |
ad_field | infofactoryclass | varchar | 255 | √ | null | |
asp_ref_list | isactive | bpchar | 1 | √ | 'Y'::bpchar | |
ad_field | isadvancedfield | bpchar | 1 | √ | 'N'::bpchar | |
ad_tab | isallowadvancedlookup | bpchar | 1 | √ | 'Y'::bpchar | |
ad_field | isallowcopy | bpchar | 1 | √ | NULL::bpchar | |
ad_field | isalwaysupdateable | bpchar | 1 | √ | NULL::bpchar | |
ad_tab_customization | isautohideemptycolumn | bpchar | 1 | √ | NULL::bpchar | |
ad_process | isdirectprint | bpchar | 1 | √ | 'N'::bpchar | |
ad_field | isdisplayedgrid | bpchar | 1 | √ | 'Y'::bpchar | |
ad_tab_customization | isdisplayedgrid | bpchar | 1 | √ | NULL::bpchar | |
ad_tab | ishighvolume | bpchar | 1 | √ | NULL::bpchar | |
ad_tab | isinfotab | bpchar | 1 | √ | 'N'::bpchar | |
ad_tab | islookuponlyselection | bpchar | 1 | √ | 'N'::bpchar | |
ad_field | ismandatory | bpchar | 1 | √ | null | |
ad_tab_customization | isquickform | bpchar | 1 | √ | 'N'::bpchar | |
ad_field | isselectioncolumn | bpchar | 1 | √ | NULL::bpchar | |
ad_process | isserverprocess | bpchar | 1 | √ | null | |
ad_task | isserverprocess | bpchar | 1 | √ | 'N'::bpchar | |
ad_field | istoolbarbutton | bpchar | 1 | √ | null | |
ad_field | isupdateable | bpchar | 1 | √ | NULL::bpchar | |
ad_process | jasperreport | varchar | 255 | √ | null | |
ad_form | jspurl | varchar | 120 | √ | null | |
ad_workflow | limit | numeric | 10 | √ | null | |
ad_field | mandatorylogic | varchar | 2000 | √ | NULL::character varying | |
ad_process_para | mandatorylogic | varchar | 2000 | √ | NULL::character varying | |
ad_tab | maxqueryrecords | numeric | 10 | √ | '0'::numeric | |
ad_workflow | movingtime | numeric | 10 | √ | null | |
ad_field | numlines | numeric | 10 | √ | (1)::numeric | |
ad_field | obscuretype | bpchar | 3 | √ | null | |
ad_tab | orderbyclause | varchar | 2000 | √ | null | |
ad_workflow | overlapunits | numeric | 0 | √ | null | |
ad_tab | parent_column_id | numeric | 10 | √ | NULL::numeric | |
ad_field | 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_window | predefinedcontextvariables | varchar | 4000 | √ | NULL::character varying | |
ad_workflow | priority | numeric | 10 | √ | null | |
ad_process | procedurename | varchar | 60 | √ | null | |
ad_tab | processing | bpchar | 1 | √ | null | |
ad_window | processing | bpchar | 1 | √ | null | |
asp_level | processing | bpchar | 1 | √ | null | |
asp_tab | processing | bpchar | 1 | √ | null | |
ad_workflow | processtype | bpchar | 2 | √ | null | |
ad_workflow | qtybatchsize | numeric | 0 | √ | (1)::numeric | |
ad_process_para | query | varchar | 2000 | √ | NULL::character varying | |
ad_workflow | queuingtime | numeric | 10 | √ | null | |
ad_field | readonlylogic | varchar | 2000 | √ | NULL::character varying | |
ad_process_para | readonlylogic | varchar | 2000 | √ | null | |
ad_tab | readonlylogic | varchar | 2000 | √ | null | |
ad_workflow | s_resource_id | numeric | 10 | √ | null | |
ad_field | seqno | numeric | 10 | √ | null | |
ad_field | seqnogrid | numeric | 10 | √ | NULL::numeric | |
ad_workflow | setuptime | numeric | 10 | √ | null | |
ad_process | showhelp | bpchar | 1 | √ | 'Y'::bpchar | |
ad_field | sortno | numeric | 10 | √ | null | |
ad_process | statistic_count | numeric | 10 | √ | null | |
ad_process | statistic_seconds | numeric | 0 | √ | null | |
ad_window | titlelogic | varchar | 255 | √ | NULL::character varying | |
ad_workflow | unitscycles | numeric | 0 | √ | null | |
ad_workflow | validateworkflow | bpchar | 1 | √ | null | |
ad_ref_list | validfrom | timestamp | 29,6 | √ | null | |
ad_workflow | validfrom | timestamp | 29,6 | √ | null | |
ad_ref_list | validto | timestamp | 29,6 | √ | null | |
ad_workflow | validto | timestamp | 29,6 | √ | null | |
ad_process_para | valuemax | varchar | 20 | √ | null | |
ad_process_para | valuemin | varchar | 20 | √ | null | |
ad_field | vformat | varchar | 255 | √ | NULL::character varying | |
ad_process_para | vformat | varchar | 255 | √ | null | |
ad_tab | whereclause | varchar | 2000 | √ | null | |
ad_window | windowtype | bpchar | 1 | √ | null | |
ad_window | winheight | numeric | 10 | √ | null | |
ad_window | winwidth | numeric | 10 | √ | null | |
ad_process | workflowvalue | varchar | 40 | √ | null | |
ad_field | xposition | numeric | 10 | √ | (1)::numeric | |
ad_workflow | yield | numeric | 10 | √ | (100)::numeric | |
ad_form | accesslevel | bpchar | 1 | |||
ad_process | accesslevel | bpchar | 1 | |||
ad_task | accesslevel | bpchar | 1 | |||
ad_workflow | accesslevel | bpchar | 1 | |||
ad_field | ad_client_id | numeric | 10 | |||
ad_form | ad_client_id | numeric | 10 | |||
ad_process | ad_client_id | numeric | 10 | |||
ad_process_para | ad_client_id | numeric | 10 | |||
ad_ref_list | ad_client_id | numeric | 10 | |||
ad_tab | ad_client_id | numeric | 10 | |||
ad_tab_customization | ad_client_id | numeric | 10 | |||
ad_task | ad_client_id | numeric | 10 | |||
ad_window | ad_client_id | numeric | 10 | |||
ad_workflow | ad_client_id | numeric | 10 | |||
asp_clientexception | ad_client_id | numeric | 10 | |||
asp_clientlevel | ad_client_id | numeric | 10 | |||
asp_field | ad_client_id | numeric | 10 | |||
asp_form | ad_client_id | numeric | 10 | |||
asp_level | ad_client_id | numeric | 10 | |||
asp_module | ad_client_id | numeric | 10 | |||
asp_process | ad_client_id | numeric | 10 | |||
asp_process_para | ad_client_id | numeric | 10 | |||
asp_ref_list | ad_client_id | numeric | 10 | |||
asp_tab | ad_client_id | numeric | 10 | |||
asp_task | ad_client_id | numeric | 10 | |||
asp_window | ad_client_id | numeric | 10 | |||
asp_workflow | ad_client_id | numeric | 10 | |||
ad_field | ad_field_id | numeric | 10 | |||
asp_field | ad_field_id | numeric | 10 | |||
ad_form | ad_form_id | numeric | 10 | |||
asp_form | ad_form_id | numeric | 10 | |||
ad_field | ad_org_id | numeric | 10 | |||
ad_form | ad_org_id | numeric | 10 | |||
ad_process | ad_org_id | numeric | 10 | |||
ad_process_para | ad_org_id | numeric | 10 | |||
ad_ref_list | ad_org_id | numeric | 10 | |||
ad_tab | ad_org_id | numeric | 10 | |||
ad_tab_customization | ad_org_id | numeric | 10 | |||
ad_task | ad_org_id | numeric | 10 | |||
ad_window | ad_org_id | numeric | 10 | |||
ad_workflow | ad_org_id | numeric | 10 | |||
asp_clientexception | ad_org_id | numeric | 10 | 0 | ||
asp_clientlevel | ad_org_id | numeric | 10 | 0 | ||
asp_field | ad_org_id | numeric | 10 | |||
asp_form | ad_org_id | numeric | 10 | |||
asp_level | ad_org_id | numeric | 10 | |||
asp_module | ad_org_id | numeric | 10 | |||
asp_process | ad_org_id | numeric | 10 | |||
asp_process_para | ad_org_id | numeric | 10 | |||
asp_ref_list | ad_org_id | numeric | 10 | |||
asp_tab | ad_org_id | numeric | 10 | |||
asp_task | ad_org_id | numeric | 10 | |||
asp_window | ad_org_id | numeric | 10 | |||
asp_workflow | ad_org_id | numeric | 10 | |||
ad_process | ad_process_id | numeric | 10 | |||
ad_process_para | ad_process_id | numeric | 10 | |||
asp_process | ad_process_id | numeric | 10 | |||
ad_process_para | ad_process_para_id | numeric | 10 | |||
asp_process_para | ad_process_para_id | numeric | 10 | |||
ad_ref_list | ad_ref_list_id | numeric | 10 | |||
asp_ref_list | ad_ref_list_id | numeric | 10 | |||
ad_process_para | ad_reference_id | numeric | 10 | |||
ad_ref_list | ad_reference_id | numeric | 10 | |||
asp_ref_list | ad_reference_id | numeric | 10 | |||
ad_tab_customization | ad_tab_customization_id | numeric | 10 | NULL::numeric | ||
ad_field | ad_tab_id | numeric | 10 | |||
ad_tab | ad_tab_id | numeric | 10 | |||
asp_tab | ad_tab_id | numeric | 10 | |||
ad_tab | ad_table_id | numeric | 10 | |||
ad_task | ad_task_id | numeric | 10 | |||
asp_task | ad_task_id | numeric | 10 | |||
ad_tab_customization | ad_user_id | numeric | 10 | |||
ad_tab | ad_window_id | numeric | 10 | |||
ad_window | ad_window_id | numeric | 10 | |||
asp_window | ad_window_id | numeric | 10 | |||
ad_workflow | ad_workflow_id | numeric | 10 | |||
asp_workflow | ad_workflow_id | numeric | 10 | |||
ad_process | allowmultipleexecution | varchar | 2 | 'P'::character varying | ||
asp_clientexception | asp_clientexception_id | numeric | 10 | |||
asp_clientlevel | asp_clientlevel_id | numeric | 10 | |||
asp_field | asp_field_id | numeric | 10 | |||
asp_form | asp_form_id | numeric | 10 | |||
asp_clientlevel | asp_level_id | numeric | 10 | |||
asp_form | asp_level_id | numeric | 10 | |||
asp_level | asp_level_id | numeric | 10 | |||
asp_process | asp_level_id | numeric | 10 | |||
asp_ref_list | asp_level_id | numeric | 10 | |||
asp_task | asp_level_id | numeric | 10 | |||
asp_window | asp_level_id | numeric | 10 | |||
asp_workflow | asp_level_id | numeric | 10 | |||
asp_clientlevel | asp_module_id | numeric | 10 | |||
asp_level | asp_module_id | numeric | 10 | |||
asp_module | asp_module_id | numeric | 10 | |||
asp_process | asp_process_id | numeric | 10 | |||
asp_process_para | asp_process_para_id | numeric | 10 | |||
asp_ref_list | asp_ref_list_id | numeric | 10 | |||
asp_clientexception | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_field | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_form | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_process | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_process_para | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_tab | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_task | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_window | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_workflow | asp_status | bpchar | 1 | 'U'::bpchar | ||
asp_tab | asp_tab_id | numeric | 10 | |||
asp_task | asp_task_id | numeric | 10 | |||
asp_window | asp_window_id | numeric | 10 | |||
asp_workflow | asp_workflow_id | numeric | 10 | |||
ad_workflow | author | varchar | 20 | 'ComPiere'::character varying | ||
ad_process_para | columnname | varchar | 30 | |||
ad_workflow | cost | numeric | 0 | |||
ad_field | created | timestamp | 29,6 | now() | ||
ad_form | created | timestamp | 29,6 | now() | ||
ad_process | created | timestamp | 29,6 | now() | ||
ad_process_para | created | timestamp | 29,6 | now() | ||
ad_ref_list | created | timestamp | 29,6 | now() | ||
ad_tab | created | timestamp | 29,6 | now() | ||
ad_tab_customization | created | timestamp | 29,6 | statement_timestamp() | ||
ad_task | created | timestamp | 29,6 | now() | ||
ad_window | created | timestamp | 29,6 | now() | ||
ad_workflow | created | timestamp | 29,6 | now() | ||
asp_clientexception | created | timestamp | 29,6 | statement_timestamp() | ||
asp_clientlevel | created | timestamp | 29,6 | statement_timestamp() | ||
asp_field | created | timestamp | 29,6 | statement_timestamp() | ||
asp_form | created | timestamp | 29,6 | statement_timestamp() | ||
asp_level | created | timestamp | 29,6 | statement_timestamp() | ||
asp_module | created | timestamp | 29,6 | statement_timestamp() | ||
asp_process | created | timestamp | 29,6 | statement_timestamp() | ||
asp_process_para | created | timestamp | 29,6 | statement_timestamp() | ||
asp_ref_list | created | timestamp | 29,6 | statement_timestamp() | ||
asp_tab | created | timestamp | 29,6 | statement_timestamp() | ||
asp_task | created | timestamp | 29,6 | statement_timestamp() | ||
asp_window | created | timestamp | 29,6 | statement_timestamp() | ||
asp_workflow | created | timestamp | 29,6 | statement_timestamp() | ||
ad_field | createdby | numeric | 10 | |||
ad_form | createdby | numeric | 10 | |||
ad_process | createdby | numeric | 10 | |||
ad_process_para | createdby | numeric | 10 | |||
ad_ref_list | createdby | numeric | 10 | |||
ad_tab | createdby | numeric | 10 | |||
ad_tab_customization | createdby | numeric | 10 | |||
ad_task | createdby | numeric | 10 | |||
ad_window | createdby | numeric | 10 | |||
ad_workflow | createdby | numeric | 10 | |||
asp_clientexception | createdby | numeric | 10 | |||
asp_clientlevel | createdby | numeric | 10 | |||
asp_field | createdby | numeric | 10 | |||
asp_form | createdby | numeric | 10 | |||
asp_level | createdby | numeric | 10 | |||
asp_module | createdby | numeric | 10 | |||
asp_process | createdby | numeric | 10 | |||
asp_process_para | createdby | numeric | 10 | |||
asp_ref_list | createdby | numeric | 10 | |||
asp_tab | createdby | numeric | 10 | |||
asp_task | createdby | numeric | 10 | |||
asp_window | createdby | numeric | 10 | |||
asp_workflow | createdby | numeric | 10 | |||
ad_tab_customization | custom | varchar | 2000 | |||
ad_process_para | daterangeoption | bpchar | 1 | 'D'::bpchar | ||
ad_workflow | duration | numeric | 10 | 0 | ||
ad_field | entitytype | varchar | 40 | 'D'::character varying | ||
ad_form | entitytype | varchar | 40 | 'D'::character varying | ||
ad_process | entitytype | varchar | 40 | 'D'::character varying | ||
ad_process_para | entitytype | varchar | 40 | 'D'::character varying | ||
ad_ref_list | entitytype | varchar | 40 | 'D'::character varying | ||
ad_tab | entitytype | varchar | 40 | 'D'::character varying | ||
ad_task | entitytype | varchar | 40 | 'D'::character varying | ||
ad_window | entitytype | varchar | 40 | 'D'::character varying | ||
ad_workflow | entitytype | varchar | 40 | 'D'::character varying | ||
ad_process_para | fieldlength | numeric | 10 | |||
ad_tab | hastree | bpchar | 1 | 'N'::bpchar | ||
ad_field | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_form | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_process | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_process_para | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_ref_list | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_tab | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_tab_customization | isactive | bpchar | 1 | |||
ad_task | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_window | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_workflow | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_clientexception | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_clientlevel | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_field | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_form | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_level | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_module | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_process | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_process_para | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_tab | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_task | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_window | isactive | bpchar | 1 | 'Y'::bpchar | ||
asp_workflow | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_tab | isadvancedtab | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isautocomplete | bpchar | 1 | 'N'::bpchar | ||
ad_form | isbetafunctionality | bpchar | 1 | 'N'::bpchar | ||
ad_process | isbetafunctionality | bpchar | 1 | 'N'::bpchar | ||
ad_window | isbetafunctionality | bpchar | 1 | 'N'::bpchar | ||
ad_workflow | isbetafunctionality | bpchar | 1 | 'N'::bpchar | ||
ad_field | iscentrallymaintained | bpchar | 1 | 'Y'::bpchar | ||
ad_process_para | iscentrallymaintained | bpchar | 1 | 'Y'::bpchar | ||
ad_window | isdefault | bpchar | 1 | 'N'::bpchar | ||
ad_workflow | isdefault | bpchar | 1 | 'N'::bpchar | ||
ad_field | isdefaultfocus | bpchar | 1 | 'N'::bpchar | ||
ad_field | isdisplayed | bpchar | 1 | 'Y'::bpchar | ||
ad_field | isencrypted | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isencrypted | bpchar | 1 | 'N'::bpchar | ||
ad_field | isfieldonly | bpchar | 1 | 'N'::bpchar | ||
ad_field | isheading | bpchar | 1 | 'N'::bpchar | ||
ad_tab | isinsertrecord | bpchar | 1 | 'Y'::bpchar | ||
ad_process_para | ismandatory | bpchar | 1 | 'N'::bpchar | ||
ad_field | isquickentry | bpchar | 1 | 'N'::bpchar | ||
ad_field | isquickform | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isrange | bpchar | 1 | 'N'::bpchar | ||
ad_field | isreadonly | bpchar | 1 | 'N'::bpchar | ||
ad_tab | isreadonly | bpchar | 1 | 'N'::bpchar | ||
ad_process | isreport | bpchar | 1 | 'Y'::bpchar | ||
ad_field | issameline | bpchar | 1 | 'N'::bpchar | ||
ad_process_para | isshownegatebutton | bpchar | 1 | 'N'::bpchar | ||
ad_tab | issinglerow | bpchar | 1 | 'Y'::bpchar | ||
ad_tab | issorttab | bpchar | 1 | 'N'::bpchar | ||
ad_window | issotrx | bpchar | 1 | 'Y'::bpchar | ||
ad_tab | istranslationtab | bpchar | 1 | 'N'::bpchar | ||
ad_workflow | isvalid | bpchar | 1 | 'N'::bpchar | ||
ad_field | name | varchar | 60 | |||
ad_form | name | varchar | 60 | |||
ad_process | name | varchar | 60 | |||
ad_process_para | name | varchar | 60 | |||
ad_ref_list | name | varchar | 60 | |||
ad_tab | name | varchar | 60 | |||
ad_task | name | varchar | 60 | |||
ad_window | name | varchar | 60 | |||
ad_workflow | name | varchar | 60 | |||
asp_level | name | varchar | 60 | |||
asp_module | name | varchar | 60 | |||
ad_task | os_command | varchar | 2000 | |||
ad_workflow | publishstatus | bpchar | 1 | |||
ad_process_para | seqno | numeric | 10 | |||
ad_tab | seqno | numeric | 10 | |||
ad_tab | tablevel | numeric | 10 | |||
ad_tab | treedisplayedon | bpchar | 1 | 'B'::bpchar | ||
ad_field | updated | timestamp | 29,6 | now() | ||
ad_form | updated | timestamp | 29,6 | now() | ||
ad_process | updated | timestamp | 29,6 | now() | ||
ad_process_para | updated | timestamp | 29,6 | now() | ||
ad_ref_list | updated | timestamp | 29,6 | now() | ||
ad_tab | updated | timestamp | 29,6 | now() | ||
ad_tab_customization | updated | timestamp | 29,6 | statement_timestamp() | ||
ad_task | updated | timestamp | 29,6 | now() | ||
ad_window | updated | timestamp | 29,6 | now() | ||
ad_workflow | updated | timestamp | 29,6 | now() | ||
asp_clientexception | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_clientlevel | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_field | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_form | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_level | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_module | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_process | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_process_para | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_ref_list | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_tab | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_task | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_window | updated | timestamp | 29,6 | statement_timestamp() | ||
asp_workflow | updated | timestamp | 29,6 | statement_timestamp() | ||
ad_field | updatedby | numeric | 10 | |||
ad_form | updatedby | numeric | 10 | |||
ad_process | updatedby | numeric | 10 | |||
ad_process_para | updatedby | numeric | 10 | |||
ad_ref_list | updatedby | numeric | 10 | |||
ad_tab | updatedby | numeric | 10 | |||
ad_tab_customization | updatedby | numeric | 10 | |||
ad_task | updatedby | numeric | 10 | |||
ad_window | updatedby | numeric | 10 | |||
ad_workflow | updatedby | numeric | 10 | |||
asp_clientexception | updatedby | numeric | 10 | |||
asp_clientlevel | updatedby | numeric | 10 | |||
asp_field | updatedby | numeric | 10 | |||
asp_form | updatedby | numeric | 10 | |||
asp_level | updatedby | numeric | 10 | |||
asp_module | updatedby | numeric | 10 | |||
asp_process | updatedby | numeric | 10 | |||
asp_process_para | updatedby | numeric | 10 | |||
asp_ref_list | updatedby | numeric | 10 | |||
asp_tab | updatedby | numeric | 10 | |||
asp_task | updatedby | numeric | 10 | |||
asp_window | updatedby | numeric | 10 | |||
asp_workflow | updatedby | numeric | 10 | |||
ad_process | value | varchar | 40 | |||
ad_ref_list | value | varchar | 60 | |||
ad_workflow | value | varchar | 40 | |||
asp_level | value | varchar | 40 | |||
asp_module | value | varchar | 40 | |||
ad_workflow | version | numeric | 10 | 0 | ||
ad_workflow | waitingtime | numeric | 10 | 0 | ||
ad_workflow | workflowtype | bpchar | 1 | 'G'::bpchar | ||
ad_workflow | workingtime | numeric | 10 | 0 |