System database tables

This database contains all objects and configurations of the system.

act_usrs

This table stores and contains information of current logged in users.

Table 1. act_usrs
Column name	Description	Data type
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
usrs_id	The id of current user.	bigint (8 bytes long integer) (Foreign key relation to usrs.usrs_id) NULL is allowed.
act_usr_name	The name of current user.	nvarchar(300) NULL is allowed.
act_usr_log_datetime	The date and time when the user logged in.	datetime NULL is allowed.
act_usr_idle_datetime	The date time when user latest was active.	datetime NULL is allowed.
act_usr_type	The type of login as enum. \{internal.enum.activeusertype}	int (4 bytes integer) NULL is not allowed.
act_usr_session_id	The current session if of the logged in user.	nvarchar(200) NULL is allowed.
act_usr_ticket_bin	The internal information of the current logged in user.	varbinary(max) NULL is allowed.

adnl_ids

This table stores and contains additional identities of stored users.

Table 2. adnl_ids
Column name	Description	Data type
adnl_ids_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
adnl_id_type	The type of the additional identity.	nvarchar(100) NULL is not allowed.
adnl_id_value	The value of the additional identity.	nvarchar(max) NULL is not allowed.
adnl_id_orgn_type	The type of origin service as enum. \{internal.enum.originservicetype}	int (4 bytes integer) NULL is not allowed.
adnl_id_ent_type	The type of entity of the item.	int (4 bytes integer) NULL is not allowed.
adnl_id_ent_ref_id	The reference id to the entity.	bigint (8 bytes long integer) NULL is not allowed.
adnl_id_searchable	The indication (1/0 (true/false)) of searching the value.	bit NULL is not allowed.
adnl_id_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

cache_objs

This table stores and contains cache items that is used by the system.

Table 3. cache_objs
Column name	Description	Data type
cache_objs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
cache_obj_type	The internal type of the cache item.	int (4 bytes integer) NULL is not allowed.
cache_obj_type_adnl	The additional type of the cache item.	nvarchar(100) NULL is allowed.
cache_obj_property	The additional property of of the cahce item.	nvarchar(500) NULL is not allowed.
cache_obj_binary	The data of the cache item.	varbinary(max) NULL is not allowed.

cntctlss_svcs

This table stores and contains information of contactless services.

Table 4. cntctlss_svcs
Column name	Description	Data type
cntctlss_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
cntctlss_svc_type	The type of service as enum. \{internal.enum.contactlessservicetype}	int (4 bytes integer) NULL is not allowed.
cntctlss_svc_srv	The IP address or DNS name to the service.	nvarchar(100) NULL is allowed.
cntctlss_svc_port	The port to the service.	nvarchar(100) NULL is allowed.
cntctlss_svc_crt_hash	The digest value of the certificate used for authentication.	nvarchar(100) NULL is allowed.
cntctlss_svc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

creds

This table stores and contains additional credential information of services.

Table 5. creds
Column name	Description	Data type
cntctlss_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
cred_type	The type of service for the credential.	int (4 bytes integer) NULL is not allowed.
cred_ref_id	The reference id to the service.	Bigint (8 bytes long integer) NULL is allowed.
cred_obj_name	The data name of the credential.	varbinary(max) NULL is allowed.
cred_obj_value	The data value of the credential.	varbinary(max) NULL is allowed.
cred_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

crt_auths

This table stores and contains information of the certificate authority services.

Table 6. crt_auths
Column name	Description	Data type
crt_auths_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
crt_auth_name	The name of the service.	nvarchar(100) NULL is allowed.
crt_auth_srv	The IP address of DNS name of the service.	nvarchar(100) NULL is allowed.
crt_auth_descr	The description of the service.	nvarchar(300) NULL is allowed.
crt_auth_crt_hash	The digest value of the certificate used for authentication.	nvarchar(100) NULL is allowed.
crt_auth_sign_crt_hash	The digest value of the certificate used for signature.	nvarchar(100) NULL is allowed.
crt_auth_mfr_type	The type of manufacturer of the service as enum. \{internal.certificateauthority.type}	int (4 bytes integer) NULL is not allowed.
crt_auth_enrl_type	The type of enrollment mode of the service as enum.	int (4 bytes integer) NULL is not allowed.
crt_auth_crl_list	The explicit URL to the CRL.	nvarchar(500) NULL is allowed.
crt_auth_ocsp_list	The explicit URL to the OCSP.	nvarchar(500) NULL is allowed.
crt_auth_key_id	The certificate authority key id has hex encoded string.	nvarchar(50) NULL is allowed.
crt_auth_crt	The certificate of the service as base64 encoded string.	nvarchar(max) NULL is allowed.
crt_auth_allow_login	The indication (1/0 (true/false)) of allow service for login against the system.	bit NULL is not allowed.
crt_auth_enabled	The indication (1/0 (true/false)) of enabled/disabled service.	bit NULL is not allowed.
crt_auth_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

crt_keys

This table stores and contains information of the certificate keys. Certificate keys are certificate + key (PKCS#12 data) that can be used for recover against hardware tokens or end entities.

Table 7. crt_keys
Column name	Description	Data type
crt_keys_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
crt_key_type	The type of certificate key.	int (4 bytes integer) NULL is not allowed.
crt_key_ref_id	The reference id against the certificate stored in the crts table.	nvarchar(100) NULL is not allowed.
crt_key_value	The data value of the certificate key.	varbinary(max) NULL is not alloed.
crt_key_passw	The password of the certificate key.	varbinary(max) NULL is not alloed.
crt_key_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

crt_reqs

This table stores and contains information of the certificate requests. The stored certificate requests can be used for renewal of end entity certificates and key regulations.

Table 8. crt_reqs
Column name	Description	Data type
crt_reqs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
crt_req_type	The type of certificate request.	int (4 bytes integer) NULL is not allowed.
crt_req_value	The certificate request as base64 encoded string.	nvarchar(max) NULL is not allowed.
crt_req_crt_ref_id	The reference id against the certificate stored in the crts table.	bigint (8 bytes long integer) NULL is allowed.
crt_req_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

crt_tmls

This table stores and contains information of the certificate templates.

Table 9. crt_tmls
Column name:	Description:	Data type:
crt_tmls_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
crt_auths_id	The id of current certificate authority.	bigint (8 bytes long integer) (Foreign key relation to crt_auths. crt_auths_id) NULL is allowed.
crt_tml_type	The type of reference of the certificate as enum. \{internal.certificatetemplate.referencetype}	int (4 bytes integer) NULL is not allowed.
crt_tml_name	The name of the certificate template.	nvarchar(100) NULL is allowed.
crt_tml_mfr_name	The native name of the certificate template of the certificate authority.	nvarchar(100) NULL is allowed.
crt_tml_mfr_profile_name	The native name of the certificate profile of the certificate authority.	nvarchar(100) NULL is allowed.
crt_tml_mfr_end_entity	The native name of the end entity of the certificate authority.	nvarchar(100) NULL is allowed.
crt_tml_descr	The description of the certificate template.	nvarchar(300) NULL is not allowed.
crt_tml_validity_key	The identifier of the validity key as a numeric value.	int (4 bytes integer) NULL is allowed.
crt_tml_validity_value	The value of the validity as a numeric value.	int (4 bytes integer) NULL is allowed.
crt_tml_rec	The indication (1/0 (true/false)) of support certificate recover.	bit NULL is not allowed.
crt_tml_visible	The indication (1/0 (true/false)) of show/hide the certificate template in ordinary tasks.	bit NULL is allowed.
crt_tml_adnl_task_info	The additional information/configuration of the specified task (not is use).	nvarchar(max) NULL is allowed.
crt_tml_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

crts

This table stores and contains information of issued certificates.

Table 10. crts
Column name	Description	Data type
crts_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
crt_auths_id	The id of current certificate authority.	bigint (8 bytes long integer) (Foreign key relation to crt_auths. crt_auths_id) NULL is allowed.
crt_tmls_id	The id of current certificate template.	bigint (8 bytes long integer) (Foreign key relation to crt_tmls. crt_tmls_id) NULL is allowed.
crt_req_ref_id	The user id of the requestor of the certificate.	bigint (8 bytes long integer) NULL is allowed.
crt_binary	The issued X509 certificate stored as binary.	varbinary(max) NULL is allowed.
crt_snr	The serial number of the issued certificate.	nvarchar(100) NULL is allowed.
crt_thumbprint	The thumbprint of the issued certificate.	nvarchar(200) NULL is allowed.
crt_subject	The subject distinguished name of the issued certificate.	nvarchar(500) NULL is allowed.
crt_subject_name	The subject common name of the issued certificate.	nvarchar(300) NULL is allowed.
crt_issuer	The issuer distinguished name of the issued certificate.	nvarchar(500) NULL is allowed.
crt_issuer_name	The issuer common name of the issued certificate.	nvarchar(300) NULL is allowed.
crt_subject_alt_name	The subject alternative names of the issued certificate.	nvarchar(500) NULL is allowed.
crt_subject_key_identifier	The subject key identifier of the issued certificate.	nvarchar(300) NULL is allowed.
crt_auth_tml_name	The native certificate authority template name of the issued certificate.	nvarchar(300) NULL is allowed.
crt_valid_from	The date time when the certificate was issued by the the certificate authority.	datetime NULL is allowed.
crt_valid_to	The date time when the certificate expires.	datetime NULL is allowed.
crt_status	The current status of the issued certificate as enum. \{internal.certificate.status}	int (4 bytes integer) NULL is not allowed.
crt_status_rsn	The current reason of status of the issued certificate as enum. \{internal.certificate.statusreason}	int (4 bytes integer) NULL is not allowed.
crt_rev_datetime	The date time of revocation of the issued certificate.	datetime NULL is allowed.
crt_rev_by	The internal unique name of the user that revoked the certificate.	nvarchar(200) NULL is allowed.
crt_extra_info	The optional extra information of the certificate.	nvarchar(300) NULL is allowed.
crt_ku	The key usage of the issued certificate.	nvarchar(10) NULL is allowed.
crt_ref_type	The type of reference of the certificate as enum. \{internal.certificate.referencetype}	int (4 bytes integer) NULL is allowed.
crt_ref_id	The id of the owner of the certificate. The unique id of the user or end entity.	bigint (8 bytes long integer) NULL is allowed.
crt_key_issuance_type	The type of issuance how the certificate was enrolled as enum. \{internal.certificate.issuancetype}	int (4 bytes integer) NULL is allowed.
crt_enrollment_type	The type of enrollment as enum. \{internal.certificate.enrollmenttype}	int (4 bytes integer) NULL is allowed.
crt_nfcn_lvl	The current level of notification.	int (4 bytes integer) NULL is allowed.
crt_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

ctzn_svcs

This table stores and contains information of the citizen services.

Table 11. ctzn_svcs
Column name	Description	Data type
ctzn_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
ctzn_svc_type	The type of citizen service as enum. \{internal.citizenservice.type}	int (4 bytes integer) NULL is not allowed.
ctzn_svc_search_type	The type of search argument of the service.	int (4 bytes integer) NULL is not allowed.
ctzn_svc_name	The name of the citizen service.	nvarchar(100) NULL is not allowed.
ctzn_svc_srv	The server URL against the service.	nvarchar(500) NULL is not allowed.
ctzn_svc_crt_hash	The digest value of the certificate used for authentication.	nvarchar(100) NULL is allowed.
ctzn_svc_cust_id	The customer id of the subscription.	nvarchar(100) NULL is allowed.
ctzn_svc_order_id	The order id of the subscription.	nvarchar(100) NULL is allowed.
ctzn_svc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

dir_svcs

This table stores and contains information of the directory services.

Table 12. dir_svcs
Column name	Description	Data type
dir_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
dir_svc_type	The type of service.	int (4 bytes integer) NULL is not allowed.
dir_svc_auth_type	The type of authentication of the service.	int (4 bytes integer) NULL is not allowed.
dir_svc_srv	The server URL against the service.	nvarchar(500) NULL is not allowed.
dir_svc_crt_hash	The digest value of the certificate used for authentication.	nvarchar(100) NULL is allowed.
dir_svc_client_id	The client app id of the service (usual for EntraID).	nvarchar(100) NULL is allowed.
dir_svc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

end_entities

This table stores and contains information of the end entity items.

Table 13. end_entities
Column name	Description	Data type
end_entities_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
end_entity_ref_id	The reference id of the end entity (not in use).	bigint (8 bytes long integer) NULL is allowed.
end_entity_ofc_ref_id	The reference id of an office.	bigint (8 bytes long integer) NULL is allowed.
end_entity_orgn_ref_id	The reference id against the origin service.	nvarchar(100) NULL is not allowed.
end_entity_orgn_type_id	The reference type of the origin service as enum. \{internal.endentity.origintype}	int (4 bytes integer) NULL is not allowed.
end_entity_type	The type of end entity as enum. \{internal.endentity.type}	int (4 bytes integer) NULL is allowed.
end_entity_type_adnl	The subordinated type of the end entity.	nvarchar(100) NULL is allowed.
end_entity_name	The name of the end entity.	nvarchar(500) NULL is not allowed.
end_entity_org_value	The specific name of an organization of the end entity.	nvarchar(100) NULL is allowed.
end_entity_org_nr	The organization number of the end entity.	nvarchar(50) NULL is allowed.
end_entity_org_l	The locality of the end entity.	nvarchar(50) NULL is allowed.
end_entity_org_c	The country of the end entity.	nvarchar(10) NULL is allowed.
end_entity_snr	The serial number of the end entity.	nvarchar(100) NULL is allowed.
end_entity_mail_addr	The email address of the end entity.	nvarchar(200) NULL is allowed.
end_entity_mobile_nr	The mobile number of the end entity.	nvarchar(50) NULL is allowed.
end_entity_resp_name	The name of a responsible user of the end entity.	nvarchar(100) NULL is allowed.
end_entity_resp_mail_addr	The email address of a responsible user of the end entity.	nvarchar(200) NULL is allowed.
end_entity_resp_mobile_nr	The mobile number of a responsible user of the end entity.	nvarchar(50) NULL is allowed.
end_entity_flags	The behavior flags of the end entity (not in use).	nvarchar(10) NULL is allowed.
end_entity_valid_from	The date time when the end entity was created.	datetime NULL is allowed.
end_entity_valid_to	The date time of expiration of the end entity.	datetime NULL is allowed.
end_entity_status	The status of the end entity as enum. \{internal.endentity.status}	int (4 bytes integer) NULL is not allowed.
end_entity_status_adnl	The additional status of the end entity.	nvarchar(50) NULL is allowed.
end_entity_orgn_sync	The date time when an end entity was synchronized against the origin service.	datetime NULL is allowed.
end_entity_extra_info	The optional extra information of the end entity.	nvarchar(300) NULL is allowed.
end_entity_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

ent_keys

This table stores and contains information of the public keys of the entities.

Table 14. ent_keys
Column name	Description	Data type
ent_keys_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
ent_key_type	The type of key.	int (4 bytes integer) NULL is not allowed.
ent_key_alg	The algorithm OID of the key.	nvarchar(100) NULL is not allowed.
ent_key_value	The key as hex encoded string.	nvarchar(max) NULL is not allowed.
ent_key_ent_ref_type	The entity reference type.	int (4 bytes integer) NULL is not allowed.
ent_key_ent_ref_id	The entity reference id.	bigint (8 bytes long integer) NULL is not allowed.
ent_key_param	The parameter of the key.	nvarchar(max) NULL is not allowed.
ent_key_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

ent_usr_grp_relns

This table stores and contains information of relations between entities and user groups for user group restrictions of different kind of purposes.

Table 15. ent_usr_grp_relns
Column name	Description	Data type
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
ent_usr_grp_type	The type of relation.	int (4 bytes integer) NULL is not allowed.
ent_usr_grp_ent_ref_id	The entity reference id.	bigint (8 bytes long integer) NULL is not allowed.
usr_grps_id	The user group reference id.	bigint (8 bytes long integer) NULL is allowed.
ent_usr_grp_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

imgs

This table stores and contains information of images.

Table 16. imgs
Column name	Description	Data type
imgs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
img_binary	The data of the image.	varbinary(max) NULL is not allowed.
img_created_datetime	The date time when the image was stored into the table.	datetime NULL is not allowed.
img_type	The type of the image.	int (4 bytes integer) NULL is not allowed.
img_format_type	The format of the image.	int (4 bytes integer) NULL is not allowed.
img_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

lic_svc_custs

This table is not in use.

lic_svc_machines

This table is not in use.

lic_svc_masters

This table is not in use.

lic_svc_srvs

This table stores and contains information of licenses of the server.

Table 17. lic_svc_srvs
Column name	Description	Data type
lic_svc_srvs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
lic_svc_srv_value	The customer data of the license.	nvarchar(max) NULL is allowed.
lic_svc_srv_demo	The default data of the license.	nvarchar(max) NULL is allowed.
lic_svc_srv_nfcn_amount_lvl	The notification level of amount.	int (4 bytes integer) NULL is allowed.
lic_svc_srv_nfcn_validity_lvl	The notification level of validity.	int (4 bytes integer) NULL is allowed.
lic_svc_srv_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

ofcs

This table stores and contains information of offices.

Table 18. ofcs
Column name	Description	Data type
ofcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
ofc_name	The name of the office.	nvarchar(100) NULL is not allowed.
ofc_org_name	The name of the organization.	nvarchar(100) NULL is not allowed.
ofc_street_addr	The street address of the office.	nvarchar(100) NULL is not allowed.
ofc_postal_addr	The postal address of the office.	nvarchar(100) NULL is allowed.
ofc_postal_code	The postal code of the office.	nvarchar(100) NULL is allowed.
ofc_postal_city	The postal city of the office.	nvarchar(100) NULL is allowed.
ofc_postal_c	The postal country of the office.	nvarchar(10) NULL is allowed.
ofc_mail_addr	The email address of the office.	nvarchar(100) NULL is allowed.
ofc_phone_nr	The phone numer of the office.	nvarchar(50) NULL is allowed.
ofc_contct_pers1	The contact person of the office.	nvarchar(100) NULL is allowed.
ofc_contct_pers2	The secondary contact person of the office.	nvarchar(100) NULL is allowed.
ofc_inv_postal_addr	The postal address for invoicing	nvarchar(100) NULL is allowed.
ofc_inv_postal_code	The postal code for invoicing.	nvarchar(100) NULL is allowed.
ofc_inv_postal_city	The postal city for invoicing.	nvarchar(100) NULL is allowed.
ofc_inv_postal_c	The postal country for invoicing.	nvarchar(10) NULL is allowed.
ofc_cost_cntr	The cost center for invoicing.	nvarchar(100) NULL is allowed.
ofc_tkn_mfr_ref_id	The custom office id of the token manufacturer.	nvarchar(100) NULL is allowed.
ofc_obj_hash	The digest value latest change of information.	nvarchar(100) NULL is allowed.
ofc_status	The status indication of the office.	int (4 bytes integer) NULL is allowed.
ofc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

org_crts

This table stores and contains information of organization certificates.

Table 19. org_crts
Column name	Description	Data type
org_crts_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
org_crt_type	The type of cerificate.	int (4 bytes integer) NULL is not allowed.
org_crt_hash	The digest value of the certificate.	nvarchar(100) NULL is not allowed.
org_crt_value	The certificate data.	nvarchar(max) NULL is not allowed.
org_crt_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

org_relns

This table stores and contains information of organization relations for cross permission purposes.

Table 20. org_relns
Column name	Description	Data type
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
org_reln_id	The id of the organization,	bigint (8 bytes long integer) NULL is not allowed.

orgs

This table stores and contains information of organizations.

Table 21. orgs
Column name	Description	Data type
orgs_id	The id of organization.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
org_name	The name of the organization.	nvarchar(100) NULL is allowed.
org_domain_suffix	The domain suffix of the organization.	nvarchar(100) NULL is allowed.
org_nr	The organization number.	nvarchar(100) NULL is allowed.
org_l	The locality of the organization.	nvarchar(100) NULL is allowed.
org_s	The state of the organization.	nvarchar(100) NULL is allowed.
org_c	The country of the organization.	nvarchar(10) NULL is allowed.
org_mail_addr	The email address of the organization.	nvarchar(100) NULL is allowed.
org_img_ref_id	The reference id of image.	bigint (8 bytes long integer) NULL is allowed.
org_style	The HTML-style codes used by GUI.	nvarchar(300) NULL is allowed.
org_status	The status of the organization.	int (4 bytes integer) NULL is allowed.
org_crt_type	Not in use.	int (4 bytes integer) NULL is allowed.
org_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

otps

This table stores and contains information of temporary one-time-password values for users.

Table 22. otps
Column name	Description	Data type
orgs_id	The id of organization.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
otp_type	The type of the OTP.	int (4 bytes integer) NULL is not allowed.
otp_valid_to	The validity of the OTP.	datetime NULL is not allowed.
otp_value	The value of the OTP.	nvarchar(100) NULL is not allowed.
otp_attempts	The number of attempts of the OTP.	int (4 bytes integer) NULL is not allowed.
otp_ent_ref_id	The reference id of the user.	bigint (8 bytes long integer) NULL is not allowed.

privileges

This table stores and contains information of static privileges.

Table 23. privileges
Column name	Description	Data type
privilege_id	The id of the privilege.	bigint (8 bytes long integer) NULL is not allowed.
privilege_name	The name of the privilege.	nvarchar(100) NULL is not allowed.

receipts

This table stores and contains information of receipts.

Table 24. receipts
Column name	Description	Data type
receipts_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
usrs_id	The reference id of the user.	bigint (8 bytes long integer) (Foreign key relation to usrs.usrs_id) NULL is allowed.
receipt_type	The type of receipt.	int (4 bytes integer) NULL is not allowed.
receipt_ref_id	The reference id of the entity.	bigint (8 bytes long integer) NULL is allowed.
receipt_content	The content of the receipt.	nvarchar(max) NULL is allowed.
receipt_signature	The signature of the receipt.	nvarchar(max) NULL is allowed.
receipt_signature_alg	The signature algorithm of the receipt.	int (4 bytes integer) NULL is allowed.
receipt_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

role_privilege_relns

This table stores and contains information of relations between roles and privileges.

Table 25. role_privilege_relns
Column name	Description	Data type
roles_id	The reference id of the role.	bigint (8 bytes long integer) (Foreign key relation to roles.roles_id) NULL is allowed.
privilege_ref_id	The reference id of the privilege.	bigint (8 bytes long integer) NULL is not allowed.

role_restr_relns

This table stores and contains information of relations of roles for restriction purpose.

Table 26. role_restr_relns
Column name	Description	Data type
roles_id	The reference id of the role.	bigint (8 bytes long integer) NULL is not allowed.
role_restr_id	The reference id of the role.	bigint (8 bytes long integer) NULL is not allowed.

role_usr_grp_relns

This table stores and contains information of relations between roles and user groups.

Table 27. role_usr_grp_relns
Column name	Description	Data type
roles_id	The reference id of the role.	bigint (8 bytes long integer) (Foreign key relation to roles.roles_id) NULL is allowed.
usr_grps_id	The reference id of the user group.	bigint (8 bytes long integer) (Foreign key relation to usr_grps. usr_grps_id) NULL is allowed.

roles

This table stores and contains information of roles.

Table 28. roles
Column name	Description	Data type
roles_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
role_name	The name of the role.	nvarchar(300) NULL is not allowed.

rprts

This table stores and contains information of reports.

Table 29. rprts
Column name	Description	Data type
rprts_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
rprt_name	The name of the report.	nvarchar(100) NULL is not allowed.
rprt_descr	The description of the report.	nvarchar(max) NULL is allowed.
rprt_query	The SQL-query of the report.	nvarchar(max) NULL is allowed.

sms_svcs

This table stores and contains information of SMS services.

Table 30. sms_svcs
Column name	Description	Data type
sms_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
sms_svc_name	The name of the service.	nvarchar(100) NULL is not allowed.
sms_svc_srv	The server URL of the service.	nvarchar(100) NULL is not allowed.
sms_svc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

smtp_svcs

This table stores and contains information of SMTP services.

Table 31. smtp_svcs
Column name	Description	Data type
smtp_svcs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
smtp_svc_name	The name of the service.	nvarchar(100) NULL is not allowed.
smtp_svc_srv	The server URL of the service.	nvarchar(100) NULL is not allowed.
smtp_svc_port	The port of the service.	nvarchar(10) NULL is allowed.
smtp_svc_use_ssl	The indication (1/0 (true/false)) of using SSL against the service.	bit NULL is not allowed.
smtp_svc_sender_name	The name of sender.	nvarchar(100) NULL is allowed.
smtp_svc_sender_addr	The email address of the sender.	nvarchar(100) NULL is allowed.
smtp_svc_subj	The subject of the sender.	nvarchar(100) NULL is allowed.
smtp_svc_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

system_cfgs

This table stores and contains information of system configuration.

Table 32. system_cfgs
Column name	Description	Data type
system_cfgs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
system_cfg_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

system_msgs

This table stores and contains information of system messages.

Table 33. system_msgs
Column name	Description	Data type
system_msgs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
system_msg_name	The name of message item.	nvarchar(100) NULL is not allowed.
system_msg_value	The value of the message item.	nvarchar(500) NULL is not allowed.
system_msg_valid_from	The validity of the message.	datetime NULL is allowed.
system_msg_valid_to	The validity of the message.	datetime NULL is allowed.
system_msg_enabled	The indication (1/0 (true/false)) of enable/disable the message item.	bit NULL is not allowed.
system_msg_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

task_cfgs

This table stores and contains information of task configuration.

Table 34. task_cfgs
Column name	Description	Data type
task_cfgs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
task_cfg_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

task_data_objs

This table stores and contains information of temporary data of tasks.

Table 35. task_data_objs
Column name	Description	Data type
task_data_objs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
tasks_id	The id of current task.	bigint (8 bytes long integer) NULL is not allowed.
task_data_obj_type	The type of task data.	int (4 bytes integer) NULL is not allowed.
task_data_obj_binary	The task data.	varbinary(max) NULL is not allowed.
task_data_obj_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

task_dlgn_exc_relns

This table stores and contains information of temporary delegation exception information of tasks.

Table 36. task_dlgn_exc_relns
Column name	Description	Data type
task_dlgn_exc_relns_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
tasks_id	The id of current task.	bigint (8 bytes long integer) (Foreign key relation to tasks.tasks_id) NULL is allowed.
task_dlgn_relns_id	The id of current task delegation item.	bigint (8 bytes long integer) (Foreign key relation to task_dlgn_relns.task_dlgn_relns_id) NULL is allowed.
task_dlgn_exc_reln_flag	The flags of the delegation exception type.	nvarchar(10) NULL is not allowed.
task_dlgn_exc_reln_ref_id	The reference of entity of the delegation exception type.	bigint (8 bytes long integer) NULL is not allowed.

task_dlgn_relns

This table stores and contains information of temporary delegation information of tasks.

Table 37. task_dlgn_relns
Column name	Description	Data type
task_dlgn_relns_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
tasks_id	The id of current task.	bigint (8 bytes long integer) (Foreign key relation to tasks.tasks_id) NULL is allowed.
task_dlgn_reln_flag	The flags of the delegation item.	nvarchar(10) NULL is not allowed.
task_dlgn_reln_ref_id	The reference of entity of the delegation type.	bigint (8 bytes long integer) NULL is not allowed.

tasks

This table stores and contains information of tasks.

Table 38. tasks
Column name	Description	Data type
tasks_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
task_type_ref_id	The reference id of the task type.	bigint (8 bytes long integer) NULL is not allowed.
task_type_adnl	The additional type of task type.	nvarchar(100) NULL is allowed.
task_req_ref_id	The reference id of the requestor (creator) of the task.	bigint (8 bytes long integer) NULL is not allowed.
task_proc_ref_id	The reference id of the processor (current) of the task.	bigint (8 bytes long integer) NULL is not allowed.
task_ent_ref_id	The reference id of the entity of the task.	bigint (8 bytes long integer) NULL is allowed.
task_ent_type	The type of entity of the task.	int (4 bytes integer) NULL is not allowed.
task_ent_descr	The description of the entity of the task.	nvarchar(500) NULL is allowed.
task_valid_from	The date time when task was created.	datetime NULL is not allowed.
task_valid_to	The date time when the task expires.	datetime NULL is not allowed.
task_proc_datetime	The date time of current processing.	datetime NULL is not allowed.
task_proc_valid_to	The date time when processing expires and will be released.	datetime NULL is not allowed.
task_dlgn_flags	The flags of delegation of the task.	nvarchar(10) NULL is allowed.
task_status	The status of the task.	int (4 bytes integer) NULL is not allowed.
task_status_adnl	The additional status of the task.	int (4 bytes integer) NULL is allowed.
task_bin	The data of the task item.	varbinary(max) NULL is not allowed.
task_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

text_agreements

This table stores and contains information of text agreements that has been verified by users.

Table 39. text_agreements
Column name	Description	Data type
text_agreements_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
text_agreement_type	The type of the agreement.	nvarchar(100) NULL is not allowed.
text_agreement_ent_type	The type of entity of the agreement doing the action (a user).	int (4 bytes integer) NULL is not allowed.
text_agreement_ent_ref_id	The reference id of the entity doing the action (id of the user).	bigint (8 bytes long integer) NULL is not allowed.
text_agreement_ref_ent_type	The type of entity of the agreement.	int (4 bytes integer) NULL is allowed.
text_agreement_ref_ent_ref_id	The reference id of the entity of the agreement.	bigint (8 bytes long integer) NULL is allowed.
text_agreement_sub_ref_type	The type of the subordinated entity (e.g. certificate of a token).	int (4 bytes integer) NULL is allowed.
text_agreement_sub_ref_id	The reference id of the subordinated entity (e.g. certificate of a token).	bigint (8 bytes long integer) NULL is allowed.
text_agreement_value	The agreement value in clear text.	nvarchar(max) NULL is allowed.
text_agreement_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

texts

This table stores and contains information of texts that will be used for server generated text, e.g. notifications, agreements etc.

Table 40. texts
Column name	Description	Data type
texts_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
text_lang	The language code of the text.	nvarchar(10) NULL is allowed.
text_data	The text data as XML.	nvarchar(max) NULL is allowed.
text_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_crt_relns

This table stores and contains information of relations between tokens and certificates.

Table 41. tkn_crt_relns
Column name	Description	Data type
tkns_id	The reference id of the token.	bigint (8 bytes long integer) (Foreign key relation to tkns.tkns_id) NULL is allowed.
crts_id	The reference id of the certificate.	bigint (8 bytes long integer) (Foreign key relation to crts.crts_id) NULL is allowed.

tkn_crt_tml_relns

This table stores and contains information of relations between token templates and certificates templates.

Table 42. tkn_crt_tml_relns
Column name	Description	Data type
tkn_tmls_id	The reference id of the token template.	bigint (8 bytes long integer) (Foreign key relation to tkn_tmls. tkn_tmls_id) NULL is allowed.
crt_tmls_id	The reference id of the certificate template.	bigint (8 bytes long integer) (Foreign key relation to crt_tmls. crt_tmls_id) NULL is allowed.

tkn_keys

This table stores and contains information of unlock/administration keys of tokens.

Table 43. tkn_keys
Column name	Description	Data type
tkn_keys_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkns_id	The reference id of the token.	bigint (8 bytes long integer) (Foreign key relation to tkns.tkns_id) NULL is allowed.
tkn_key_value	The token key data.	varbinary(max) NULL is not allowed.
tkn_key_prfl_key_ref_id	The reference id of the key against the token profile data.	int (4 bytes integer) NULL is not allowed.
tkn_key_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_mfr_artcls

This table stores and contains information of token manufacturer articles.

Table 44. tkn_mfr_artcls
Column name:	Description:	Data type:
tkn_mfr_artcls_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_mfrs_id	The reference id of the token manufacturer.	bigint (8 bytes long integer) (Foreign key relation to tkn_mfrs. tkn_mfrs_id) NULL is allowed.
tkn_mfr_artcl_name	The name of the article.	nvarchar(100) NULL is not allowed.
tkn_mfr_artcl_descr	The description of the article.	nvarchar(300) NULL is allowed.
tkn_mfr_artcl_type	The type of article as enum. \{internal.tokenmanufacturerarticle.type}	int (4 bytes integer) NULL is not allowed.
tkn_mfr_artcl_tkn_type	The token type as enum. \{internal.tokenmanufacturerarticle.tokentype}	int (4 bytes integer) NULL is allowed.
tkn_mfr_artcl_prfl_id	The reference id of the the token profile.	bigint (8 bytes long integer) NULL is allowed.
tkn_mfr_artcl_enabled	The indication (1/0 (true/false)) of enabled/disabled article.	bit NULL is not allowed.
tkn_mfr_artcl_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_mfrs

This table stores and contains information of token manufacturer services.

Table 45. tkn_mfrs
Column name	Description	Data type
tkn_mfrs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_mfr_type	The type of the manufacturer as enum. \{internal.tokenmanufacturer.type}	int (4 bytes integer) NULL is not allowed.
tkn_mfr_name	The name of manufacturer as enum. \{internal.tokenmanufacturer.name}	int (4 bytes integer) NULL is not allowed.
tkn_mfr_srv	The server URL against the service.	nvarchar(500) NULL is allowed.
tkn_mfr_cust_ref_id	The customer reference of the manufacturer.	nvarchar(100) NULL is not allowed.
tkn_mfr_auth_type	The authentication type of the service.	int (4 bytes integer) NULL is not allowed.
tkn_mfr_auth_crt_hash	The digest value of the authentication certificate of the service.	nvarchar(100) NULL is allowed.
tkn_mfr_sign_crt_hash	The digest value of the signature certificate of the service.	nvarchar(100) NULL is allowed.
tkn_mfr_ref_id	The reference id of the main manufacturer.	bigint (8 bytes long integer) NULL is allowed.
tkn_mfr_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_prfl_tkn_tml_relns

This table stores and contains information of relations between token profiles and token templates.

Table 46. tkn_prfl_tkn_tml_relns
Column name	Description	Data type
tkn_prfls_id	The reference id of the token profile.	bigint (8 bytes long integer) NULL is allowed.
tkn_tmls_id	The reference id of the token template.	bigint (8 bytes long integer) NULL is allowed.

tkn_prfls

This table stores and contains information of token profiles.

Table 47. tkn_prfls
Column name	Description	Data type
tkn_prfls_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_prfl_name	The friendly name of the token profile.	nvarchar(100) NULL is allowed.
tkn_prfl_descr	The description of the token profile.	nvarchar(100) NULL is allowed.
tkn_prfl_type	The type of token.	int (4 bytes integer) NULL is allowed.
tkn_prfl_sub_type	The subordinated type of the token.	int (4 bytes integer) NULL is allowed.
tkn_prfl_atr	The ATR of the token.	nvarchar(100) NULL is allowed.
tkn_prfl_lbl	The label of the token.	nvarchar(100) NULL is not allowed.
tkn_prfl_mdl	The model of the token.	nvarchar(100) NULL is not allowed.
tkn_prfl_visible	The indication (1/0 (true/false)) of show/hide the token profile in ordinary tasks.	bit NULL is allowed.
tkn_prfl_enabled	The indication (1/0 (true/false)) of enabled/disabled token profile.	bit NULL is allowed.
tkn_prfl_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_rgtr_objs

This table stores and contains information of token register items.

Table 48. tkn_rgtr_objs
Column name	Description	Data type
tkn_rgtr_objs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_rgtr_obj_tkn_order_id	The id of the order against the manufacturer.	bigint (8 bytes long integer) NULL is allowed.
tkn_rgtr_obj_tkn_ofc_id	The id of the office of the order.	bigint (8 bytes long integer) NULL is allowed.
tkn_rgtr_obj_status	The id of current status of the token.	int (4 bytes integer) NULL is not allowed.
tkn_rgtr_obj_status_descr	The description of current status of the token.	nvarchar(100) NULL is not allowed.
tkn_rgtr_obj_usr_id	The id of the user of the token.	bigint (8 bytes long integer) NULL is allowed.
tkn_rgtr_obj_usr_name	The name of the user of the token.	nvarchar(200) NULL is allowed.
tkn_rgtr_obj_usr_snr	The serial number of the user.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_height	The height/length of the person (user).	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_eyecolor	The eye color of the person (user).	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_haircolor	The hair color of the person (user).	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_location	The location name of the user.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_title	The title of the user.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_usr_distr	The date time when token was distributed to user.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_id	The id of the token.	bigint (8 bytes long integer) NULL is not allowed.
tkn_rgtr_obj_tkn_snr	The serial number of the token.	nvarchar(100) NULL is not allowed.
tkn_rgtr_obj_tkn_seqnr1	The sequence number of the token.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_tkn_seqnr2	The secondary sequence number of the token.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_tkn_valid_to	The date time when the token expires.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_type	The type id of the token.	int (4 bytes integer) NULL is not allowed.
tkn_rgtr_obj_tkn_type_descr	The type description of the token.	nvarchar(100) NULL is not allowed.
tkn_rgtr_obj_tkn_rev_descr	The revocation reason description of the token.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_tkn_rev_datetime	The date time when the token was revoked.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_order_ref_id	The order reference value, created from the manufacturer.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_tkn_product_ref_id	The product reference of the manufacturer.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_tkn_order_created	The date time when the order was created.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_order_mfr_sent	The date time when the order was sent to manufacturer.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_order_mfr_distr	The date time when the order was distributet (sent) from manufacturer.	datetime NULL is allowed.
tkn_rgtr_obj_tkn_tml_name	The template name of the token.	nvarchar(100) NULL is allowed.
tkn_rgtr_obj_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_tmls

This table stores and contains information of token templates.

Table 49. tkn_tmls
Column name	Description	Data type
tkn_tmls_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_mfr_artcls_id	The id of the token manufacturer article.	bigint (8 bytes long integer) (Foreign key relation to tkn_mfr_artcls. tkn_mfr_artcls_id) NULL is allowed.
tkn_tml_name	The name of the token template.	nvarchar(100) NULL is not allowed.
tkn_tml_descr	The description of the token template.	nvarchar(300) NULL is not allowed.
tkn_tml_usage	The type of the token template.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_min_key	The identifier of the minimum validity key as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_min_value	The value of the minimum validity as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_def_key	The identifier of the default validity key as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_def_value	The value of the default validity as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_max_key	The identifier of the maximum validity key as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_validity_max_value	The value of the maximum validity as a numeric value.	int (4 bytes integer) NULL is allowed.
tkn_tml_visible	The indication (1/0 (true/false)) of show/hide the token template in ordinary tasks.	bit NULL is allowed.
tkn_tml_adnl_task_info	Not in use.	nvarchar(max) NULL is allowed.
tkn_tml_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tkn_usr_relns

This table stores and contains information of relations between tokens and users.

Table 50. tkn_usr_relns
Column name	Description	Data type
tkns_id	The reference id of the token.	bigint (8 bytes long integer) (Foreign key relation to tkns.tkns_id) NULL is allowed.
usrs_id	The reference id of the user.	bigint (8 bytes long integer) (Foreign key relation to usrs.usrs_id) NULL is allowed.

tkns

This table stores and contains information of tokens.

Table 51. tkns
Column name	Description	Data type
tkns_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
tkn_tmls_id	The id of the token template.	bigint (8 bytes long integer) (Foreign key relation to tkn_tmls. tkn_tmls_id) NULL is allowed.
tkn_prfls_id	The id of the token profile.	bigint (8 bytes long integer) (Foreign key relation to tkn_prfls. tkn_prfls_id) NULL is allowed.
tkn_ref_id	The reference id of the main token when the token is revoked.	bigint (8 bytes long integer) NULL is allowed.
tkn_snr	The serial number of the token.	nvarchar(100) NULL is allowed.
tkn_seqnr1	The sequence number of the token.	nvarchar(100) NULL is allowed.
tkn_seqnr2	The secondary sequence number of the token.	nvarchar(100) NULL is allowed.
tkn_valid_from	The date time when the token was created.	datetime NULL is allowed.
tkn_valid_to	The date time when the token expires.	datetime NULL is allowed.
tkn_status	The status id of the token.	int (4 bytes integer) NULL is not allowed.
tkn_status_adnl	The additional status of the token.	int (4 bytes integer) NULL is not allowed.
tkn_cntctlss	The contactless value of the token.	nvarchar(300) NULL is allowed.
tkn_hist_datetime	The date time when the token was revoked and specified as a history token.	datetime NULL is allowed.
tkn_hist_type	The token template name when token was revoked and specified as a history token.	nvarchar(100) NULL is allowed.
tkn_type	The type of the token.	int (4 bytes integer) NULL is allowed.
tkn_sub_type	The subondinated type of the token.	int (4 bytes integer) NULL is allowed.
tkn_extra_info	The optional extra information of the token.	nvarchar(300) NULL is allowed.
tkn_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

tmp_objs

This table stores and contains information of temporary objects. These temporary objects is used at installation / update of the database and is not used in run time.

Table 52. tmp_objs
Column name	Description	Data type
tmp_objs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
tmp_obj_type	The type of the item.	nvarchar(100) NULL is not allowed.
tmp_obj_data	The data of the item.	nvarchar(max) NULL is not allowed.

usr_grp_relns

This table stores and contains information of relations between users and user groups.

Table 53. usr_grp_relns
Column name	Description	Data type
usr_grps_id	The reference id of the user group.	bigint (8 bytes long integer) (Foreign key relation to usr_grps. usr_grps_id) NULL is allowed.
usrs_id	The reference id of the user.	bigint (8 bytes long integer) (Foreign key relation to usrs.usrs_id) NULL is allowed.

usr_grp_restr_relns

This table stores and contains information of relations between primary user groups and restricted user groups.

Table 54. usr_grp_restr_relns
Column name	Description	Data type
usr_grp_restr_grp_id	The reference id of the user group.	bigint (8 bytes long integer) NULL is not allowed.
usr_grp_restr_grp_restr_id	The reference id of the user group.	bigint (8 bytes long integer) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.

usr_grps

This table stores and contains information of user groups.

Table 55. usr_grps
Column name	Description	Data type
usr_grps_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
usr_grp_name	The name of the user group.	nvarchar(300) NULL is not allowed.
usr_grp_orgn_type_id	The reference type of the origin service.	int (4 bytes integer) NULL is allowed.
usr_grp_orgn_ref_id	The reference value of the origin service.	nvarchar(500) NULL is allowed.

usr_ofc_relns

This table stores and contains information of relations between users and offices. These relations is used for restricted office structure.

Table 56. usr_ofc_relns
Column name	Description	Data type
usrs_id	The reference id of the user.	bigint (8 bytes long integer) (Foreign key relation to usrs. usrs_id) NULL is not allowed.
ofcs_id	The reference id of the office.	bigint (8 bytes long integer) (Foreign key relation to ofcs. ofcs_id) NULL is not allowed.

usr_seq_nr_relns

This table stores and contains information of relations between users and user sequence numbers.

Table 57. usr_seq_nr_relns
Column name	Description	Data type
usrs_id	The reference id of the user.	bigint (8 bytes long integer) (Foreign key relation to usrs. usrs_id) NULL is allowed.
usr_seq_nrs_id	The reference id of the sequence number.	bigint (8 bytes long integer) (Foreign key relation to usr_seq_nrs. usr_seq_nrs_id) NULL is allowed.

usr_seq_nrs

This table stores and contains information of user sequence numbers. These sequence numbers can be used as serial number (formatted as social security number) of users defined as persons.

Table 58. usr_seq_nrs
Column name	Description	Data type
usr_seq_nrs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
usr_seq_nr_date	The date value.	nvarchar(100) NULL is allowed.
usr_seq_nr_seq	The sequence value.	nvarchar(100) NULL is allowed.
usr_seq_nr_value	The final value of date and sequence.	nvarchar(20) NULL is allowed.
usr_seq_nr_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

usrs

This table stores and contains information of users.

Table 59. usrs
Column name	Description	Data type
usrs_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
orgs_id	The id of current organization.	bigint (8 bytes long integer) (Foreign key relation to orgs.orgs_id) NULL is allowed.
ofcs_id	The id of an office.	bigint (8 bytes long integer) (Foreign key relation to ofcs.ofcs_id) NULL is allowed.
usr_uniq_name	The internal unique name of the user.	nvarchar(500) NULL is allowed.
usr_name	The display name of the user.	nvarchar(200) NULL is allowed.
usr_fn	The first name of the user.	nvarchar(200) NULL is allowed.
usr_gn	The given name of the user.	nvarchar(200) NULL is allowed.
usr_mn	The middle name (secondary surname) of the user.	nvarchar(200) NULL is allowed.
usr_sn	The surname of the user.	nvarchar(200) NULL is allowed.
usr_snr	The serial number of the user.	nvarchar(100) NULL is allowed.
usr_mail_addr	The email address of the user.	nvarchar(200) NULL is not allowed.
usr_mobile_nr	The phone number of the user.	nvarchar(100) NULL is not allowed.
usr_empl_type_id	The type if of employment of the user.	int (4 bytes integer) NULL is not allowed.
usr_empl_start_date	The date time of predefined start of the user.	datetime NULL is allowed.
usr_empl_end_date	The date time of predefined end of the user.	datetime NULL is allowed.
usr_title	The title of the user.	nvarchar(100) NULL is allowed.
usr_img_ref_id	The reference id of the person image of the user.	bigint (8 bytes long integer) NULL is allowed.
usr_sign_img_ref_id	The reference if of the signature image of the user.	bigint (8 bytes long integer) NULL is allowed.
usr_type_id	The type of user as enum. \{internal.user.type}	int (4 bytes integer) NULL is allowed.
usr_ref_id	The reference id of a user if current user is an alias user.	bigint (8 bytes long integer) NULL is allowed.
usr_orgn_type_id	The reference type of the origin service.	int (4 bytes integer) NULL is not allowed.
usr_orgn_ref_id	The reference value of the origin service.	nvarchar(100) NULL is not allowed.
usr_orgn_sync	The date time when the user latest was synchronized against the origin service.	datetime NULL is allowed.
usr_flags	The internal flags of the user.	nvarchar(50) NULL is not allowed.
usr_name_flags	The internal name flags of the user.	nvarchar(50) NULL is allowed.
usr_extra_info	The optional extra information of the user.	nvarchar(300) NULL is allowed.
usr_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.

version

This table stores and contains information of current version of the database.

Table 60. version
Column name	Description	Data type
version_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
version	The value of the version.	nvarchar(50) NULL is allowed.