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

View of /BioSimScratch/FnlChartTab.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Fri Dec 20 20:16:23 2002 UTC (16 years, 11 months ago) by efrank
Branch: MAIN
Branch point for: local
Initial revision

-- ----------------------------------------------------------------------
drop   table ProcList;
create table ProcList (
--
-- Lists all the processes and assigns a unique ID.  A process
-- is something that happens, e.g., a reaction, set of reactions,
-- set of rules, etc.
-- ----------------------------------------------------------------------
--
	ProcName	varchar2(128)	NOT NULL,
	/* Process name    */
--
	ProcId		Number(10)	NOT NULL,
	/* A unique number */
--
	Model		BFILE
	/* A file describing the process */
);

-- ----------------------------------------------------------------------
drop   table ProcStruct;
create table ProcStruct (
--
-- Lists the immediate descendents of each Process.  Thus,
-- for any process name (Parent), list its parts (ChildProc)
-- ----------------------------------------------------------------------
--
	ParentProc	varchar2(128)	NOT NULL,
	/* Name of proc */
--
	ParentProcId	Number(10)	NOT NULL,
--
	ChildProc	varchar2(128)	NOT NULL,
--
	ChildProcID	Number(10)	NOT NULL
);

-- ----------------------------------------------------------------------
drop   table RecoCatalogEntry;
create table RecoCatalogEntry (
--
-- Catalog of reconstructions.  Another table holds a relation
-- tying processes to reconstructions.
-- ----------------------------------------------------------------------
--
	RecoName	varchar2(128)	NOT NULL,
--
	Curator		varchar2(128),
--
	RecoId		Number(10)	NOT NULL
);

-- ----------------------------------------------------------------------
drop   table ProcessInReco;
create table ProcessInReco (
--
-- Lists the processes that are in a reconstruction.  I'm not sure
-- yet if this should mean that you list some nodes and we infer
-- that there descendents are in the reco transitively, or if we
-- list the transitive closure in this table and ask the ProcStruct
-- structural questions.  For the moment, we take the policy that
-- this table just locates the list of top nodes in the reconstruction
-- and we then chase those through the ProcStruct table.--
-- ----------------------------------------------------------------------
--
	RecoId		Number(10)	NOT NULL,
--
	ProcessId	Number(10)	NOT NULL
);

-- ----------------------------------------------------------------------
drop   table ReactionsInProcess;
create table ReactionsInProcess (
--
-- Lists the reactions associated with a process in a reconstruction.
-- This is a weak relation between reaction, recoCatalogEntry,
-- and Process
-- ----------------------------------------------------------------------
--
	RxId		Number(10)	NOT NULL,
--
	ProcessId	Number(10)	NOT NULL,
--
	RecoId		Number(10)	NOT NULL
);


MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3