orgs

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
orgs_id int identity 4 √ null
acquis.orgs_id FK_acquis_orgs_idR
act_usrs.orgs_id FK_act_usrs_orgs_idR
adnl_ids.orgs_id FK_adnl_ids_orgs_idR
cache_objs.orgs_id FK_cache_objs_orgs_idR
creds.orgs_id FK_creds_orgs_idR
crt_auths.orgs_id FK_crt_auths_orgs_idR
crt_keys.orgs_id FK_crt_keys_orgs_idR
crt_tmls.orgs_id FK_crt_tmls_orgs_idR
crt_whitelist_appvls.orgs_id FK_crt_whitelist_appvls_orgs_idR
crt_whitelists.orgs_id FK_crt_whitelists_orgs_idR
crts.orgs_id FK_crts_orgs_idR
dir_svcs.orgs_id FK_dir_svcs_orgs_idR
end_entities.orgs_id FK_end_entities_orgs_idR
gen_txts.orgs_id FK_gen_txts_orgs_idR
key_objs.orgs_id FK_key_objs_orgs_idR
lic_svc_srvs.orgs_id FK_lic_svc_srvs_orgs_idR
natl_regs.orgs_id FK_natl_regs_orgs_idR
ofcs.orgs_id FK_ofcs_orgs_idR
org_crts.orgs_id FK_org_crts_orgs_idR
org_ofcs.orgs_id FK_org_ofcs_orgs_idR
otps.orgs_id FK_otps_orgs_idR
roles.orgs_id FK_roles_orgs_idR
rprts.orgs_id FK_rprts_orgs_idR
sa_key_objs.orgs_id FK_sa_key_objs_orgs_idR
sa_key_usrs.orgs_id FK_sa_key_usrs_orgs_idR
sms_tmls.orgs_id FK_sms_tmls_orgs_idR
smtp_tmls.orgs_id FK_smtp_tmls_orgs_idR
srvs.orgs_id FK_srvs_orgs_idR
task_types.orgs_id FK_task_types_orgs_idR
tasks.orgs_id FK_tasks_orgs_idR
tkn_mfrs.orgs_id FK_tkn_mfrs_orgs_idR
tkn_prfls.orgs_id FK_tkn_prfls_orgs_idR
tkn_rgtr.orgs_id FK_tkn_rgtr_orgs_idR
tkn_tmls.orgs_id FK_tkn_tmls_orgs_idR
tkns.orgs_id FK_tkns_orgs_idR
usr_appvls.orgs_id FK_usr_appvls_orgs_idR
usr_grp_restr_relns.orgs_id FK_usr_grp_restr_relns_orgs_idR
usr_grps.orgs_id FK_usr_grps_orgs_idR
usrs.orgs_id FK_usrs_orgs_idR
org_name nvarchar 200 √ null
org_domain_suffix nvarchar 200 √ null
org_nr nvarchar 200 √ null
org_domain_suffix_whitelist nvarchar 1000 √ null
org_permissions nvarchar 200 √ null
org_mediation_task_addr nvarchar 600 √ null
org_mediation_task_zip nvarchar 100 √ null
org_mediation_task_city nvarchar 200 √ null
org_crt_type int 4 √ null
org_uniq_crt_src int 4 null
org_adnl_info nvarchar 2147483647 √ null
org_adnl_data nvarchar 2147483647 √ null
org_adnl_task_info nvarchar 2147483647 √ null
org_l nvarchar 200 √ null
org_c nvarchar 20 √ null
org_s nvarchar 200 √ null
org_mediation_task_name nvarchar 200 √ null
org_mail_addr nvarchar 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_orgs_id Primary key Asc orgs_id

Relationships

Close relationships within degrees of separation