Changes between Initial Version and Version 1 of Indexes

Timestamp:

09/11/25 04:13:51 (7 weeks ago)

Author:

141515

Comment:

--

Indexes

@@ +1 @@
+== Индекси
+
+=== За возила
+
+{{{
+-- Index for status filtering (most common query)
+CREATE INDEX IF NOT EXISTS idx_vehicle_status ON vehicle(status);
+
+-- Index for dealership vehicles lookup
+CREATE INDEX IF NOT EXISTS idx_vehicle_tax_nr ON vehicle(tax_nr);
+
+-- Composite index for dealership + status (for getMyVehicles)
+CREATE INDEX IF NOT EXISTS idx_vehicle_tax_nr_status ON vehicle(tax_nr, status);
+
+-- Index for vehicle make/model searches (for future search functionality)
+CREATE INDEX IF NOT EXISTS idx_vehicle_make ON vehicle(make);
+CREATE INDEX IF NOT EXISTS idx_vehicle_model ON vehicle(model);
+
+-- Composite index for make + model + year (common search pattern)
+CREATE INDEX IF NOT EXISTS idx_vehicle_make_model_year ON vehicle(make, model, p_year);
+
+-- Index for price range searches
+CREATE INDEX IF NOT EXISTS idx_vehicle_price ON vehicle(price);
+
+-- Index for year-based filtering
+CREATE INDEX IF NOT EXISTS idx_vehicle_year ON vehicle(p_year);
+}}}
+
+=== За договори
+{{{
+-- Index for VIN lookups (most common join)
+CREATE INDEX IF NOT EXISTS idx_agreement_vin ON agreement(vin);
+
+-- Index for client agreements lookup
+CREATE INDEX IF NOT EXISTS idx_agreement_embg ON agreement(embg);
+
+-- Index for dealership agreements lookup
+CREATE INDEX IF NOT EXISTS idx_agreement_tax_nr ON agreement(tax_nr);
+
+-- Index for date-based ordering (
+CREATE INDEX IF NOT EXISTS idx_agreement_datum ON agreement(datum);
+
+-- Composite index for dealership + date (for getDealershipAgreements)
+CREATE INDEX IF NOT EXISTS idx_agreement_tax_nr_datum ON agreement(tax_nr, datum DESC);
+
+-- Composite index for client + date (for getClientAgreements)
+CREATE INDEX IF NOT EXISTS idx_agreement_embg_datum ON agreement(embg, datum DESC);
+
+-- Index for status filtering
+CREATE INDEX IF NOT EXISTS idx_agreement_status ON agreement(status);
+
+-- Composite index for VIN + status (for duplicate prevention)
+CREATE INDEX IF NOT EXISTS idx_agreement_vin_status ON agreement(vin, status);
+}}}
+
+=== За уплати
+{{{
+-- Index for agreement lookups (most common join)
+CREATE INDEX IF NOT EXISTS idx_payment_a_id ON payment(a_id);
+
+-- Index for client payments lookup
+CREATE INDEX IF NOT EXISTS idx_payment_embg ON payment(embg);
+
+-- Index for date-based ordering
+CREATE INDEX IF NOT EXISTS idx_payment_created_at ON payment(created_at);
+
+-- Composite index for agreement + amount (for validation)
+CREATE INDEX IF NOT EXISTS idx_payment_a_id_amount ON payment(a_id, amount);
+}}}
+
+=== За клиенти
+{{{
+-- Index for email lookups (login)
+CREATE INDEX IF NOT EXISTS idx_client_email ON client(email);
+
+-- Composite index for email + password (login optimization)
+CREATE INDEX IF NOT EXISTS idx_client_email_pass ON client(email, pass);
+
+-- Index for name searches
+CREATE INDEX IF NOT EXISTS idx_client_name ON client(c_name);
+}}}
+
+=== За претставништва
+{{{
+-- Index for email lookups (login)
+CREATE INDEX IF NOT EXISTS idx_dealership_email ON dealership(email);
+
+-- Composite index for email + password (login optimization)
+CREATE INDEX IF NOT EXISTS idx_dealership_email_pass ON dealership(email, pass);
+
+-- Index for name searches
+CREATE INDEX IF NOT EXISTS idx_dealership_name ON dealership(d_name);
+}}}