tkns

366 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tkns_id int identity 4 √ null
crts.tkns_id FK_crts_tkns_idR
key_objs.tkns_id FK_key_objs_tkns_idR
tkn_usr_relns.tkns_id FK_tkn_usr_relns_tkns_idR
tkn_tmls_id int 4 √ null
tkn_tmls.tkn_tmls_id FK_tkns_card_templates_idR
key_blobs_id int 4 √ null
key_objs.key_objs_id FK_tkns_key_blobs_idR
orgs_id int 4 √ null
orgs.orgs_id FK_tkns_orgs_idR
tkn_snr nvarchar 200 √ null
tkn_seqnr1 nvarchar 200 √ null
tkn_seqnr2 nvarchar 200 √ null
tkn_valid_to datetime 16,3 √ null
tkn_valid_from datetime 16,3 √ null
tkn_lbl nvarchar 200 √ null
tkn_status int 4 null
tkn_status_rsn int 4 null
tkn_adnl_info nvarchar 2147483647 √ null
tkn_rec_binary varbinary 2147483647 √ null
tkn_prfls_id int 4 √ null
tkn_prfls.tkn_prfls_id FK_tkns_tkn_prfls_idR
tkn_contactless nvarchar 600 √ null
tkn_rec_type int 4 √ null
tkn_terms_binary varbinary 2147483647 √ null
tkn_hist_datetime datetime 16,3 √ null
tkn_hist_type nvarchar 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tkns_id Primary key Asc tkns_id

Relationships

Close relationships within degrees of separation