| Previous: assignment_display | Unanet Data Model | Next: bank_account |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | attachment_key | decimal(15) | |||
| 2. | attachment_name | varchar(255) | ||||
| 3. | attachment_data | image | ||||
| 4. | attachment_mime_type | varchar(255) | ||||
| 5. | attachment_length | decimal(15) | ||||
| Table | Column | Foreign Key Name |
| bank_account | attachment_key | fk_bank_account3 |
| customer_attachment | attachment_key | fk_customer_attachment2 |
| expense_report_attachment | attachment_key | fk_expense_report_attachment2 |
| fin_document_attachment | attachment_key | fk_fin_document_attachment2 |
| image_setup | attachment_key | fk_image_setup1 |
| note_comment_attachment | attachment_key | fk_note_comment_attachment2 |
| project_note_attachment | attachment_key | fk_project_note_attachment2 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_attachment | true | attachment_key | Asc |