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 |