Table oc312.public.rule Generated by
SchemaSpy
Legend:
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('rule_id_seq'::regclass)
study_module_status.id Implied Constraint R
name varchar 255  √  null
description varchar 255  √  null
oc_oid varchar 40  √  null
enabled bool 1  √  null
rule_expression_id int4 10
owner_id int4 10  √  null
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
status_id int4 10  √  null
version int4 10  √  null
study_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pk_rule
oc_oid Performance Asc i_rule_oc_oid
rule_expression_id Performance Asc i_rule_rule_expression_id
status_id Performance Asc i_rule_status_id

Close relationships: