Table pvsadmin.public.rating Generated by
SchemaSpy
Legend: SourceForge.net
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
rating_id serial 10  √  nextval(('rating_id_seq'::text)::regclass)
rating_candidate.rating_id rating_candidate__rating_id_fk C
rating_category.rating_id rating_category__rating_id_fk C
rating_tag.rating_id rating_tag__rating_fk C
sig_id int4 10
sig.sig_id rating__sig_id_fk C
ratingformat_id int2 5
ratingformat.ratingformat_id rating__ratingformat_id_fk R
ratingsession_id int2 5 (-1)
ratingsession.ratingsession_id rating__ratingsession_id_fk R
release_id int2 5 0
release.release_id rating__release_id_fk R
span varchar 2147483647 ''::character varying
ratingtext text 2147483647 ''::text
description text 2147483647 ''::text
name varchar 2147483647 ''::character varying
usesigrating bool 1  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 7,881 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
rating_id Primary key Asc rating__pk
release_id Performance Asc rating__release_id
sig_id Performance Asc rating__sig_id
Performance rating__span__lastyear

Close relationships  within of separation: