table for recording company information in AFLS.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| comp_active* | BIT | Column to identify whether the company is active or inactive. |
| comp_contact_address | NVARCHAR (1000) | Company Contact Address |
| comp_contact_email | NVARCHAR (510) | Company contact email |
| comp_contact_latitude* | DECIMAL | Latitude to set the location of the company |
| comp_contact_longitude* | DECIMAL | Length to set the location of the company |
| comp_contact_name | NVARCHAR (200) | Company Contact Name |
| comp_contact_phone | NVARCHAR (510) | Contact telephone number of the company |
| comp_id* | INT | Primary Table Key |
| comp_imported_from | NVARCHAR (200) | A field that allows you to identify which system the company has been imported from (e.g. ASDK). |
| comp_is_imported* | BIT | A field that allows you to identify whether the company has been imported from an external system or if it has been created directly from AFLS. |
| comp_name* | NVARCHAR (200) | Company name. |
| comp_unique_reference* | NVARCHAR (510) | Unique Company Reference Information (e.g. Nit) |
| proj_id | INT | column with project ID information related to the company. |
Primary Key
| PK_AFLS_COMPANIES |
|---|
| comp_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| comp_id* | Bod. AFW_COMPANY | id | FK02_AFLS_COMPANIES |
| proj_id | dbo.AFLS_PROJECTS | proj_id | FK01_AFLS_COMPANIES |