persons

Properties
Property Value    Property Value
OID25209Total size664.0 KB
OwnerpostgresTable size288.0 KB
Tablespacepg_defaultIndexes size376.0 KB
Primary key(s)Toast size0 bytes
Estimated rows3937
Comment
Statistics
Property Value    Property Value
seq_scan0n_dead_tup0
seq_tup_read0last_vacuum-
idx_scan0last_autovacuum-
idx_tup_fetch0last_analyze-
n_tup_ins0last_autoanalyze-
n_tup_upd0vacuum_count0
n_tup_del0autovacuum_count0
n_tup_hot_upd0analyze_count0
n_live_tup0autoanalyze_count0
Columns - 10
Name Type Length Default value Allow null Unique Comment
id integer nextval('persons_id_seq'::regclass) false true
person_key character varying 100 false false
publisher_id integer false false
gender character varying 20 true false
birth_date character varying 30 true false
death_date character varying 30 true false
birth_location_id integer true false
hometown_location_id integer true false
residence_location_id integer true false
death_location_id integer true false
Indexes - 3
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
persons_id_key  (0, 0, 0) false true false 104.0 KB
btree (id)
idx_fk_per_pub_id__pub_id  (0, 0, 0) false false false 104.0 KB
btree (publisher_id)
idx_persons_1  (0, 0, 0) false false false 168.0 KB
btree (person_key)
Unique constraints - 1
Name Columns Comment
persons_id_key id
Foreign keys - 5
Name Keys Reference table Reference keys Match type Delete type Update type
fk_per_bir_loc_id__loc_id birth_location_id locations id no action no action
fk_per_hom_loc_id__loc_id hometown_location_id locations id no action no action
fk_per_pub_id__pub_id publisher_id publishers id no action no action
fk_per_dea_loc_id__loc_id death_location_id locations id no action no action
fk_per_res_loc_id__loc_id residence_location_id locations id no action no action