tmsmith13/EECS647Project — comment on commit 5a9aff2a2544797cd957691ed56ff7ff6fb1e7b6
File: sql/schema.sql line 100
By tmsmith13:

Well, considering that there are only so many combinations of features does
features need to fully participate in that relation? I know this differs
from our original design but I sort of think it makes more sense.

On Sat, Nov 12, 2011 at 12:47 PM, jslick <
reply@reply.github.com
> wrote:

> You would still have a deletion anomaly since the two tables reference
> other (if both FKs are set to RESTRICT). Since vehicles and features are
> 1:1 with full participation in both directions, we might as well PK using
> vehicle_id.
>
> ---
> Reply to this email directly or view it on GitHub:
>
> https://github.com/tmsmith13/EECS647Project/commit/5a9aff2a2544797cd957691ed56ff7ff6fb1e7b6#commitcomment-713257
>
>
>