[Gusdev-gusdev] New table: DoTS.DevelopmentalStageLibrary

[<io...@pc...>]

Hey, GUS developers!

I'm writing to propose a new table, DoTS.DevelopmentalStageLibrary.

This is a mapping table to associate an EST library in
DoTS.Library with a developmental stage in
SRes.DevelopmentalStage. This is analogous to the way
DoTS.AnatomyLibrary associates a library with an
anatomy term in SRes.Anatomy.

Here's the proposed schema:

create table DoTS.DevelopmentalStageLibrary (
developmental_stage_library_id number(10) primary key,
developmental_stage_id references
SRes.DevelopmentalStage,
library_id references DoTS.Library,
modification_date date not null,
user_read number(1) not null,
user_write number(1) not null,
group_read number(1) not null,
group_write number(1) not null,
other_read number(1) not null,
other_write number(1) not null,
row_user_id number(12) not null,
row_group_id number(3) not null,
row_project_id number(4) not null,
row_alg_invocation_id number(12) not null
);

There is also a SourceForge tracker for this change; it's number 941027.

Please let me know what you think.

John