Table iliasRelease_3_10_x_branch.cp_node 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
cp_node_id int 10  √ 
cmi_node.cp_node_id Implied Constraint R
cp_auxilaryResource.cp_node_id Implied Constraint R
cp_condition.cp_node_id Implied Constraint R
cp_dependency.cp_node_id Implied Constraint R
cp_file.cp_node_id Implied Constraint R
cp_hidelmsui.cp_node_id Implied Constraint R
cp_item.cp_node_id Implied Constraint R
cp_manifest.cp_node_id Implied Constraint R
cp_mapinfo.cp_node_id Implied Constraint R
cp_objective.cp_node_id Implied Constraint R
cp_organization.cp_node_id Implied Constraint R
cp_resource.cp_node_id Implied Constraint R
cp_rule.cp_node_id Implied Constraint R
cp_sequencing.cp_node_id Implied Constraint R
nodeName varchar 50  √  null
slm_id int 10  √  null

Table contained 0 rows at Tue Aug 26 10:32 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
cp_node_id Primary key Asc PRIMARY
cp_node_id Performance Asc cp_id
nodeName Performance Asc nodeName

Close relationships: