crts

466 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
crts_id int identity 4 √ null
orgs_id int 4 √ null
orgs.orgs_id FK_crts_orgs_idR
crt_auths_id int 4 √ null
crt_auths.crt_auths_id FK_crts_crt_auths_idR
usrs_id int 4 √ null
usrs.usrs_id FK_crts_usrs_idR
tkns_id int 4 √ null
tkns.tkns_id FK_crts_tkns_idR
srvs_id int 4 √ null
srvs.srvs_id FK_crts_srvs_idR
end_entities_id int 4 √ null
end_entities.end_entities_id FK_crts_end_entities_idR
crt_tmls_id int 4 √ null
crt_tmls.crt_tmls_id FK_crts_crt_tmls_idR
crt_binary varbinary 2147483647 √ null
crt_snr nvarchar 200 √ null
crt_subj nvarchar 1000 √ null
crt_issuer nvarchar 200 √ null
crt_valid_from datetime 16,3 √ null
crt_valid_to datetime 16,3 √ null
crt_requester_name nvarchar 400 √ null
crt_rev_datetime datetime 16,3 √ null
crt_rev_by nvarchar 400 √ null
crt_hidden bit 1 null
crt_type int 4 null
crt_key_binary varbinary 2147483647 √ null
crt_status int 4 null
crt_status_rsn int 4 null
crt_thumbprint nvarchar 400 √ null
crt_ku nvarchar 20 √ null
crt_nfcn_type int 4 √ null
crt_nfcn_value nvarchar 200 √ null
crt_subj_alt_name nvarchar 1000 √ null
crt_mfr_tml_name nvarchar 200 √ null
crt_adnl_info nvarchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_crts_id Primary key Asc crts_id

Relationships

Close relationships within degrees of separation