Table jibu_db.public.tokens
令牌

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('tokens_id_seq'::regclass) AUTO INCREMENT
value varchar 64 令牌值,用于通过系统认证
type varchar 16 令牌类型,如 password 表示该令牌只用于密码找回
expiration_ts timestamptz 35,6 令牌的过期时间
send_to varchar 64 令牌被发送到哪个邮箱,如密码找回,就发送到创建令牌的用户自己的邮箱。
created_by int4 10
userbase.id tokens_created_by_fkey R
创建此令牌的用户

Table contained 0 rows at Thu May 14 14:15 UTC 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc tokens_pkey
value Must be unique Asc tokens_value_key

Close relationships: