Recommended primary keys
In a standard Active Directory environment, the following primary keys are typically used:
Referencing Table | Foreign Key | Parent table | Primary Key |
|---|---|---|---|
Memberships | group | Groups | objectGUID |
Memberships | member | Users | objectGUID |
Note
It is possible to use distinguishedName as a key for these tables, but it is recommended to use objectGUID when possible, because it is immutable.
Referencing Table | Foreign Key | Parent table | Primary Key |
|---|---|---|---|