Table for creating a record of projects associated with the different tenants
Data model
Fields
| Field | Type | Description |
|---|---|---|
| proj_id* | INT | Primary key of the table with project ID. |
| proj_name* | NVARCHAR (200) | Column where the name of the project is recorded. |
| tent_id* | INT | Column where the ID of the tenant to which the project is associated is recorded. |
Primary Key
| PK_AFLS_PROJECTS |
|---|
| proj_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| tent_id* | Bod. AFLS_TENANTS | tent_id | FK01_AFLS_PROJECTS |