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