Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
id |
serial |
10 |
|
√ |
nextval('studyversion_id_seq'::regclass) |
|
|
archivenote |
varchar |
1000 |
√ |
|
null |
|
|
archivetime |
timestamp |
29,6 |
√ |
|
null |
|
|
createtime |
timestamp |
29,6 |
√ |
|
null |
|
|
deaccessionlink |
varchar |
255 |
√ |
|
null |
|
|
lastupdatetime |
timestamp |
29,6 |
√ |
|
null |
|
|
releasetime |
timestamp |
29,6 |
√ |
|
null |
|
|
version |
int8 |
19 |
√ |
|
null |
|
|
versionnote |
varchar |
1000 |
√ |
|
null |
|
|
versionnumber |
int8 |
19 |
√ |
|
null |
|
|
versionstate |
varchar |
255 |
√ |
|
null |
|
|
study_id |
int8 |
19 |
|
|
|
|
study.id
|
fk_studyversion_study_id R |
|
metadata_id |
int8 |
19 |
|
|
|
|
metadata.id
|
fk_studyversion_metadata_id R |
|
Table contained 5 rows at Fri May 30 15:33 MDT 2014
|