Table: Privilege_Dependency
Lists dependencies of Privileges in addition to the normal parent-child relationship. Tags: read-only Content of first 30 of 317 rows:
1 | 305 | 306
2 | 307 | 308
3 | 196 | 444
4 | 309 | 310
5 | 469 | 9
6 | 87 | 90
7 | 87 | 412
9 | 94 | 164
10 | 87 | 164
11 | 409 | 258
13 | 313 | 314
16 | 315 | 316
17 | 95 | 96
18 | 318 | 97
19 | 318 | 98
20 | 319 | 320
21 | 321 | 322
22 | 325 | 326
25 | 328 | 329
27 | 198 | 199
28 | 102 | 103
29 | 55 | 56
30 | 55 | 57
31 | 55 | 58
32 | 341 | 25
33 | 25 | 31
34 | 25 | 28
35 | 31 | 33
36 | 28 | 33
37 | 341 | 346
Columns
Name | Type | Constraints | Description
privilege_dependency_KEY | int | NOT NULL | Primary key for this table.
privilege_KEY | int | NOT NULL | Foreign key to a [Privilege].
dependent__privilege_KEY | int | NOT NULL | Foreign key to a [Privilege] that [privilege_KEY] depends on.

Primary key
Name | Columns | Description
PK_Privilege_Dependency$privilege_dependency_KEY | privilege_dependency_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Privilege_Dependency$privilege_KEY$dependent__privilege_KEY | privilege_KEY, dependent__privilege_KEY | No reason to have the same dependency listed twice.
Indexes
Name | Columns | Description
IX_Privilege_Dependency$dependent__privilege_KEY | dependent__privilege_KEY | Index supports foreign key FK_Privilege_Dependency__Privilege__dependent__privilege_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Privilege_Dependency__Privilege__dependent__privilege_KEY | dependent__privilege_KEY | Privilege |
FK_Privilege_Dependency__Privilege__privilege_KEY | privilege_KEY | Privilege |