Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.pwi_report 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
id serial 10  √  nextval('pwi_report_id_seq'::regclass)
pwi_report_label.id Implied Constraint R
pwi_report_label.report_id pwi_report_label_report_id_fkey C
name text 2147483647
description text 2147483647  √  null
sql_text text 2147483647
report_author text 2147483647
requested_by text 2147483647
created timestamp 29,6 now()
last_run timestamp 29,6  √  now()
last_run_duration text 2147483647  √  null
report_views text 2147483647  √  null
type text 2147483647  √  null

Table contained 16 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key, Used to cluster data Asc pwi_report_pkey
report_author Performance Asc pwi_report_idx_report_author
requested_by Performance Asc pwi_report_idx_requested_by

Close relationships: