[Bio] / BioSimScratch / FnlChartTab.sql Repository:
ViewVC logotype

Annotation of /BioSimScratch/FnlChartTab.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (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 : efrank 1.2 Model BFILE,
18 : efrank 1.1 /* A file describing the process */
19 : efrank 1.2 --
20 :     CONSTRAINT ProcList_PK PRIMARY KEY ( ProcId )
21 : efrank 1.1 );
22 :    
23 :     -- ----------------------------------------------------------------------
24 :     drop table ProcStruct;
25 :     create table ProcStruct (
26 :     --
27 :     -- Lists the immediate descendents of each Process. Thus,
28 :     -- for any process name (Parent), list its parts (ChildProc)
29 :     -- ----------------------------------------------------------------------
30 :     --
31 :     ParentProc varchar2(128) NOT NULL,
32 :     /* Name of proc */
33 :     --
34 :     ParentProcId Number(10) NOT NULL,
35 :     --
36 :     ChildProc varchar2(128) NOT NULL,
37 :     --
38 :     ChildProcID Number(10) NOT NULL
39 : efrank 1.2 --
40 : efrank 1.1 );
41 :    
42 :     -- ----------------------------------------------------------------------
43 :     drop table RecoCatalogEntry;
44 :     create table RecoCatalogEntry (
45 :     --
46 :     -- Catalog of reconstructions. Another table holds a relation
47 :     -- tying processes to reconstructions.
48 :     -- ----------------------------------------------------------------------
49 :     --
50 : efrank 1.2 RecoName varchar2(128) NOT NULL UNIQUE,
51 : efrank 1.1 --
52 :     Curator varchar2(128),
53 :     --
54 : efrank 1.2 RecoId Number(10) NOT NULL,
55 :     --
56 :     CONSTRAINT RecoCatalogEntry_PK PRIMARY KEY ( RecoId )
57 : efrank 1.1 );
58 :    
59 :     -- ----------------------------------------------------------------------
60 :     drop table ProcessInReco;
61 :     create table ProcessInReco (
62 :     --
63 :     -- Lists the processes that are in a reconstruction. I'm not sure
64 :     -- yet if this should mean that you list some nodes and we infer
65 :     -- that there descendents are in the reco transitively, or if we
66 :     -- list the transitive closure in this table and ask the ProcStruct
67 :     -- structural questions. For the moment, we take the policy that
68 :     -- this table just locates the list of top nodes in the reconstruction
69 :     -- and we then chase those through the ProcStruct table.--
70 :     -- ----------------------------------------------------------------------
71 :     --
72 :     RecoId Number(10) NOT NULL,
73 :     --
74 :     ProcessId Number(10) NOT NULL
75 :     );
76 :    
77 :     -- ----------------------------------------------------------------------
78 :     drop table ReactionsInProcess;
79 :     create table ReactionsInProcess (
80 :     --
81 :     -- Lists the reactions associated with a process in a reconstruction.
82 :     -- This is a weak relation between reaction, recoCatalogEntry,
83 :     -- and Process
84 :     -- ----------------------------------------------------------------------
85 :     --
86 :     RxId Number(10) NOT NULL,
87 :     --
88 :     ProcessId Number(10) NOT NULL,
89 :     --
90 :     RecoId Number(10) NOT NULL
91 :     );
92 :    

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3