SchemaSpy Analysis of idempiere9.adempiere - ColumnsWebServices | Generated by Quality Systems & Solutions |
Generated on 2021-12-25 14:57 +0100 |
| |||||
|
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 |