submission_search_objects

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
object_id bigserial 19 nextval('submission_search_objects_object_id_seq'::regclass)
submission_search_object_keywords.object_id submission_search_object_keywords_object_id_foreignC
submission_id int8 19 null
submissions.submission_id submission_search_object_submissionC
type int4 10 null

Type of item. E.g., abstract, fulltext, etc.

assoc_id int8 19 null

Optional ID of an associated record (e.g., a file_id)

Indexes

Constraint Name Type Sort Column(s)
submission_search_objects_pkey Primary key Asc object_id
submission_search_objects_submission_id Performance Asc submission_id

Relationships