SchemaSpy - Table pvsadmin.public.leadership

Generated by
SchemaSpy

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

leadership_id

int2

√

nextval(('leadership_id_seq'::text)::regclass)

leadership_candidate.leadership_id	leadership_candidate__leadership_id_fk C
leadership_office.leadership_id	leadership_office__leadership_id_fk C
leadership_state.leadership_id	leadership_state__leadership_id_fk C
local_leadership.leadership_id	local_leadership__fk R
v_leadership.leadership_id	Implied Constraint R

name

varchar

2147483647

''::character varying

rank

int2

√

null

Table contained 292 rows at Tue Jan 03 04:46 MST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
leadership_id	Primary key	Asc	leadership_pk
rank	Performance	Asc	leadership__rank
name	Must be unique	Asc	leadership_name_idx