Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.pwi_report
None

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
None
name text 2147483647 None
description text 2147483647  √  null None
sql_text text 2147483647 None
report_author text 2147483647 None
requested_by text 2147483647 None
created timestamp 29,6 now() None
last_run timestamp 29,6  √  now() None
last_run_duration text 2147483647  √  null None
report_views text 2147483647  √  null None
type text 2147483647  √  null None

Table contained 14 rows at Mon May 07 06:18 EDT 2018

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: