Tables


SchemaSpy Analysis of NiPDB

Generated on Wed Mar 11 11:12 CET 2020

XML Representation
Insertion Order Deletion Order
TABLES 60
VIEWS 0
COLUMNS 528
Constraints 76
Anomalies 22
Routines 0

Database Properties

Database Type: Microsoft SQL Server - 14.00.2027

Tables

Table / View Children Parents Columns Rows Type Comments
crt_whitelist_appvls 0 2 7 0 Table
role_privilege_relns 0 1 2 1796 Table
acquis_usr_relns 0 2 3 0 Table
otps 0 1 6 0 Table
natl_regs 0 1 14 2 Table
creds 1 1 7 4 Table
usr_grp_relns 0 2 2 194 Table
end_entities 1 1 17 0 Table
lic_svc_srvs 0 1 5 1 Table
key_objs 1 2 12 120 Table
tkn_tmls 2 2 18 34 Table
crt_tmls 2 2 53 25 Table
lic_svc_masters 1 1 12 0 Table
ofcs 2 1 20 8 Table
orgs 39 0 19 5 Table
tkn_rgtr 0 1 21 5 Table
act_usrs 0 2 9 3 Table
usr_grps 3 1 3 24 Table
privileges 0 0 2 181 Table
acquis 1 1 8 0 Table
crts 0 7 29 466 Table
adnl_ids 0 1 9 31 Table
roles 2 1 3 24 Table
adm_cfgs 0 0 1 1 Table
lic_svc_custs 1 0 8 3 Table
task_type_privilege_relns 0 0 2 136 Table
cm_soc_sec_nrs 1 0 4 153 Table
role_usr_grp_relns 0 2 2 24 Table
tkn_prfls 1 1 6 25 Table
sms_tmls 0 1 5 1 Table
sa_key_usrs 1 1 4 0 Table
usr_imgs 0 0 4 52 Table
crt_keys 0 1 7 0 Table
task_types 0 1 8 136 Table
gen_txts 0 1 7 5 Table
tasks 0 3 14 16 Table
org_ofc_addrs 0 1 5 0 Table
sa_key_usr_relns 0 2 2 0 Table
smtp_tmls 0 1 11 3 Table
lic_svc_machines 0 1 9 0 Table
tkn_crt_tml_relns 0 2 2 59 Table
sa_key_objs 1 1 4 0 Table
tkn_usr_relns 0 2 2 212 Table
tkns 3 4 20 366 Table
crt_auths 2 1 13 7 Table
unit_tests 0 0 3 0 Table
dir_svcs 0 1 9 3 Table
org_ofcs 1 1 4 0 Table
usr_ofcs_relns 0 2 2 7 Table
tkn_mfrs 1 2 10 2 Table
usr_grp_restr_relns 0 1 3 9 Table
crt_whitelists 1 1 16 0 Table
org_crts 0 1 6 4 Table
usrs 7 3 23 148 Table
version 0 0 2 1 Table
rprts 0 1 5 13 Table
srvs 1 1 7 21 Table
gen_sets 0 0 3 19 Table
usr_appvls 0 1 8 0 Table
cache_objs 0 1 6 7 Table