wos_conference

12593049 rows


Description

Summary Conference Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_conf_date.id wos_conf_date_id_conf_record_id_fkey C
wos_conf_info.id wos_conf_info_id_conf_record_id_fkey C
wos_conf_location.id wos_conf_location_id_conf_record_id_fkey C
wos_conf_sponsor.id wos_conf_sponsor_id_conf_record_id_fkey C
wos_conf_title.id wos_conf_title_id_conf_record_id_fkey C
wos_summary.id wos_conference_id_fkey C

WOS Record ID
conf_record_id int4 10 √ null
wos_conf_date.conf_record_id wos_conf_date_id_conf_record_id_fkey C
wos_conf_info.conf_record_id wos_conf_info_id_conf_record_id_fkey C
wos_conf_location.conf_record_id wos_conf_location_id_conf_record_id_fkey C
wos_conf_sponsor.conf_record_id wos_conf_sponsor_id_conf_record_id_fkey C
wos_conf_title.conf_record_id wos_conf_title_id_conf_record_id_fkey C

Order of conference record
conf_id varchar 2147483647 √ null

Conference Identifier
conf_info_count varchar 2147483647 √ null

Count of conf_info data. There may be multiple variations of conference information for one conference.
conf_title_count varchar 2147483647 √ null

Conference title count
conf_date_count varchar 2147483647 √ null

Conference date count
conf_location_count varchar 2147483647 √ null

Conference location count
varchar 2147483647 √ null

Conference sponsor count

Indexes

Constraint Name Type Sort Column(s)
idx_conf_record_id Performance Asc conf_record_id
wos_conference_id_conf_record_id_key Must be unique Asc/Asc id + conf_record_id

Relationships

Close relationships within degrees of separation