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

Generated by
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) Implied Constraint R
pwi_report_label.report_id pwi_report_label_report_id_fkey C
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 22 rows at Mon Mar 09 10:28 EDT 2020

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: