ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| service_id | UNSIGNED INT | NOT NULL | Primary key |
| service_name | CHAR(128) | NOT NULL | |
| service_type | VARCHAR(40) | NOT NULL | |
| auth_required | CHAR(1) | NOT NULL | |
| secure_required | CHAR(1) | NOT NULL | |
| url_path | CHAR(1) | NOT NULL | |
| user_id | UNSIGNED INT | ||
| parameter | VARCHAR(250) | ||
| statement | LONG VARCHAR | ||
| remarks | LONG VARCHAR |
Each row holds a description of a web service.
service_id A unique identifying number for the web service.
service_name The name assigned to the web service.
service_type The type of the service; for example, RAW, HTTP, XML, SOAP, or DISH.
auth_required (Y/N) Indicates whether all requests must contain a valid user name and password.
secure_required (Y/N) Indicates whether insecure connections, such as HTTP, are to be accepted, or only secure connections, such as HTTPS.
url_path Controls the interpretation of URLs.
user_id If authentication is enabled, identifies the user, or group of users, that have permission to use the service. If authentication is disabled, specifies the account to use when processing requests.
parameter A prefix that identifies the SOAP services to be included in a DISH service.
statement A SQL statement that is always executed in response to a request. If NULL, arbitrary statements contained in each request are executed instead. Ignored for services of type DISH.