Used to store domain information, a domain covers a unique set of entities
| Column Name | Column Datatype | Column Null Option | Column Comment |
| domain_uuid | byte(16) | not null | Primary Key: uuid of the domain |
| asset_uuid | byte(16) | with null | Asset uuid ( point to an asset where the domain is located) |
| parent_domain_uuid | byte(16) | with null | Parent domain Uuid, just in case it is a domain whcih is linked to an enterprise domain |
| label | nvarchar(255) | with null | User readable name
Default DBHOSTNAME |
| description | nvarchar(255) | with null | User entered description about the Domain |
| db_host_name | nvarchar(255) | with null | Hostname for Database |
| db_server | nvarchar(255) | with null | Database Server Name (Including i.e instance) |
| db_type | nvarchar(255) | with null | Database Type. Ingres, Sql Server |
| db_name | nvarchar(255) | with null | Name for Common Database |
| db_user_name | nvarchar(255) | with null | Default crypted Username used in order to connect to Database Server |
| db_instance | nvarchar(255) | with null | Instance indentifier e.g. WV or II for Ingres |
| creation_user | nvarchar(255) | with null | Database user or component/process that created the record |
| creation_date | integer | with null | Creation date/Time |
| last_update_user | nvarchar(255) | with null | Database user or component/process that updated the record |
| last_update_date | integer | with null | Last Change Date/Time |
| version_number | integer | with null | Last version number |
| dis_hw_uuid | byte(16) | with null | Global uuid, use a common way to generate them |
| domain_type | integer | with null | Type of domain
e.g. 0=Domain 1=Enterprise |
| domain_id | integer | with null | This field contains the DSM internal domain identifier. It is used for backward compatibility. It is like an alias identifier for the domain_uuid. |
| usage_list | byte(32) | with null | This filed contains derived information and will be updated
by a trigger.
Use to check which components are installed/registerd fro a domain (derived from manager component table) |
| contact_information | nvarchar(255) | with null | This field is used to store information about a contact person for a domain. The contact information can be defined by a user. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| domain_uuid | ca_coapi_agent_view_v1 ca_coapi_agent_view_nosrv_v1 ca_coapi_agent_view_nosrv ca_group_def |
domain_uuid |
| domain_uuid | ca_discovered_user | domain_uuid |
| domain_uuid | ca_discovered_hardware | domain_uuid |
| domain_uuid | ca_n_tier | parent_domain_uuid |
| domain_uuid | ca_link_lic_def_domain | domain_uuid |