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

idempiere9.adempiere contains 96 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ws_webservice ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservice_para ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicefieldinput ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicefieldoutput ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicemethod ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicetype ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicetypeaccess ad_client_id numeric 10 Client/Tenant for this installation.
ws_webservicefieldinput ad_column_id numeric 10  √  null Column in the table
ws_webservicefieldoutput ad_column_id numeric 10  √  null Column in the table
ws_webservice ad_org_id numeric 10 Organizational entity within client
ws_webservice_para ad_org_id numeric 10 Organizational entity within client
ws_webservicefieldinput ad_org_id numeric 10 Organizational entity within client
ws_webservicefieldoutput ad_org_id numeric 10 Organizational entity within client
ws_webservicemethod ad_org_id numeric 10 Organizational entity within client
ws_webservicetype ad_org_id numeric 10 Organizational entity within client
ws_webservicetypeaccess ad_org_id numeric 10 Organizational entity within client
ws_webservicefieldinput ad_reference_id numeric 10  √  NULL::numeric System Reference and Validation
ws_webservicefieldinput ad_reference_value_id numeric 10  √  NULL::numeric Required to specify, if data type is Table or List
ws_webservicetypeaccess ad_role_id numeric 10 Responsibility Role
ws_webservicetype ad_table_id numeric 10  √  null Database Table information
ws_webservicefieldinput columnname varchar 30  √  NULL::character varying Name of the column in the database
ws_webservice_para constantvalue varchar 2000  √  null Constant value
ws_webservice created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservice_para created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservicefieldinput created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservicefieldoutput created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservicemethod created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservicetype created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservicetypeaccess created timestamp 29,6 statement_timestamp() Date this record was created
ws_webservice createdby numeric 10 User who created this records
ws_webservice_para createdby numeric 10  √  null User who created this records
ws_webservicefieldinput createdby numeric 10  √  null User who created this records
ws_webservicefieldoutput createdby numeric 10  √  null User who created this records
ws_webservicemethod createdby numeric 10 User who created this records
ws_webservicetype createdby numeric 10 User who created this records
ws_webservicetypeaccess createdby numeric 10 User who created this records
ws_webservice description varchar 255  √  null Optional short description of the record
ws_webservicemethod description varchar 255  √  null Optional short description of the record
ws_webservicetype description varchar 255  √  null Optional short description of the record
ws_webservice help varchar 2000  √  null Comment or Hint
ws_webservicemethod help varchar 2000  √  null Comment or Hint
ws_webservicetype help varchar 2000  √  null Comment or Hint
ws_webservicefieldinput identifierlogic varchar 2000  √  null Identifier Logic
ws_webservicetype insertparameters bpchar 1  √  NULL::bpchar Create Default Parameters
ws_webservice isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservice_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicefieldinput isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicefieldoutput isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicemethod isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicetype isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicetypeaccess isactive bpchar 1 'Y'::bpchar The record is active in the system
ws_webservicefieldinput isidentifier bpchar 1  √  'N'::bpchar This column is part of the record identifier
ws_webservicefieldinput isnullidentifier bpchar 1  √  'N'::bpchar Should allow null value for identifiere field
ws_webservicetypeaccess isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ws_webservice name varchar 60 Alphanumeric identifier of the entity
ws_webservicemethod name varchar 60 Alphanumeric identifier of the entity
ws_webservicetype name varchar 60 Alphanumeric identifier of the entity
ws_webservice_para parametername varchar 60  √  null Parameter Name
ws_webservice_para parametertype bpchar 1 Parameter Type
ws_webservice updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservice_para updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservicefieldinput updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservicefieldoutput updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservicemethod updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservicetype updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservicetypeaccess updated timestamp 29,6 statement_timestamp() Date this record was updated
ws_webservice updatedby numeric 10 User who updated this records
ws_webservice_para updatedby numeric 10  √  null User who updated this records
ws_webservicefieldinput updatedby numeric 10  √  null User who updated this records
ws_webservicefieldoutput updatedby numeric 10  √  null User who updated this records
ws_webservicemethod updatedby numeric 10 User who updated this records
ws_webservicetype updatedby numeric 10 User who updated this records
ws_webservicetypeaccess updatedby numeric 10 User who updated this records
ws_webservice value varchar 40 Search key for the record in the format required - must be unique
ws_webservicemethod value varchar 40 Search key for the record in the format required - must be unique
ws_webservicetype value varchar 40 Search key for the record in the format required - must be unique
ws_webservice ws_webservice_id numeric 10 Web Service
ws_webservicemethod ws_webservice_id numeric 10  √  null Web Service
ws_webservicetype ws_webservice_id numeric 10 Web Service
ws_webservice_para ws_webservice_para_id numeric 10 Web Service Parameters
ws_webservice_para ws_webservice_para_uu varchar 36  √  NULL::character varying WS_WebService_Para_UU
ws_webservice ws_webservice_uu varchar 36  √  NULL::character varying WS_WebService_UU
ws_webservicefieldinput ws_webservicefieldinput_id numeric 10 Web Service Field Input
ws_webservicefieldinput ws_webservicefieldinput_uu varchar 36  √  NULL::character varying WS_WebServiceFieldInput_UU
ws_webservicefieldoutput ws_webservicefieldoutput_id numeric 10 Web Service Field Output
ws_webservicefieldoutput ws_webservicefieldoutput_uu varchar 36  √  NULL::character varying WS_WebServiceFieldOutput_UU
ws_webservicemethod ws_webservicemethod_id numeric 10 Web Service Method
ws_webservicetype ws_webservicemethod_id numeric 10 Web Service Method
ws_webservicemethod ws_webservicemethod_uu varchar 36  √  NULL::character varying WS_WebServiceMethod_UU
ws_webservice_para ws_webservicetype_id numeric 10 Web Service Type
ws_webservicefieldinput ws_webservicetype_id numeric 10 Web Service Type
ws_webservicefieldoutput ws_webservicetype_id numeric 10 Web Service Type
ws_webservicetype ws_webservicetype_id numeric 10 Web Service Type
ws_webservicetypeaccess ws_webservicetype_id numeric 10 Web Service Type
ws_webservicetype ws_webservicetype_uu varchar 36  √  NULL::character varying WS_WebServiceType_UU
ws_webservicetypeaccess ws_webservicetypeaccess_uu varchar 36  √  NULL::character varying WS_WebServiceTypeAccess_UU