Loading...

Skip to main content

Spreadsheet History: TIKI_TRANSITIONS

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

View
Date Selection

View

«
»

«
»

Revision: November 3rd 2010 08:59:59

Revision: November 5th 2010 08:36:42

Name of object:	TIKI_TRANSITION_EVENTS
Type of database object:	TABLE

Order of fields	Field name	Type	Default	Constraints	Comments

+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
-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

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