| Previous: shared_criteria_value | Unanet Data Model | Next: skill |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | attachment_key | decimal(15) | |||
| 2. | legal_entity_key | decimal(15) | customer | fk_shared_document1 | ||
| 3. | document_org_key | decimal(15) | customer | fk_shared_document2 | ||
| 4. | document_number | varchar(15) | ||||
| 5. | description | varchar(128) | ||||
| 6. | comments | varchar(2000) | ||||
| 7. | created_by | decimal(15) | person | fk_shared_document3 | ||
| 8. | last_updated_by | decimal(15) | person | fk_shared_document4 | ||
| 9. | created_timestamp | datetime | ||||
| 10. | last_updated_timestamp | datetime | ||||
| 11. | project_key | decimal(15) | project | fk_shared_document5 | ||
| 12. | customer_key | decimal(15) | customer | fk_shared_document6 | ||
| 13. | vendor_key | decimal(15) | customer | fk_shared_document7 | ||
| 14. | organization_key | decimal(15) | customer | fk_shared_document8 | ||
| 15. | user01 | varchar(128) | ||||
| 16. | user02 | varchar(128) | ||||
| 17. | user03 | varchar(128) | ||||
| 18. | user04 | varchar(128) | ||||
| 19. | user05 | varchar(128) | ||||
| 20. | user06 | varchar(128) | ||||
| 21. | user07 | varchar(128) | ||||
| 22. | user08 | varchar(128) | ||||
| 23. | user09 | varchar(128) | ||||
| 24. | user10 | varchar(128) | ||||
| 25. | user11 | varchar(128) | ||||
| 26. | user12 | varchar(128) | ||||
| 27. | user13 | varchar(128) | ||||
| 28. | user14 | varchar(128) | ||||
| 29. | user15 | varchar(128) | ||||
| 30. | user16 | varchar(128) | ||||
| 31. | user17 | varchar(128) | ||||
| 32. | user18 | varchar(128) | ||||
| 33. | user19 | varchar(128) | ||||
| 34. | user20 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| legal_entity_key | customer | customer_key | fk_shared_document1 |
| document_org_key | customer | customer_key | fk_shared_document2 |
| customer_key | customer | customer_key | fk_shared_document6 |
| vendor_key | customer | customer_key | fk_shared_document7 |
| organization_key | customer | customer_key | fk_shared_document8 |
| created_by | person | person_key | fk_shared_document3 |
| last_updated_by | person | person_key | fk_shared_document4 |
| project_key | project | project_key | fk_shared_document5 |
| Table | Column | Foreign Key Name |
| attachment_reference | shared_document_key | fk_attachment_reference3 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_shared_document | true | attachment_key | Asc |