Table | api_users |
---|---|
Description | API (Programmatic) Users |
Column | Format | Description | Definition | Required | Comments |
---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||
co_id | integer, foreign key | CO Record ID | cos:id | ||
username | varchar(64) | API Username | |||
api_key | varchar(256) | API Key | bcrypt formatted, as per CakePHP | ||
privileged | boolean | If this API User is a "superuser" within its CO |
| ||
status | varchar(2) | API User status |
| ||
valid_from | datetime | API User is valid from this time | If null, valid any time through valid_through | ||
valid_through | datetime | API User is valid through (but not past) this time | If null, valid any time from valid_from | ||
remote_ip | varchar(80) | IP addresses this API User may connect from | Defined as regular expression, or null for any IP address |