Table zfindb.informix.webpages 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 varchar 40
webcmimages.id Implied Constraint R
project varchar 40
object_type varchar 40
mime_type varchar 40
description varchar 250  √  null
author varchar 40  √  null
page_version int 10  √  null
last_changed datetime year to fraction(3) 23  √  null
last_changed_by varchar 40  √  null
write_level int 10  √  null
read_level int 10  √  null
object html 8192  √  null

Table contained 76 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
object + id Must be unique Asc/Asc webpages_primary_key_index

Close relationships: