vdsOrgUnit
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
|