Loading...
 
Skip to main content

Spreadsheet History: TIKI_TRANSITIONS

TIKI_TRANSITIONS table (testing if sheets are usable for DB table specification)
No Tabs

View

Revision: November 5th 2010 06:15:53
Revision: November 5th 2010 07:52:51
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)NoPK
preserveint(1)
namevarchar(50)utf8_general_ciUnique?NOT NULL, maybe UNIQUE?
typevarchar(20)utf8_general_ciNOT NULL, constrainted to a typeId
fromvarchar(255)utf8_general_ciFKshould be INT, FK constraint to TIKI_CATEGORIES.categID, NOT NULL
tovarchar(255)utf8_general_ciFKshould be INT, FK constraint to TIKI_CATEGORIES.categId, NOT NULL
guardstextutf8_general_ci
Name of object:TIKI_TRANSITION_EVENTS
Type of database object:TABLE
Order of fieldsField nameTypeDefaultConstraintsComments
Name
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)NoPK
preserveint(1)
namevarchar(50)utf8_general_ci-Unique?NOT NULL
typevarchar(20)utf8_general_ci+FKNOT NULL, constrainted to a typeId
fromvarchar(255)utf8_general_ci+NoFK -> TIKI_CATEGORIES.categIdshould be INT, NOT NULL, FK
tovarchar(255)utf8_general_ci+NoFK -> TIKI_CATEGORIES.categIdshould be INT, NOT NULL, FK
guardstextutf8_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
Type of database object:TABLE
Order of fieldsField nameTypeDefaultConstraintsComments
Name
View Clone
View Clone
Toggle Full Screen

Date Selection

Edit Date User Actions
November 5th 2010 08:36:42 gezza View | Clone | Roll back
November 5th 2010 08:09:05 gezza View | Clone | Roll back
November 5th 2010 08:08:52 gezza View | Clone | Roll back
November 5th 2010 08:02:35 gezza View | Clone | Roll back
November 5th 2010 08:01:43 gezza View | Clone | Roll back
November 5th 2010 07:52:51 gezza View | Clone | Roll back
November 5th 2010 06:15:53 gezza View | Clone | Roll back
November 5th 2010 06:13:14 gezza View | Clone | Roll back
November 5th 2010 06:07:24 gezza View | Clone | Roll back
November 5th 2010 06:01:31 gezza View | Clone | Roll back
November 3rd 2010 08:59:59 gezza View | Clone | Roll back
November 3rd 2010 07:48:39 gezza View | Clone | Roll back
Show PHP error messages