| 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) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name | Type | Collation | Null | Default | Constraints | Comments | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name | Type | Collation | Null | Default | Constraints | Comments | | Id | int(11) | | N | | PK | from sequence | | Name | varchar2 | | N | | Unique | unique name | | Description | varchar2 | | Y | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name | Type | Collation | Null | Default | Constraints | Comments | | transitionId | int(11) | | N | | FK -> TIKI_TRANSITION.transitionId | transition instance to which the event belongs | | eventId | int(11) | | N | | FK -> TIKI_TRANSITION_EVENTS.Id | event to be executed | | serial | int(4) | | N | 1 | | serial in which order the events take place | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name | Type | Collation | Null | Default | Constraints | Comments | | transitionId | int(11) | | N | | FK -> TIKI_TRANSITION.transitionId | transition instance to which the event belongs | | eventId | int(11) | | N | | FK -> TIKI_TRANSITION_EVENTS.Id | event to be executed | | serial | int(4) | | N | 1 | | serial in which order the events take place | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
| 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) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Name of object: | TIKI_TRANSITION_EVENTS | -Collation | -Null | -Default | -Constraints | -Comments | | +Type of database object: | +TABLE | | | | | | | | | | | | | | +Order of fields | +Field name | +Type | +Default | +Constraints | +Comments | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| -Name | -Type | -Collation | -Null | -Default | -Constraints | -Comments | | -Id | -int(11) | | -N | | -PK | -from sequence | | -Name | -varchar2 | | -N | | -Unique | -unique name | | -Description | -varchar2 | | -Y | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| -Name | -Type | -Collation | -Null | -Default | -Constraints | -Comments | | -transitionId | -int(11) | | -N | | -FK -> TIKI_TRANSITION.transitionId | -transition instance to which the event belongs | | -eventId | -int(11) | | -N | | -FK -> TIKI_TRANSITION_EVENTS.Id | -event to be executed | | -serial | -int(4) | | -N | -1 | | -serial in which order the events take place | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| -Name | -Type | -Collation | -Null | -Default | -Constraints | -Comments | | -transitionId | -int(11) | | -N | | -FK -> TIKI_TRANSITION.transitionId | -transition instance to which the event belongs | | -eventId | -int(11) | | -N | | -FK -> TIKI_TRANSITION_EVENTS.Id | -event to be executed | | -serial | -int(4) | | -N | -1 | | -serial in which order the events take place | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|