Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.pwi_report
A record in this table represents the custom SQL exeucted in pwi/report/index

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
primary key
name text 2147483647 report name
description text 2147483647  √  null report description
sql_text text 2147483647 sql text
report_author text 2147483647 user who created the report
requested_by text 2147483647 user who requested the report
created timestamp 29,6 now() date record was created
last_run timestamp 29,6  √  now() date record was last run
last_run_duration text 2147483647  √  null duration was last run
report_views text 2147483647  √  null not used
type text 2147483647  √  null not used

Table contained 22 rows at Mon Apr 25 09:05 EDT 2022

Column(s) Type Sort Constraint Name
id Primary key Asc pwi_report_pkey
report_author Performance Asc pwi_report_idx_report_author
requested_by Performance Asc pwi_report_idx_requested_by

Close relationships: