SchemaSpy Analysis of idempiere11.adempiere - ColumnsWebServices Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:57 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 96 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ws_webservice ad_client_id numeric 10
ws_webservice ad_org_id numeric 10
ws_webservice created timestamp 29,6 statement_timestamp()
ws_webservice createdby numeric 10
ws_webservice description varchar 255  √  null
ws_webservice help varchar 2000  √  null
ws_webservice isactive bpchar 1 'Y'::bpchar
ws_webservice name varchar 60
ws_webservice updated timestamp 29,6 statement_timestamp()
ws_webservice updatedby numeric 10
ws_webservice value varchar 40
ws_webservice ws_webservice_id numeric 10
ws_webservice ws_webservice_uu varchar 36  √  NULL::character varying
ws_webservice_para ad_client_id numeric 10
ws_webservice_para ad_org_id numeric 10
ws_webservice_para constantvalue varchar 2000  √  null
ws_webservice_para created timestamp 29,6 statement_timestamp()
ws_webservice_para createdby numeric 10  √  null
ws_webservice_para isactive bpchar 1 'Y'::bpchar
ws_webservice_para parametername varchar 60  √  null
ws_webservice_para parametertype bpchar 1
ws_webservice_para updated timestamp 29,6 statement_timestamp()
ws_webservice_para updatedby numeric 10  √  null
ws_webservice_para ws_webservice_para_id numeric 10
ws_webservice_para ws_webservice_para_uu varchar 36  √  NULL::character varying
ws_webservice_para ws_webservicetype_id numeric 10
ws_webservicefieldinput ad_client_id numeric 10
ws_webservicefieldinput ad_column_id numeric 10  √  null
ws_webservicefieldinput ad_org_id numeric 10
ws_webservicefieldinput ad_reference_id numeric 10  √  NULL::numeric
ws_webservicefieldinput ad_reference_value_id numeric 10  √  NULL::numeric
ws_webservicefieldinput columnname varchar 30  √  NULL::character varying
ws_webservicefieldinput created timestamp 29,6 statement_timestamp()
ws_webservicefieldinput createdby numeric 10  √  null
ws_webservicefieldinput identifierlogic varchar 2000  √  null
ws_webservicefieldinput isactive bpchar 1 'Y'::bpchar
ws_webservicefieldinput isidentifier bpchar 1  √  'N'::bpchar
ws_webservicefieldinput isnullidentifier bpchar 1  √  'N'::bpchar
ws_webservicefieldinput updated timestamp 29,6 statement_timestamp()
ws_webservicefieldinput updatedby numeric 10  √  null
ws_webservicefieldinput ws_webservicefieldinput_id numeric 10
ws_webservicefieldinput ws_webservicefieldinput_uu varchar 36  √  NULL::character varying
ws_webservicefieldinput ws_webservicetype_id numeric 10
ws_webservicefieldoutput ad_client_id numeric 10
ws_webservicefieldoutput ad_column_id numeric 10  √  null
ws_webservicefieldoutput ad_org_id numeric 10
ws_webservicefieldoutput created timestamp 29,6 statement_timestamp()
ws_webservicefieldoutput createdby numeric 10  √  null
ws_webservicefieldoutput isactive bpchar 1 'Y'::bpchar
ws_webservicefieldoutput updated timestamp 29,6 statement_timestamp()
ws_webservicefieldoutput updatedby numeric 10  √  null
ws_webservicefieldoutput ws_webservicefieldoutput_id numeric 10
ws_webservicefieldoutput ws_webservicefieldoutput_uu varchar 36  √  NULL::character varying
ws_webservicefieldoutput ws_webservicetype_id numeric 10
ws_webservicemethod ad_client_id numeric 10
ws_webservicemethod ad_org_id numeric 10
ws_webservicemethod created timestamp 29,6 statement_timestamp()
ws_webservicemethod createdby numeric 10
ws_webservicemethod description varchar 255  √  null
ws_webservicemethod help varchar 2000  √  null
ws_webservicemethod isactive bpchar 1 'Y'::bpchar
ws_webservicemethod name varchar 60
ws_webservicemethod updated timestamp 29,6 statement_timestamp()
ws_webservicemethod updatedby numeric 10
ws_webservicemethod value varchar 40
ws_webservicemethod ws_webservice_id numeric 10  √  null
ws_webservicemethod ws_webservicemethod_id numeric 10
ws_webservicemethod ws_webservicemethod_uu varchar 36  √  NULL::character varying
ws_webservicetype ad_client_id numeric 10
ws_webservicetype ad_org_id numeric 10
ws_webservicetype ad_table_id numeric 10  √  null
ws_webservicetype created timestamp 29,6 statement_timestamp()
ws_webservicetype createdby numeric 10
ws_webservicetype description varchar 255  √  null
ws_webservicetype help varchar 2000  √  null
ws_webservicetype insertparameters bpchar 1  √  NULL::bpchar
ws_webservicetype isactive bpchar 1 'Y'::bpchar
ws_webservicetype name varchar 60
ws_webservicetype updated timestamp 29,6 statement_timestamp()
ws_webservicetype updatedby numeric 10
ws_webservicetype value varchar 40
ws_webservicetype ws_webservice_id numeric 10
ws_webservicetype ws_webservicemethod_id numeric 10
ws_webservicetype ws_webservicetype_id numeric 10
ws_webservicetype ws_webservicetype_uu varchar 36  √  NULL::character varying
ws_webservicetypeaccess ad_client_id numeric 10
ws_webservicetypeaccess ad_org_id numeric 10
ws_webservicetypeaccess ad_role_id numeric 10
ws_webservicetypeaccess created timestamp 29,6 statement_timestamp()
ws_webservicetypeaccess createdby numeric 10
ws_webservicetypeaccess isactive bpchar 1 'Y'::bpchar
ws_webservicetypeaccess isreadwrite bpchar 1 'Y'::bpchar
ws_webservicetypeaccess updated timestamp 29,6 statement_timestamp()
ws_webservicetypeaccess updatedby numeric 10
ws_webservicetypeaccess ws_webservicetype_id numeric 10
ws_webservicetypeaccess ws_webservicetypeaccess_uu varchar 36  √  NULL::character varying