| 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 |
0,1 |
Commit allowed or not (data protection from db side) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
