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
email 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
Column(s) Type Sort Constraint Name
id Primary key Asc users_pkey
login Must be unique Asc index_users_on_login