injury_phases

injury_phases

Properties

Property	Value		Property	Value
OID	25092		Total size	336.0 KB
Owner	postgres		Table size	88.0 KB
Tablespace	pg_default		Indexes size	240.0 KB
Primary key(s)			Toast size	8.0 KB
Estimated rows	771
Comment

Statistics

Property	Value		Property	Value
seq_scan	0		n_dead_tup	0
seq_tup_read	0		last_vacuum	-
idx_scan	0		last_autovacuum	-
idx_tup_fetch	0		last_analyze	-
n_tup_ins	0		last_autoanalyze	-
n_tup_upd	0		vacuum_count	0
n_tup_del	0		autovacuum_count	0
n_tup_hot_upd	0		analyze_count	0
n_live_tup	0		autoanalyze_count	0

Columns - 11

Name	Type	Length	Default value	Allow null	Unique	Comment
id	integer		nextval('injury_phases_id_seq'::regclass)	false	true
person_id	integer			false	false
injury_status	character varying	100		true	false
injury_type	character varying	100		true	false
injury_comment	character varying	100		true	false
disabled_list	character varying	100		true	false
start_date_time	timestamp without time zone			true	false
end_date_time	timestamp without time zone			true	false
season_id	integer			true	false
phase_type	character varying	100		true	false
injury_side	character varying	100		true	false

Indexes - 6

Name (scan, tup_read, tup_fetch)	Primary	Unique	Clustered	Size	Definition
idx_fk_inj_pha_per_id__per_id (0, 0, 0)	false	false	false	40.0 KB	btree (person_id)
injury_phases_id_key (0, 0, 0)	false	true	false	40.0 KB	btree (id)
idx_injury_phases_4 (0, 0, 0)	false	false	false	40.0 KB	btree (end_date_time)
idx_injury_phases_3 (0, 0, 0)	false	false	false	40.0 KB	btree (start_date_time)
idx_injury_phases_2 (0, 0, 0)	false	false	false	40.0 KB	btree (injury_status)
idx_fk_inj_pha_sea_id__sea_id (0, 0, 0)	false	false	false	40.0 KB	btree (season_id)

Unique constraints - 1

Name	Columns	Comment
injury_phases_id_key	id

Foreign keys - 2

Name	Keys	Reference table	Reference keys	Match type	Delete type	Update type
fk_inj_pha_per_id__per_id	person_id	persons	id		no action	no action
fk_inj_pha_sea_id__sea_id	season_id	seasons	id		no action	no action