Fullscreen
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:07:24
Revision: November 5th 2010 08:36:42
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)No
preserveint(1)
namevarchar(50)utf8_general_ci
typevarchar(20)utf8_general_ci
fromvarchar(255)utf8_general_ci
tovarchar(255)utf8_general_ci
guardstextutf8_general_ci
Name of object:TIKI_TRANSITION_EVENTS
Type of database object:TABLE
Order of fieldsField nameTypeDefaultConstraintsComments
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)No+PK
preserveint(1)
namevarchar(50)utf8_general_ci+NOT NULL
typevarchar(20)utf8_general_ci+FK+NOT NULL, constrainted to a typeId
fromvarchar(255)utf8_general_ci+No+FK -> TIKI_CATEGORIES.categId+should be INT, NOT NULL, FK
tovarchar(255)utf8_general_ci+No+FK -> TIKI_CATEGORIES.categId+should 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)
NameType+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
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