Table: shared_document

Columns
  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)      
Foreign Keys
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
Referenced from
Table Column Foreign Key Name
attachment_reference shared_document_key fk_attachment_reference3
Indices
Index Name Unique Column Name Asc Or Desc
pk_shared_document true attachment_key Asc