Parent Directory
| 
Revision Log
Revision 1.1 - (view) (download)
| 1 : | efrank | 1.1 | |
| 2 : | -- ---------------------------------------------------------------------- | ||
| 3 : | drop table ProcList; | ||
| 4 : | create table ProcList ( | ||
| 5 : | -- | ||
| 6 : | -- Lists all the processes and assigns a unique ID. A process | ||
| 7 : | -- is something that happens, e.g., a reaction, set of reactions, | ||
| 8 : | -- set of rules, etc. | ||
| 9 : | -- ---------------------------------------------------------------------- | ||
| 10 : | -- | ||
| 11 : | ProcName varchar2(128) NOT NULL, | ||
| 12 : | /* Process name */ | ||
| 13 : | -- | ||
| 14 : | ProcId Number(10) NOT NULL, | ||
| 15 : | /* A unique number */ | ||
| 16 : | -- | ||
| 17 : | Model BFILE | ||
| 18 : | /* A file describing the process */ | ||
| 19 : | ); | ||
| 20 : | |||
| 21 : | -- ---------------------------------------------------------------------- | ||
| 22 : | drop table ProcStruct; | ||
| 23 : | create table ProcStruct ( | ||
| 24 : | -- | ||
| 25 : | -- Lists the immediate descendents of each Process. Thus, | ||
| 26 : | -- for any process name (Parent), list its parts (ChildProc) | ||
| 27 : | -- ---------------------------------------------------------------------- | ||
| 28 : | -- | ||
| 29 : | ParentProc varchar2(128) NOT NULL, | ||
| 30 : | /* Name of proc */ | ||
| 31 : | -- | ||
| 32 : | ParentProcId Number(10) NOT NULL, | ||
| 33 : | -- | ||
| 34 : | ChildProc varchar2(128) NOT NULL, | ||
| 35 : | -- | ||
| 36 : | ChildProcID Number(10) NOT NULL | ||
| 37 : | ); | ||
| 38 : | |||
| 39 : | -- ---------------------------------------------------------------------- | ||
| 40 : | drop table RecoCatalogEntry; | ||
| 41 : | create table RecoCatalogEntry ( | ||
| 42 : | -- | ||
| 43 : | -- Catalog of reconstructions. Another table holds a relation | ||
| 44 : | -- tying processes to reconstructions. | ||
| 45 : | -- ---------------------------------------------------------------------- | ||
| 46 : | -- | ||
| 47 : | RecoName varchar2(128) NOT NULL, | ||
| 48 : | -- | ||
| 49 : | Curator varchar2(128), | ||
| 50 : | -- | ||
| 51 : | RecoId Number(10) NOT NULL | ||
| 52 : | ); | ||
| 53 : | |||
| 54 : | -- ---------------------------------------------------------------------- | ||
| 55 : | drop table ProcessInReco; | ||
| 56 : | create table ProcessInReco ( | ||
| 57 : | -- | ||
| 58 : | -- Lists the processes that are in a reconstruction. I'm not sure | ||
| 59 : | -- yet if this should mean that you list some nodes and we infer | ||
| 60 : | -- that there descendents are in the reco transitively, or if we | ||
| 61 : | -- list the transitive closure in this table and ask the ProcStruct | ||
| 62 : | -- structural questions. For the moment, we take the policy that | ||
| 63 : | -- this table just locates the list of top nodes in the reconstruction | ||
| 64 : | -- and we then chase those through the ProcStruct table.-- | ||
| 65 : | -- ---------------------------------------------------------------------- | ||
| 66 : | -- | ||
| 67 : | RecoId Number(10) NOT NULL, | ||
| 68 : | -- | ||
| 69 : | ProcessId Number(10) NOT NULL | ||
| 70 : | ); | ||
| 71 : | |||
| 72 : | -- ---------------------------------------------------------------------- | ||
| 73 : | drop table ReactionsInProcess; | ||
| 74 : | create table ReactionsInProcess ( | ||
| 75 : | -- | ||
| 76 : | -- Lists the reactions associated with a process in a reconstruction. | ||
| 77 : | -- This is a weak relation between reaction, recoCatalogEntry, | ||
| 78 : | -- and Process | ||
| 79 : | -- ---------------------------------------------------------------------- | ||
| 80 : | -- | ||
| 81 : | RxId Number(10) NOT NULL, | ||
| 82 : | -- | ||
| 83 : | ProcessId Number(10) NOT NULL, | ||
| 84 : | -- | ||
| 85 : | RecoId Number(10) NOT NULL | ||
| 86 : | ); | ||
| 87 : |
| MCS Webmaster | ViewVC Help |
| Powered by ViewVC 1.0.3 |