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 06:15:53

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

Name	Type	Collation	NULL	Default	Constraints	Comment
transitionId	int(11)		No		PK
preserve	int(1)
name	varchar(50)	utf8_general_ci			-Unique?	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