Template:ChadoTable materialized view
From GMOD
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
| Table: | materialized_view |
| Module: | Internal |
| FK | Name | Type | Description |
|---|---|---|---|
| materialized_view_id | serial | NOT NULL | |
| last_update | timestamp without time zone | ||
| refresh_time | integer | ||
| name | character varying(64) | UNIQUE | |
| mv_schema | character varying(64) | ||
| mv_table | character varying(128) | ||
| mv_specs | text | ||
| indexed | text | ||
| query | text | ||
| special_index | text |
Tables referencing materialized_view via foreign key constraints:
- None.

