Table TBASE2.TBASE2.CITATION Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 TYPE char 1
1 CITATION_ID bigint 8  √ 
CITATION_AUTHOR.CITATION_ID FK24AA55E38E1E4DF8
CITATION_EDITOR.CITATION_ID FK2A8955C5EC93F501
STUDY.CITATION_ID FK4B915A98E1E4DF8
2 VERSION integer 4  √  null
3 PMID varchar 255  √  null
4 URL varchar 255  √  null
5 ABSTRACT varchar 5000  √  null
6 DOI varchar 255  √  null
7 KEYWORDS varchar 255  √  null
8 PAGES varchar 255  √  null
9 PUBLISHYEAR integer 4  √  null
10 PUBLISHED smallint 2  √  null
11 TITLE varchar 255  √  null
12 ISSUE varchar 255  √  null
13 JOURNAL varchar 255  √  null
14 VOLUME varchar 255  √  null
15 ISBN varchar 255  √  null
16 BOOKTITLE varchar 255  √  null
17 CITY varchar 255  √  null
18 PUBLISHER varchar 255  √  null
19 CITATIONSTATUS_ID bigint 8  √  null
CITATIONSTATUS.CITATIONSTATUS_ID FKD8A7FAE74C983658
20 TB_STUDYID varchar 30  √  null

Table contained 890 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 CITATION_ID Must be unique Asc SQL080501230722300

Close relationships  within of separation: