display_names

Properties
Property Value    Property Value
OID24966Total size488.0 KB
OwnerpostgresTable size376.0 KB
Tablespacepg_defaultIndexes size104.0 KB
Primary key(s)Toast size8.0 KB
Estimated rows3958
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 - 13
Name Type Length Default value Allow null Unique Comment
id integer nextval('display_names_id_seq'::regclass) false true
language character varying 100 false false
entity_type character varying 100 false false
entity_id integer false false
full_name character varying 100 true false
first_name character varying 100 true false
middle_name character varying 100 true false
last_name character varying 100 true false
alias character varying 100 true false
abbreviation character varying 100 true false
short_name character varying 100 true false
prefix character varying 20 true false
suffix character varying 20 true false
Indexes - 1
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
display_names_id_key  (0, 0, 0) false true false 104.0 KB
btree (id)
Unique constraints - 1
Name Columns Comment
display_names_id_key id