harvest_object

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
harvest_object_error.harvest_object_id harvest_object_error_harvest_object_id_fkeyR
harvest_object_extra.harvest_object_id harvest_object_extra_harvest_object_id_fkeyR
guid text 2147483647 √ null
current bool 1 √ null
gathered timestamp 29,6 √ null
fetch_started timestamp 29,6 √ null
content text 2147483647 √ null
fetch_finished timestamp 29,6 √ null
import_started timestamp 29,6 √ null
import_finished timestamp 29,6 √ null
state text 2147483647 √ null
metadata_modified_date timestamp 29,6 √ null
retry_times int4 10 √ null
harvest_job_id text 2147483647 √ null
harvest_job.id harvest_object_harvest_job_id_fkeyR
harvest_source_id text 2147483647 √ null
harvest_source.id harvest_object_harvest_source_id_fkeyR
package_id text 2147483647 √ null
package.id harvest_object_package_id_fkeyR
report_status text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
harvest_object_pkey Primary key Asc id
guid_idx Performance Asc guid
harvest_job_id_idx Performance Asc harvest_job_id
harvest_source_id_idx Performance Asc harvest_source_id
package_id_idx Performance Asc package_id

Relationships

Close relationships within degrees of separation