StateModelRev05f.ppt - RJL rev. 050918  9
StateModel Design – 8b
Schema Tree (Tables Depth-First)
TR Transition  /* links prior and next state; */
BB TA000017 TT000005 . .
TRid   NA c8 1 /* pkey of this State Transition*/
STid1  NA c8 1 /* Transition Source or 'From' State */
STid2  NA c8 1 /* Transition Destination or 'To' STate*/
EB TA000019
ET EventType /* Table of Event Types          */
BB TA000020 TT000006
ETid NA c8  1 /* pkey of Event Type */
SMid NA c8 1 /* State Model Receiving  this ET */
Label NA c32  0  /* State Transition label  */
Descrip  NA  t80  0  /* Event Type description*/
EB TA000023
EN EventEnable /* Associates event with transition     */
BB TA000024 TT000007
ENid NA c8 1 /* pkey of ENable relation (ET to TR)*/
ETid   NA c8 1 /* fkey to Event Type */
TRid NA c8 1 /* fkey of enabled State Transition*/
EB TA000026
AR ActionRoutine /* Table of State Acton Routine Functions */
BB TA000027 TT000008
/* attributes of class AR  go here */
EB TA000027+?
EB TT000008
(Schema reordered so each TT-row is followed by its TA children
TT-rows:  TTabb   TableName Description
TA-rows: Name  Alt   type  is_key       Description
BB_rows: BBId     firstPKey        constFKey
EB-rows: EBid      lastPkey(or row-count)