Table |
cm_cous |
|---|---|
Description |
Per-CO unit definitions |
Column |
Format |
Description |
Definition |
Comments |
|---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
co_id |
integer, foreign key |
CO Record ID |
cm_cos:id |
|
parent_cou_id |
integer, foreign key |
pointer to parent cou |
cm_cous:id |
|
lft |
integer, foreign key |
left sibling in tree |
required by CakePHP for tree functions |
|
rght |
integer, foreign key |
right sibling in tree |
required by CakePHP for tree functions |
|
name |
varchar(128) |
COU name |
|
|
description |
varchar(256) |
Description |
|
|
Note: The CakePHP implementation of the model that represents this table includes code that enables the model to support a tree structure and leverage class MPTT behavior. The result is extra structure not easily seen in the table definition above. Refer to the implementation for details.