>  UNIQUE (date, destination)

should of course be UNIQUE (start, destination)

>create index HikedTrails on HikeTrail (hike_id, trail_id);
>create index TrailsHiked on HikeTrail (trail_id, hike_id);

Both of these should be UNIQUE indexes and could be declared in the create 
table ...

and of course foreign Key enforcement should be enabled

The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

sqlite-users mailing list

Reply via email to