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 |