SchemaSpy Analysis of idempiere11.adempiere - ColumnsWebServices | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:57 +0100 |
| |||||
|
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 |