wos_grants

49993724 rows


Description

Grant Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_grant_agencies.id wos_grant_agencies_id_grant_rec_id_fkey C
wos_grant_data_items.id wos_grant_data_items_id_grant_rec_id_fkey C
wos_grant_ids.id wos_grant_ids_id_grant_rec_id_fkey C
wos_summary.id wos_grants_id_fkey C

WOS Record ID
grant_rec_id int4 10 √ null
wos_grant_agencies.grant_rec_id wos_grant_agencies_id_grant_rec_id_fkey C
wos_grant_data_items.grant_rec_id wos_grant_data_items_id_grant_rec_id_fkey C
wos_grant_ids.grant_rec_id wos_grant_ids_id_grant_rec_id_fkey C

Order of grant record data
grant_source varchar 2147483647 √ null

Grant source
grant_id_count varchar 2147483647 √ null

Count of grant IDs
grant_data_item_count varchar 2147483647 √ null

Count of grant data items

Indexes

Constraint Name Type Sort Column(s)
idx_grant_rec_id Performance Asc grant_rec_id
wos_grants_id_grant_rec_id_key Must be unique Asc/Asc id + grant_rec_id

Relationships

Close relationships within degrees of separation