Development Updates

1. On 08/09/2007 Frank writes:
To make the Annotation table also be able to support Protein annotations, I changed the Annotation table.

The table used to look like:

——————-+—————+——+—–+————+—————-+
Field	Type	Null	Key	Default	Extra
——————-+—————+——+—–+————+—————-+
AnnoID	bigint(20)		PRI	NULL	auto_increment
AnnoSourceType	varchar(50)			0
AnnoSourceID	bigint(20)			0
AnnoType	varchar(50)			0
Annotation	text
ChromID	bigint(20)			0
ChromStart	bigint(20)			0
ChromEnd	bigint(20)			0
ChromOrientation	enum('-','+')			+
AnnoBy	varchar(50)			0
AnnoDate	date			0000-00-00
TrashDate	date	YES		NULL
TrashedBy	bigint(20)	YES		NULL
——————-+—————+——+—–+————+—————-+

The changes are:
1) The Chrom in the fields of ChromID/ChromStart/ChromEnd/ChromOrientation has been changed to Source. This will make the Annotation template to be not only chromosome, but also Protein, Transcript, etc.

2) I found that the ChromID (now called SourceID after the above changes) is the same as the original AnnoSourceID, and thus is no longer needed. I removed this field from the table.

3) Currently the fields of AnnoSourceType and AnnoType are both of data type varchar. These could be changed to integer, with an appending "ID" at the end of the field names. We need to create two new tables called TemplateType and AnnoType. But since Jia has already loaded data into this table, we will worry about this later.

After the changes, this table looks like:

——————-+—————+——+—–+————+—————-+
Field	Type	Null	Key	Default	Extra
——————-+—————+——+—–+————+—————-+
AnnoID	bigint(20)		PRI	NULL	auto_increment
AnnoSourceType	varchar(50)			0
AnnoSourceID	bigint(20)			0
AnnoType	varchar(50)			0
Annotation	text
SourceStart	bigint(20)			0
SourceEnd	bigint(20)			0
SourceOrientation	enum('-','+')			+
AnnoBy	varchar(50)			0
AnnoDate	date			0000-00-00
TrashDate	date	YES		NULL
TrashedBy	bigint(20)	YES		NULL
——————-+—————+——+—–+————+—————-+

Link to this Page

CisTrack last edited on 22 December 2009 at 3:31 pm by win-cbc.lac.uic.edu