TIKI_TRANSITIONS
TIKI_TRANSITIONS table
(testing if sheets are usable for DB table specification)
| 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) | |
| 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 | ||
