Table cal_holding
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
cal_holding_authors.cal_holding_id fke8d9b45b85bed736 R
cal_holding_ids.cal_holding_id fkcca73c4b85bed736 R
cal_portion.holding_id fk26541c764d844e25 R
author_list text 2147483647  √  null
comments text 2147483647  √  null
description text 2147483647  √  null
id_list text 2147483647  √  null
issue_date timestamp 29,6  √  null
issue_number varchar 256  √  null
length varchar 512  √  null
out_of_print bool 1
pub_date varchar 20  √  null
publisher text 2147483647  √  null
title text 2147483647  √  null
type varchar 20  √  null
volume varchar 256  √  null
item_id int8 19  √  null
item.id fk7ec66f526f7f1a9c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc cal_holding_pkey
item_id Must be unique Asc cal_holding_item_id_key
item_id Performance Asc holdingitemindex

Close relationships  within of separation: