Removing tgr_id from tour_guide_review table
Closed this issue · 1 comments
kucukaslan commented
If a tour guide can leave a single comment to a tour section we should use (tg_id , ts_id) as primary key.
Even more, we should also use have t_id in this relation and have it a part of primary key: (t_id, tg_id , ts_id)
kucukaslan commented
done.
Current schema
(t_id, ts_id, tg_id ,comment )
Old schema was:
(tgr_id, ts_id, tg_id ,comment )