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 | Unique? | NOT NULL, maybe UNIQUE? | ||
| type | varchar(20) | utf8_general_ci | NOT NULL, constrainted to a typeId | |||
| from | varchar(255) | utf8_general_ci | FK | should be INT, FK constraint to TIKI_CATEGORIES.categID, NOT NULL | ||
| to | varchar(255) | utf8_general_ci | FK | should be INT, FK constraint 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 |
| Name | ||||
