The vdsOrgUnit table contains fields for the specified organizational units.
Columns
Table: vdsOrgUnit table columns | Column name | Data type | Primary key | Nullable | Description |
|---|
| vdsDomain | varchar(255) | Yes | No | The domain to which the organizational unit belongs. |
| vdsOrgUnit | varchar(255) | Yes | No | The name of the organizational unit. |
| vdsDescription | varchar(1024) | No | Yes | |
| vdsParentOrgUnit | varchar(255) | No | Yes | The parent organizational unit. This is used to define a hierarchy of organizational units. |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
Keys
Primary key: (vdsDomain, vdsOrgUnit)
Foreign keys:
- (vdsDomain) references vdsDomain (vdsDomain)
- (vdsDomain, vdsParentOrgUnit) references vdsOrgUnit (vdsDomain, vdsOrgUnit)
Indexes
Table: vdsOrgUnit table indexes | Index name | Included fields |
|---|
| Level 0 (default) |
| vdsorgidx | vdsDomain vdsOrgUnit |