| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
serial |
10 |
|
√ |
nextval('harvestingdataverse_id_seq'::regclass) |
| vdc.harvestingdataverse_id
|
fk_vdc_harvestingdataverse_id R |
|
|
| failedstudycount |
int8 |
19 |
√ |
|
null |
|
|
| failedstudycountnonzero |
int8 |
19 |
√ |
|
null |
|
|
| generaterandomids |
bool |
1 |
√ |
|
null |
|
|
| harvestresult |
varchar |
255 |
√ |
|
null |
|
|
| harvesttype |
varchar |
255 |
√ |
|
null |
|
|
| harvestedstudycount |
int8 |
19 |
√ |
|
null |
|
|
| harvestedstudycountnonzero |
int8 |
19 |
√ |
|
null |
|
|
| harvestingnow |
bool |
1 |
√ |
|
null |
|
|
| harvestingset |
varchar |
255 |
√ |
|
null |
|
|
| lastharvesttime |
timestamp |
29,6 |
√ |
|
null |
|
|
| lastsuccessfulharvesttime |
timestamp |
29,6 |
√ |
|
null |
|
|
| lastsuccessfulnonzeroharvesttime |
timestamp |
29,6 |
√ |
|
null |
|
|
| scheduledayofweek |
int4 |
10 |
√ |
|
null |
|
|
| schedulehourofday |
int4 |
10 |
√ |
|
null |
|
|
| scheduleperiod |
varchar |
255 |
√ |
|
null |
|
|
| scheduled |
bool |
1 |
√ |
|
null |
|
|
| serverurl |
varchar |
255 |
√ |
|
null |
|
|
| subsetrestricted |
bool |
1 |
√ |
|
null |
|
|
| version |
int8 |
19 |
√ |
|
null |
|
|
| handleprefix_id |
int8 |
19 |
√ |
|
null |
|
|
| harvestformattype_id |
int8 |
19 |
|
|
|
|
|
Table contained 0 rows at Fri May 30 15:33 MDT 2014
|