Table cxgn.public.materialized_view

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column	Type	Size	Nulls	Auto	Default
materialized_view_id	serial	10		√	nextval('materialized_view_materialized_view_id_seq'::regclass)
last_update	timestamp	29,6	√		null
refresh_time	int4	10	√		null
name	varchar	64	√		null
mv_schema	varchar	64	√		null
mv_table	varchar	128	√		null
mv_specs	text	2147483647	√		null
indexed	text	2147483647	√		null
query	text	2147483647	√		null

Table contained 1 rows at Sun Sep 07 01:31 EDT 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
name	Must be unique	Asc	materialized_view_name_key	This unique column is also nullable