| +Name | +Type | +Collation | +NULL | +Default | +Constraints | +Comment |
| +transitionId | +int(11) | | +No | | +PK | |
| +preserve | +int(1) | | | | | |
| +name | +varchar(50) | +utf8_general_ci | | | | +NOT NULL |
| +type | +varchar(20) | +utf8_general_ci | | | +FK | +NOT NULL, constrainted to a typeId |
| +from | +varchar(255) | +utf8_general_ci | +No | | +FK -> TIKI_CATEGORIES.categId | +should be INT, NOT NULL, FK |
| +to | +varchar(255) | +utf8_general_ci | +No | | +FK -> TIKI_CATEGORIES.categId | +should be INT, NOT NULL, FK |
| +guards | +text | +utf8_general_ci | | | | +guards should be in a rel table |
| +actionId | +int(11) | | +No | | +FK -> TIKI_TRANSITIONS_ACTIONS.ID | +Action that triggers the transition |
| +commit | +int(1) | | +No | | +0,1 | +Commit allowed or not (data protection from db side) |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |