| 126 | | === 7) Нефункционални подобрувања (не ја менуваат 3NF) === |
| 127 | | |
| 128 | | {{{ |
| 129 | | -- UNIQUE клучеви: |
| 130 | | ALTER TABLE actors ADD CONSTRAINT uq_actors_code UNIQUE (actor_code); |
| 131 | | ALTER TABLE locations ADD CONSTRAINT uq_locations_feat UNIQUE (feature_id); |
| 132 | | |
| 133 | | -- Индекси за споеви/филтри: |
| 134 | | CREATE INDEX ix_event_details_event ON event_details (global_event_id); |
| 135 | | CREATE INDEX ix_event_details_actor ON event_details (actor_id); |
| 136 | | CREATE INDEX ix_event_details_loc ON event_details (location_id); |
| 137 | | |
| 138 | | CREATE INDEX ix_notifications_user ON notifications (user_id, notification_date); |
| 139 | | CREATE INDEX ix_notifications_event ON notifications (event_id); |
| 140 | | |
| 141 | | CREATE INDEX ix_predictions_event ON predictions (event_id); |
| 142 | | CREATE INDEX ix_predictions_actor ON predictions (actor_id); |
| 143 | | |
| 144 | | CREATE INDEX ix_analytics_event_actor ON event_analytics (event_id, actor_id, date); |
| 145 | | CREATE INDEX ix_conflict_pair_date ON conflict_risk (actor1_id, actor2_id, predicted_date); |
| 146 | | |
| 147 | | -- CHECK ограничувања: |
| 148 | | ALTER TABLE subscription ADD CONSTRAINT ck_sub_dates CHECK (end_date IS NULL OR end_date >= start_date); |
| 149 | | ALTER TABLE events ADD CONSTRAINT ck_year CHECK (year BETWEEN 1900 AND 2100); |
| 150 | | ALTER TABLE predictions ADD CONSTRAINT ck_conf_score CHECK (confidence_score BETWEEN 0 AND 100); |
| 151 | | ALTER TABLE conflict_risk ADD CONSTRAINT ck_risk_score CHECK (risk_score BETWEEN 0 AND 100); |
| 152 | | }}} |
| 153 | | |
| 154 | | === 8) Финален заклучок === |
| | 126 | === 7) Финален заклучок === |
