| Name | Type | Collation | NULL | Default | Constraints | Comment | | transitionId | int(11) | | No | | | | | preserve | int(1) | | | | | | | name | varchar(50) | utf8_general_ci | | | | | | type | varchar(20) | utf8_general_ci | | | | | | from | varchar(255) | utf8_general_ci | | | | | | to | varchar(255) | utf8_general_ci | | | | | | guards | text | utf8_general_ci | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name of object: | TIKI_TRANSITION_EVENTS | | | | | | Type of database object: | TABLE | | | | | | | | | | | | Order of fields | Field name | Type | Default | Constraints | Comments | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
| Name | Type | Collation | NOT NULL | Default | Constraints | Comment | | transitionId | int(11) | | No | | | | | preserve | int(1) | | | | | | | name | varchar(50) | utf8_general_ci | | | | +NOT NULL, maybe UNIQUE? | | type | varchar(20) | utf8_general_ci | | | | +NOT NULL, constrainted to a typeId | | from | varchar(255) | utf8_general_ci | | | | +should be INT constrainted to a TIKI_CATEGORIES.categID, NOT NULL | | to | varchar(255) | utf8_general_ci | | | | +should be INT constrainted to TIKI_CATEGORIES.categId, NOT NULL | | guards | text | utf8_general_ci | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name of object: | TIKI_TRANSITION_EVENTS | | | | | | Type of database object: | TABLE | | | | | | | | | | | | Order of fields | Field name | Type | Default | Constraints | Comments | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|