BLD (Buildings)
| Documentation | Access control |
| Name | BLD |
| Title | Buildings |
| Module | Infrastucture |
List of buildings. Building is assigned to exactly one facilitiy.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | BLDID (ID) | int | Building ID | |||||
| Building ID |
||||||||
| 2 | FACID (Facility) | int | FCL (Facilities) | ID of facility building is located in | ||||
| ID of facility building is located in References: FCL (Facilities) |
||||||||
| 3 | BLDNAM (Name) | nvarchar(50) | Building name | |||||
| Building name |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| BLD (Buildings) | FCL (Facilities) | BLD.FACID = FCL.FCLID | User-defined relation |
|
|
BLD.FACID = FCL.FCLID Name: User-defined relation |
||||
| GAT (Doors) | BLD (Buildings) | GAT.BLDID = BLD.BLDID | User-defined relation |
|
|
GAT.BLDID = BLD.BLDID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | BLDID | ||
Uses
| Name |
|---|
|
BLD (Buildings)
|
Used by
| Name |
|---|
|
BLD (Buildings)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 17:49