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

Annotation of /BioSimScratch/FnlChartTab.sql

Parent Directory Parent Directory | Revision Log 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