person_phases

Properties
Property Value    Property Value
OID25203Total size48.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size48.0 KB
Primary key(s)Toast size0 bytes
Estimated rows0
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 - 21
Name Type Length Default value Allow null Unique Comment
id integer nextval('person_phases_id_seq'::regclass) false true
person_id integer false false
membership_type character varying 40 false false
membership_id integer false false
role_id integer true false
role_status character varying 40 true false
phase_status character varying 40 true false
uniform_number character varying 20 true false
regular_position_id integer true false
regular_position_depth character varying 40 true false
height character varying 100 true false
weight character varying 100 true false
start_date_time timestamp without time zone true false
start_season_id integer true false
end_date_time timestamp without time zone true false
end_season_id integer true false
entry_reason character varying 40 true false
exit_reason character varying 40 true false
selection_level integer true false
selection_sublevel integer true false
selection_overall integer true false
Indexes - 6
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
person_phases_id_key  (0, 0, 0) false true false 8.0 KB
btree (id)
idx_person_phases_2  (0, 0, 0) false false false 8.0 KB
btree (membership_id)
idx_person_phases_1  (0, 0, 0) false false false 8.0 KB
btree (membership_type)
idx_fk_per_pha_reg_pos_id__pos_id  (0, 0, 0) false false false 8.0 KB
btree (regular_position_id)
idx_fk_per_pha_per_id__per_id  (0, 0, 0) false false false 8.0 KB
btree (person_id)
idx_person_phases_3  (0, 0, 0) false false false 8.0 KB
btree (phase_status)
Unique constraints - 1
Name Columns Comment
person_phases_id_key id
Foreign keys - 5
Name Keys Reference table Reference keys Match type Delete type Update type
fk_per_pha_end_sea_id__sea_id end_season_id seasons id no action no action
fk_per_pha_per_id__per_id person_id persons id no action no action
fk_per_pha_reg_pos_id__pos_id regular_position_id positions id no action no action
fk_per_pha_rol_id__rol_id role_id roles id no action no action
fk_per_pha_sta_sea_id__sea_id start_season_id seasons id no action no action