Recommended primary keys
Active Directory
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 |
info
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.
Windows file system
| Referencing Table | Foreign Key | Parent table | Primary Key |
|---|---|---|---|