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 5th 2010 08:02:35

Revision: November 5th 2010 08:36:42

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

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

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