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
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
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 19 rows at Mon Jun 07 06:53 EDT 2021

Indexes:
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: