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