| Table: users |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | χ | √ | nextval('users_id_seq'::regclass) | ||
| login | varchar | 40 | χ | χ | login id | ||
| name | varchar | 100 | χ | χ | ''::character varying | User name | |
| varchar | 100 | χ | χ | email address | |||
| city | varchar | 255 | χ | χ | ''::character varying | ||
| country | varchar | 255 | χ | χ | ''::character varying | ||
| area | varchar | 255 | √ | χ | null | ||
| crypted_password | varchar | 40 | χ | χ | |||
| salt | varchar | 40 | √ | χ | null | ||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| remember_token | varchar | 40 | √ | χ | null | ||
| remember_token_expires_at | timestamp | 29,6 | √ | χ | null | ||
| access_level | level_of_access | 2147483647 | χ | χ | data to which user has access | ||
| page_access_level | level_of_access | 2147483647 | χ | χ | Determines the extent of data, if any, that user can edit. | ||
| apikey | varchar | 255 | √ | χ | null | ||
| state_prov | varchar | 255 | χ | χ | ''::character varying | ||
| postal_code | varchar | 255 | χ | χ | ''::character varying |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | users_pkey |
| login | Must be unique | Asc | index_users_on_login |
|
