[Gdpdm-devel] Fwd: Error in "cdv_marker" def

[Ken Youens-C. <kc...@cs...>]

OK, I've discussed this with Terry, so I'm reasonably sure I'm not  
mistaken on this.  I think the "cdv_marker" is missing a foreign key  
constraint on the "div_ref_stock_id" field to the "div_stock" table.

ky

Begin forwarded message:

> From: Terry Casstevens <tm...@co...>
> Date: November 15, 2005 4:03:23 PM CST
> To: Ken Youens-Clark <kc...@cs...>
> Subject: Re: Error in "cdv_marker" def
>
> Yes, I think so.   Here's what the docs say.
>
> foreign key referencing stock associated with the
> reference sequence.
>
> Its related to the ref_seq field.
>
> Past that, you'd probably have to ask Ed or Peter
> why exactly it is there.
>
>
>
>
>
> On 11/15/05, Ken Youens-Clark <kc...@cs...> wrote:
>> OK, so I don't embarrass myself again by sending this to the GDPDM
>> list, let me approach just you on this.  Checkit:
>>
>> CREATE TABLE `cdv_marker` (
>>    `cdv_marker_id` int unsigned NOT NULL auto_increment,
>>    `cdv_map_feature_id` int unsigned default NULL,
>>    `name` varchar(255) default NULL,
>>    `position` int default NULL,
>>    `length` int default NULL,
>>    `ref_seq` text,
>>    `div_ref_stock_id` int unsigned default NULL,
>>    `marker_aid` varchar(255) default NULL,
>>    PRIMARY KEY  (`cdv_marker_id`),
>>    KEY `cdv_map_feature_id` (`cdv_map_feature_id`),
>>    KEY `marker_aid` (`marker_aid`),
>>    CONSTRAINT `cdv_marker_ibfk_1` FOREIGN KEY (`cdv_map_feature_id`)
>> REFERENCES `cdv_map_feature` (`cdv_map_feature_id`)
>> ) ENGINE=InnoDB;
>>
>> Should there be a FK from "div_ref_stock_id" to the "div_stock"  
>> table?
>>
>> ky
>>
>