Creation of Record Table for Attachments to Each of the Work Orders.
Data model
Fields
| Field |
Type |
Description |
| attc_address |
NVARCHAR (MAX) |
Address information associated with work order. |
| attc_creation_date* |
DATETIME |
Attachment post date associated with the work order. |
| attc_description |
NVARCHAR (MAX) |
Description of the attachment |
| attc_file_extension |
NVARCHAR (MAX) |
Attachment extension. |
| attc_file_path |
NVARCHAR (MAX) |
physical path where the attachment is located. |
| attc_file_size |
NVARCHAR (MAX) |
Size of the attachment. |
| attc_id* |
INT |
Primary Table Key |
| attc_latitude |
DECIMAL |
Latitude information associated with work order. |
| attc_longitude |
DECIMAL |
Length information associated with work order. |
| attc_object_id |
INT |
Object type identifier associated with the attachment. |
| attc_real_file_name |
NVARCHAR (MAX) |
Name of the attachment added to the work order. |
| attc_server_file_name |
NVARCHAR (MAX) |
A server name that is used to generate the attachment location path. |
| attc_type_id* |
INT |
Identifier for associating attachment type. |
| attc_type_sign |
NVARCHAR (200) |
Attachment sync type. |
| work_id |
INT |
Identifier for associating current document record attachment to the work order. |
Primary Key
| PK_AFLS_ATTACHMENTS |
| attc_id |
References
