Fist-Innovations/vehicle_rent_management
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
vehicle_rent_management/db/mv_rent_backup.sql
T
athul rd c4baa42b2c aaa
2026-07-28 08:48:22 +05:30

1620 lines
52 KiB
SQL
Raw Permalink Blame History

--
-- PostgreSQL database dump
--
\restrict rJe1Gy5GMPzawpaJZiQmUDxD6gCxnwjfhMGsGM8QvA0b3acVAPjT7ftg1eemfem
-- Dumped from database version 17.6
-- Dumped by pg_dump version 17.6
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
ALTER TABLE IF EXISTS ONLY public.vendor_settlements DROP CONSTRAINT IF EXISTS fkt7l1kk79o5lc6uod8jv910mnf;
ALTER TABLE IF EXISTS ONLY public.bookings DROP CONSTRAINT IF EXISTS fkstpgklh4a1lexve7b5qn8ebwp;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS fkrq6el5qawr0fnqofn8yjmqr0i;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS fkp3aufrqlptl7jn77avemkbpxr;
ALTER TABLE IF EXISTS ONLY public.drivers DROP CONSTRAINT IF EXISTS fko2ld66drmgv084wws15u6hqor;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS fkl4l7wq0lyhhq2pje8wro9gfh9;
ALTER TABLE IF EXISTS ONLY public.user_permissions DROP CONSTRAINT IF EXISTS fkkowxl8b2bngrxd1gafh13005u;
ALTER TABLE IF EXISTS ONLY public.vehicle_locations DROP CONSTRAINT IF EXISTS fkkgfol016f9hl7pt1nphs5yrsn;
ALTER TABLE IF EXISTS ONLY public.car_documents DROP CONSTRAINT IF EXISTS fkjr1xvrrs96ey2efq4jww071bh;
ALTER TABLE IF EXISTS ONLY public.bookings DROP CONSTRAINT IF EXISTS fkj1y19nc7wf0rdp24pyhomn7ck;
ALTER TABLE IF EXISTS ONLY public.bookings DROP CONSTRAINT IF EXISTS fkj0bxwbe92tfc6xwp7pdffo3pq;
ALTER TABLE IF EXISTS ONLY public.reviews DROP CONSTRAINT IF EXISTS fkieeb3p5v84i1xja7nbj1vkkeg;
ALTER TABLE IF EXISTS ONLY public.inspection_records DROP CONSTRAINT IF EXISTS fkhla1wpktqjsujkg3ihm79iaxh;
ALTER TABLE IF EXISTS ONLY public.bookings DROP CONSTRAINT IF EXISTS fkeyog2oic85xg7hsu2je2lx3s6;
ALTER TABLE IF EXISTS ONLY public.drivers DROP CONSTRAINT IF EXISTS fkdgi05p3479yd57btyrgmp4mle;
ALTER TABLE IF EXISTS ONLY public.reviews DROP CONSTRAINT IF EXISTS fkcgy7qjc1r99dp117y9en6lxye;
ALTER TABLE IF EXISTS ONLY public.payments DROP CONSTRAINT IF EXISTS fkc52o2b1jkxttngufqp3t7jr3h;
ALTER TABLE IF EXISTS ONLY public.invoices DROP CONSTRAINT IF EXISTS fkb9bhb7xre5v64qvjeholh3qj0;
ALTER TABLE IF EXISTS ONLY public.maintenance_records DROP CONSTRAINT IF EXISTS fka4dsfs77eje856jth3peepq16;
ALTER TABLE IF EXISTS ONLY public.car_photos DROP CONSTRAINT IF EXISTS fk75ncp53p4jb47tewrlvtwmh41;
ALTER TABLE IF EXISTS ONLY public.inspection_records DROP CONSTRAINT IF EXISTS fk753d5fiil3olhyi5t0sbpn8eh;
ALTER TABLE IF EXISTS ONLY public.cars DROP CONSTRAINT IF EXISTS fk6lq0lg9o4o6c4weriter6574f;
ALTER TABLE IF EXISTS ONLY public.car_feature_tags DROP CONSTRAINT IF EXISTS fk6js0s623ar2p4tjoa6ank1lm2;
ALTER TABLE IF EXISTS ONLY public.driver_documents DROP CONSTRAINT IF EXISTS fk4cqh5sfs29eeky0q37t2x78vq;
ALTER TABLE IF EXISTS ONLY public.reviews DROP CONSTRAINT IF EXISTS fk28an517hrxtt2bsg93uefugrm;
DROP INDEX IF EXISTS public.idx_audit_username;
DROP INDEX IF EXISTS public.idx_audit_created;
ALTER TABLE IF EXISTS ONLY public.vendors DROP CONSTRAINT IF EXISTS vendors_pkey;
ALTER TABLE IF EXISTS ONLY public.vendor_settlements DROP CONSTRAINT IF EXISTS vendor_settlements_pkey;
ALTER TABLE IF EXISTS ONLY public.vehicle_locations DROP CONSTRAINT IF EXISTS vehicle_locations_pkey;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS users_pkey;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS ukr43af9ap4edm43mmtq01oddj6;
ALTER TABLE IF EXISTS ONLY public.invoices DROP CONSTRAINT IF EXISTS ukqn380ix1ge287r0rd8th12bwi;
ALTER TABLE IF EXISTS ONLY public.invoices DROP CONSTRAINT IF EXISTS ukl1x55mfsay7co0r3m9ynvipd5;
ALTER TABLE IF EXISTS ONLY public.vehicle_locations DROP CONSTRAINT IF EXISTS ukke1m6iutu0pt6jorg1jr4ejx2;
ALTER TABLE IF EXISTS ONLY public.cars DROP CONSTRAINT IF EXISTS uki3ldfyekqw49cw6omv99rrfkx;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS uk6dotkott2kjsp8vw4d0m25fb7;
ALTER TABLE IF EXISTS ONLY public.drivers DROP CONSTRAINT IF EXISTS uk5v2gvq951rwadgpkg6wcr8ue9;
ALTER TABLE IF EXISTS ONLY public.categories DROP CONSTRAINT IF EXISTS uk17k21odm3kbnriiikewhatvlm;
ALTER TABLE IF EXISTS ONLY public.system_config DROP CONSTRAINT IF EXISTS system_config_pkey;
ALTER TABLE IF EXISTS ONLY public.reviews DROP CONSTRAINT IF EXISTS reviews_pkey;
ALTER TABLE IF EXISTS ONLY public.payments DROP CONSTRAINT IF EXISTS payments_pkey;
ALTER TABLE IF EXISTS ONLY public.organization DROP CONSTRAINT IF EXISTS organization_pkey;
ALTER TABLE IF EXISTS ONLY public.maintenance_records DROP CONSTRAINT IF EXISTS maintenance_records_pkey;
ALTER TABLE IF EXISTS ONLY public.invoices DROP CONSTRAINT IF EXISTS invoices_pkey;
ALTER TABLE IF EXISTS ONLY public.inspection_records DROP CONSTRAINT IF EXISTS inspection_records_pkey;
ALTER TABLE IF EXISTS ONLY public.drivers DROP CONSTRAINT IF EXISTS drivers_pkey;
ALTER TABLE IF EXISTS ONLY public.driver_documents DROP CONSTRAINT IF EXISTS driver_documents_pkey;
ALTER TABLE IF EXISTS ONLY public.categories DROP CONSTRAINT IF EXISTS categories_pkey;
ALTER TABLE IF EXISTS ONLY public.cars DROP CONSTRAINT IF EXISTS cars_pkey;
ALTER TABLE IF EXISTS ONLY public.car_photos DROP CONSTRAINT IF EXISTS car_photos_pkey;
ALTER TABLE IF EXISTS ONLY public.car_documents DROP CONSTRAINT IF EXISTS car_documents_pkey;
ALTER TABLE IF EXISTS ONLY public.bookings DROP CONSTRAINT IF EXISTS bookings_pkey;
ALTER TABLE IF EXISTS ONLY public.audit_logs DROP CONSTRAINT IF EXISTS audit_logs_pkey;
DROP TABLE IF EXISTS public.vendors;
DROP TABLE IF EXISTS public.vendor_settlements;
DROP TABLE IF EXISTS public.vehicle_locations;
DROP TABLE IF EXISTS public.users;
DROP TABLE IF EXISTS public.user_permissions;
DROP TABLE IF EXISTS public.system_config;
DROP TABLE IF EXISTS public.reviews;
DROP TABLE IF EXISTS public.payments;
DROP TABLE IF EXISTS public.organization;
DROP TABLE IF EXISTS public.maintenance_records;
DROP TABLE IF EXISTS public.invoices;
DROP TABLE IF EXISTS public.inspection_records;
DROP TABLE IF EXISTS public.drivers;
DROP TABLE IF EXISTS public.driver_documents;
DROP TABLE IF EXISTS public.categories;
DROP TABLE IF EXISTS public.cars;
DROP TABLE IF EXISTS public.car_photos;
DROP TABLE IF EXISTS public.car_feature_tags;
DROP TABLE IF EXISTS public.car_documents;
DROP TABLE IF EXISTS public.bookings;
DROP TABLE IF EXISTS public.audit_logs;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: audit_logs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.audit_logs (
id bigint NOT NULL,
action character varying(255),
created_at timestamp(6) without time zone,
detail character varying(500),
entity_id character varying(255),
entity_type character varying(255),
ip character varying(255),
role character varying(255),
username character varying(255)
);
--
-- Name: audit_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.audit_logs ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.audit_logs_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: bookings; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.bookings (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
drop_location character varying(255) NOT NULL,
pickup_date date NOT NULL,
pickup_location character varying(255) NOT NULL,
return_date date NOT NULL,
status character varying(255) NOT NULL,
total_amount numeric(38,2) NOT NULL,
car_id bigint NOT NULL,
user_id bigint NOT NULL,
driver_id bigint,
commission_amount numeric(38,2),
commission_percent numeric(38,2),
driver_charge numeric(38,2),
rental_unit character varying(255),
revenue_owner character varying(255),
tax_amount numeric(38,2),
tax_percent numeric(38,2),
vehicle_charge numeric(38,2),
vendor_id bigint,
with_driver boolean DEFAULT false NOT NULL,
quantity integer DEFAULT 1 NOT NULL,
CONSTRAINT bookings_rental_unit_check CHECK (((rental_unit)::text = ANY ((ARRAY['HOUR'::character varying, 'DAY'::character varying, 'MONTH'::character varying])::text[]))),
CONSTRAINT bookings_revenue_owner_check CHECK (((revenue_owner)::text = ANY ((ARRAY['OWNED'::character varying, 'VENDOR'::character varying])::text[]))),
CONSTRAINT bookings_status_check CHECK (((status)::text = ANY ((ARRAY['PENDING'::character varying, 'CONFIRMED'::character varying, 'CANCELLED'::character varying, 'COMPLETED'::character varying])::text[])))
);
--
-- Name: bookings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.bookings ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.bookings_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: car_documents; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.car_documents (
id bigint NOT NULL,
doc_type character varying(255) NOT NULL,
expiry_date date,
file_url character varying(255),
issued_date date,
car_id bigint NOT NULL,
CONSTRAINT car_documents_doc_type_check CHECK (((doc_type)::text = ANY ((ARRAY['RC'::character varying, 'INSURANCE'::character varying, 'PERMIT'::character varying, 'POLLUTION'::character varying, 'FITNESS'::character varying, 'OTHER'::character varying])::text[])))
);
--
-- Name: car_documents_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.car_documents ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.car_documents_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: car_feature_tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.car_feature_tags (
car_id bigint NOT NULL,
tag character varying(255)
);
--
-- Name: car_photos; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.car_photos (
id bigint NOT NULL,
sort_order integer NOT NULL,
url character varying(255) NOT NULL,
car_id bigint NOT NULL
);
--
-- Name: car_photos_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.car_photos ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.car_photos_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: cars; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.cars (
id bigint NOT NULL,
available boolean NOT NULL,
fuel_type character varying(255),
image_url character varying(255),
make character varying(255) NOT NULL,
model character varying(255) NOT NULL,
price_per_day numeric(38,2) NOT NULL,
registration_number character varying(255) NOT NULL,
seats integer NOT NULL,
transmission character varying(255),
type character varying(255) NOT NULL,
colour character varying(255),
hourly_rate numeric(38,2),
monthly_rate numeric(38,2),
ownership character varying(255) DEFAULT 'OWNED'::character varying,
status character varying(255) DEFAULT 'ACTIVE'::character varying,
units_total integer DEFAULT 1 NOT NULL,
year_of_registration integer,
commission_percent_override numeric(38,2),
vendor_id bigint,
CONSTRAINT cars_fuel_type_check CHECK (((fuel_type)::text = ANY ((ARRAY['PETROL'::character varying, 'DIESEL'::character varying, 'ELECTRIC'::character varying, 'HYBRID'::character varying, 'CNG'::character varying])::text[]))),
CONSTRAINT cars_ownership_check CHECK (((ownership)::text = ANY ((ARRAY['OWNED'::character varying, 'VENDOR'::character varying])::text[]))),
CONSTRAINT cars_seats_check CHECK (((seats <= 15) AND (seats >= 2))),
CONSTRAINT cars_status_check CHECK (((status)::text = ANY ((ARRAY['ACTIVE'::character varying, 'MAINTENANCE'::character varying, 'RETIRED'::character varying])::text[]))),
CONSTRAINT cars_transmission_check CHECK (((transmission)::text = ANY ((ARRAY['MANUAL'::character varying, 'AUTOMATIC'::character varying])::text[]))),
CONSTRAINT cars_type_check CHECK (((type)::text = ANY ((ARRAY['HATCHBACK'::character varying, 'SEDAN'::character varying, 'SUV'::character varying, 'MUV'::character varying, 'LUXURY'::character varying, 'BIKE'::character varying])::text[])))
);
--
-- Name: cars_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.cars ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.cars_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: categories; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.categories (
id bigint NOT NULL,
active boolean NOT NULL,
description character varying(255),
name character varying(255) NOT NULL,
type character varying(255) NOT NULL,
CONSTRAINT categories_type_check CHECK (((type)::text = ANY ((ARRAY['VEHICLE'::character varying, 'DRIVER'::character varying, 'CUSTOMER'::character varying])::text[])))
);
--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.categories ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.categories_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: driver_documents; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.driver_documents (
id bigint NOT NULL,
doc_type character varying(255) NOT NULL,
expiry_date date,
file_url character varying(255),
issued_date date,
driver_id bigint NOT NULL,
CONSTRAINT driver_documents_doc_type_check CHECK (((doc_type)::text = ANY ((ARRAY['LICENCE'::character varying, 'ID_PROOF'::character varying, 'POLICE_VERIFICATION'::character varying, 'MEDICAL'::character varying, 'OTHER'::character varying])::text[])))
);
--
-- Name: driver_documents_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.driver_documents ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.driver_documents_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: drivers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.drivers (
id bigint NOT NULL,
daily_charge numeric(38,2),
employment_type character varying(255) DEFAULT 'EMPLOYED'::character varying,
hourly_charge numeric(38,2),
licence_expiry date,
licence_number character varying(255) NOT NULL,
monthly_charge numeric(38,2),
name character varying(255) NOT NULL,
phone character varying(255),
photo_url character varying(255),
status character varying(255) DEFAULT 'AVAILABLE'::character varying,
years_experience integer DEFAULT 0 NOT NULL,
category_id bigint,
vendor_id bigint,
CONSTRAINT drivers_employment_type_check CHECK (((employment_type)::text = ANY ((ARRAY['EMPLOYED'::character varying, 'VENDOR'::character varying])::text[]))),
CONSTRAINT drivers_status_check CHECK (((status)::text = ANY ((ARRAY['AVAILABLE'::character varying, 'ON_TRIP'::character varying, 'OFF'::character varying])::text[]))),
CONSTRAINT drivers_years_experience_check CHECK ((years_experience >= 0))
);
--
-- Name: drivers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.drivers ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.drivers_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: inspection_records; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.inspection_records (
id bigint NOT NULL,
condition character varying(255) NOT NULL,
created_at timestamp(6) without time zone,
damage_notes character varying(1000),
fuel_level integer,
inspection_date date,
inspector character varying(255),
odometer integer,
photo_url character varying(255),
type character varying(255) NOT NULL,
booking_id bigint,
car_id bigint NOT NULL,
CONSTRAINT inspection_records_condition_check CHECK (((condition)::text = ANY ((ARRAY['GOOD'::character varying, 'MINOR_DAMAGE'::character varying, 'MAJOR_DAMAGE'::character varying])::text[]))),
CONSTRAINT inspection_records_type_check CHECK (((type)::text = ANY ((ARRAY['PRE_TRIP'::character varying, 'POST_TRIP'::character varying, 'PERIODIC'::character varying, 'INCIDENT'::character varying])::text[])))
);
--
-- Name: inspection_records_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.inspection_records ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.inspection_records_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: invoices; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.invoices (
id bigint NOT NULL,
invoice_number character varying(255) NOT NULL,
issued_at timestamp(6) without time zone NOT NULL,
subtotal numeric(38,2),
tax_amount numeric(38,2),
total numeric(38,2),
booking_id bigint NOT NULL
);
--
-- Name: invoices_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.invoices ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.invoices_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: maintenance_records; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.maintenance_records (
id bigint NOT NULL,
cost numeric(38,2),
created_at timestamp(6) without time zone,
garage character varying(255),
next_service_date date,
next_service_odometer integer,
notes character varying(1000),
odometer integer,
service_date date,
status character varying(255) NOT NULL,
type character varying(255) NOT NULL,
car_id bigint NOT NULL,
CONSTRAINT maintenance_records_status_check CHECK (((status)::text = ANY ((ARRAY['SCHEDULED'::character varying, 'IN_PROGRESS'::character varying, 'COMPLETED'::character varying])::text[]))),
CONSTRAINT maintenance_records_type_check CHECK (((type)::text = ANY ((ARRAY['SERVICE'::character varying, 'REPAIR'::character varying, 'TYRE'::character varying, 'BATTERY'::character varying, 'BODY_WORK'::character varying, 'CLEANING'::character varying, 'INSURANCE_RENEWAL'::character varying, 'OTHER'::character varying])::text[])))
);
--
-- Name: maintenance_records_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.maintenance_records ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.maintenance_records_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: organization; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.organization (
id bigint NOT NULL,
address character varying(255),
contact_email character varying(255),
currency_code character varying(255) NOT NULL,
gst_number character varying(255),
legal_name character varying(255),
logo_url character varying(255),
name character varying(255) NOT NULL,
phone character varying(255)
);
--
-- Name: organization_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.organization ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.organization_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: payments; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.payments (
id bigint NOT NULL,
amount numeric(38,2) NOT NULL,
created_at timestamp(6) without time zone,
method character varying(255) NOT NULL,
notes character varying(255),
paid_at date,
recorded_by character varying(255),
reference character varying(255),
booking_id bigint NOT NULL,
CONSTRAINT payments_method_check CHECK (((method)::text = ANY ((ARRAY['CASH'::character varying, 'UPI'::character varying, 'CARD'::character varying, 'BANK_TRANSFER'::character varying, 'ONLINE'::character varying, 'OTHER'::character varying])::text[])))
);
--
-- Name: payments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.payments ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.payments_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: reviews; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.reviews (
id bigint NOT NULL,
approved boolean NOT NULL,
comment character varying(1000),
created_at timestamp(6) without time zone,
rating integer NOT NULL,
booking_id bigint,
car_id bigint NOT NULL,
user_id bigint NOT NULL,
CONSTRAINT reviews_rating_check CHECK (((rating <= 5) AND (rating >= 1)))
);
--
-- Name: reviews_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.reviews ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.reviews_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: system_config; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.system_config (
id bigint NOT NULL,
currency_code character varying(255),
default_commission_percent numeric(38,2),
default_driver_daily_charge numeric(38,2),
default_tax_percent numeric(38,2),
invoice_prefix character varying(255),
settlement_cycle character varying(255),
CONSTRAINT system_config_settlement_cycle_check CHECK (((settlement_cycle)::text = ANY ((ARRAY['WEEKLY'::character varying, 'MONTHLY'::character varying])::text[])))
);
--
-- Name: system_config_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.system_config ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.system_config_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: user_permissions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.user_permissions (
user_id bigint NOT NULL,
permission character varying(255),
CONSTRAINT user_permissions_permission_check CHECK (((permission)::text = ANY ((ARRAY['MANAGE_FLEET'::character varying, 'MANAGE_DRIVERS'::character varying, 'MANAGE_VENDORS'::character varying, 'MANAGE_BOOKINGS'::character varying, 'MANAGE_BILLING'::character varying, 'VIEW_REPORTS'::character varying, 'MANAGE_CONFIG'::character varying, 'MANAGE_USERS'::character varying])::text[])))
);
--
-- Name: users; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.users (
id bigint NOT NULL,
email character varying(255) NOT NULL,
enabled boolean NOT NULL,
full_name character varying(255) NOT NULL,
license_number character varying(255),
password character varying(255) NOT NULL,
phone character varying(255),
role character varying(255) NOT NULL,
username character varying(50) NOT NULL,
vendor_id bigint,
customer_category_id bigint,
driver_id bigint
);
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.users ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.users_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: vehicle_locations; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.vehicle_locations (
id bigint NOT NULL,
heading double precision,
ignition_on boolean,
latitude double precision NOT NULL,
longitude double precision NOT NULL,
odometer integer,
speed_kph double precision,
updated_at timestamp(6) without time zone,
car_id bigint NOT NULL
);
--
-- Name: vehicle_locations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.vehicle_locations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.vehicle_locations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: vendor_settlements; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.vendor_settlements (
id bigint NOT NULL,
commission_amount numeric(38,2),
driver_charges numeric(38,2),
generated_at timestamp(6) without time zone NOT NULL,
gross_revenue numeric(38,2),
net_payable numeric(38,2),
period_end date,
period_start date,
status character varying(255) NOT NULL,
trip_count integer NOT NULL,
vendor_id bigint NOT NULL,
CONSTRAINT vendor_settlements_status_check CHECK (((status)::text = ANY ((ARRAY['DRAFT'::character varying, 'FINALISED'::character varying, 'PAID'::character varying])::text[])))
);
--
-- Name: vendor_settlements_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.vendor_settlements ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.vendor_settlements_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: vendors; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.vendors (
id bigint NOT NULL,
active boolean DEFAULT true NOT NULL,
address character varying(255),
commission_percent numeric(38,2),
contact_person character varying(255),
email character varying(255),
gst_number character varying(255),
name character varying(255) NOT NULL,
phone character varying(255),
settlement_details character varying(255)
);
--
-- Name: vendors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE public.vendors ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
SEQUENCE NAME public.vendors_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Data for Name: audit_logs; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.audit_logs (id, action, created_at, detail, entity_id, entity_type, ip, role, username) FROM stdin;
1 LOGIN_SUCCESS 2026-06-27 15:36:16.178347 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
2 UPDATE 2026-06-27 15:40:15.007566 save 2 Car 0:0:0:0:0:0:0:1 ADMIN admin
3 UPDATE 2026-06-27 15:40:15.011246 save 2 Maintenance 0:0:0:0:0:0:0:1 ADMIN admin
4 UPDATE 2026-06-27 15:46:48.419016 save 2 Car 0:0:0:0:0:0:0:1 ADMIN admin
5 UPDATE 2026-06-27 15:46:48.420726 save 2 Maintenance 0:0:0:0:0:0:0:1 ADMIN admin
6 LOGIN_SUCCESS 2026-06-27 15:46:50.000951 \N \N Auth 0:0:0:0:0:0:0:1 \N demo
7 CREATE 2026-06-27 15:46:50.06117 addReview 3 Review 0:0:0:0:0:0:0:1 CUSTOMER demo
8 LOGIN_SUCCESS 2026-06-27 16:08:20.61989 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
9 CREATE 2026-06-27 16:08:45.827638 createStaff 9 User 0:0:0:0:0:0:0:1 ADMIN admin
10 LOGIN_SUCCESS 2026-06-27 16:09:16.090374 \N \N Auth 0:0:0:0:0:0:0:1 \N staff1
11 CREATE 2026-06-27 16:09:16.212725 createBooking 7 Booking 0:0:0:0:0:0:0:1 ADMIN admin
12 LOGIN_SUCCESS 2026-06-27 16:12:06.959293 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
13 CREATE 2026-06-27 16:12:07.154034 createBooking 8 Booking 0:0:0:0:0:0:0:1 ADMIN admin
14 LOGIN_SUCCESS 2026-06-27 16:13:44.912973 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
15 LOGIN_SUCCESS 2026-06-27 16:22:03.724071 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
16 LOGIN_SUCCESS 2026-06-27 16:23:07.054389 \N \N Auth 0:0:0:0:0:0:0:1 \N staff1
17 LOGIN_SUCCESS 2026-06-27 16:23:26.98585 \N \N Auth 0:0:0:0:0:0:0:1 \N vendor1
18 LOGIN_SUCCESS 2026-06-27 16:36:56.585807 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
19 LOGIN_SUCCESS 2026-06-27 16:42:55.037816 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
20 LOGIN_SUCCESS 2026-07-02 17:03:37.847477 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
21 LOGIN_SUCCESS 2026-07-03 09:07:11.350728 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
22 LOGIN_SUCCESS 2026-07-03 09:14:36.728845 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
23 LOGIN_SUCCESS 2026-07-03 09:19:17.254401 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
24 UPDATE 2026-07-03 09:19:17.396479 updateStatus 3 Driver 0:0:0:0:0:0:0:1 ADMIN admin
25 UPDATE 2026-07-03 09:19:17.424299 updateStatus 3 Driver 0:0:0:0:0:0:0:1 ADMIN admin
26 LOGIN_SUCCESS 2026-07-03 09:35:49.328363 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
27 CREATE 2026-07-03 09:35:51.243882 createPortalUser 10 Driver 0:0:0:0:0:0:0:1 ADMIN admin
28 LOGIN_SUCCESS 2026-07-03 09:35:51.350599 \N \N Auth 0:0:0:0:0:0:0:1 \N driver1
29 UPDATE 2026-07-03 09:36:35.12477 updateStatus 3 Driver 0:0:0:0:0:0:0:1 DRIVER driver1
30 UPDATE 2026-07-03 09:36:35.337063 updateStatus 3 Driver 0:0:0:0:0:0:0:1 DRIVER driver1
31 LOGIN_SUCCESS 2026-07-03 10:32:31.915052 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
32 LOGIN_SUCCESS 2026-07-03 10:35:37.499045 \N \N Auth 0:0:0:0:0:0:0:1 \N admin
33 LOGIN_FAILURE 2026-07-03 10:38:26.242989 \N \N Auth 0:0:0:0:0:0:0:1 \N driver1
34 LOGIN_SUCCESS 2026-07-03 10:38:50.795708 \N \N Auth 0:0:0:0:0:0:0:1 \N driver1
35 LOGIN_SUCCESS 2026-07-03 10:39:26.956775 \N \N Auth 0:0:0:0:0:0:0:1 \N driver1
\.
--
-- Data for Name: bookings; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.bookings (id, created_at, drop_location, pickup_date, pickup_location, return_date, status, total_amount, car_id, user_id, driver_id, commission_amount, commission_percent, driver_charge, rental_unit, revenue_owner, tax_amount, tax_percent, vehicle_charge, vendor_id, with_driver, quantity) FROM stdin;
1 2026-06-26 16:07:35.833255 Kochi 2026-08-01 Kochi 2026-08-03 PENDING 4400.00 1 2 \N \N \N \N DAY \N \N \N \N \N f 1
2 2026-06-26 16:15:49.397764 Kochi 2026-09-01 Kochi 2026-09-04 PENDING 12600.00 2 2 \N 0.00 0.00 0.00 DAY OWNED 2100.00 20.00 10500.00 \N f 3
3 2026-06-26 16:15:49.579068 Kochi 2026-10-01 Kochi 2026-10-03 PENDING 10320.00 2 2 1 0.00 0.00 1600.00 DAY OWNED 1720.00 20.00 7000.00 \N t 2
4 2026-06-26 16:29:10.689776 Kochi 2026-11-05 Kochi 2026-11-08 COMPLETED 7920.00 1 2 \N 792.00 12.00 0.00 DAY VENDOR 1320.00 20.00 6600.00 1 f 3
5 2026-06-27 15:00:13.490606 Kochi 2026-07-10 Kochi 2026-07-13 PENDING 12600.00 2 7 \N 0.00 0.00 0.00 DAY OWNED 2100.00 20.00 10500.00 \N f 3
6 2026-06-27 15:00:13.663696 Wayanad 2026-08-01 Calicut 2026-08-04 PENDING 15480.00 2 8 1 0.00 0.00 2400.00 DAY OWNED 2580.00 20.00 10500.00 \N t 3
7 2026-06-27 16:09:16.200651 Kochi 2026-09-10 Kochi 2026-09-12 PENDING 7680.00 3 7 \N 0.00 0.00 0.00 DAY OWNED 1280.00 20.00 6400.00 \N f 2
8 2026-06-27 16:12:07.140903 Kochi 2026-10-10 Kochi 2026-10-12 PENDING 7680.00 3 7 \N 0.00 0.00 0.00 DAY OWNED 1280.00 20.00 6400.00 \N f 2
\.
--
-- Data for Name: car_documents; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.car_documents (id, doc_type, expiry_date, file_url, issued_date, car_id) FROM stdin;
1 INSURANCE 2026-07-06 /docs/ins.pdf \N 7
3 RC 2027-06-30 /uploads/7850af44-955e-4505-b0ab-9f85402bed1f.pdf \N 2
\.
--
-- Data for Name: car_feature_tags; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.car_feature_tags (car_id, tag) FROM stdin;
2 AC
2 Bluetooth
2 GPS
3 AC
3 Spacious
4 AC
4 Bluetooth
4 GPS
5 AC
6 AC
6 Bluetooth
6 GPS
7 AC
1 AC
1 Bluetooth
1 GPS
\.
--
-- Data for Name: car_photos; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.car_photos (id, sort_order, url, car_id) FROM stdin;
1 1 /images/bmwx3.png 7
3 0 /images/bmwx3.png 2
\.
--
-- Data for Name: cars; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.cars (id, available, fuel_type, image_url, make, model, price_per_day, registration_number, seats, transmission, type, colour, hourly_rate, monthly_rate, ownership, status, units_total, year_of_registration, commission_percent_override, vendor_id) FROM stdin;
3 t PETROL /images/hector.png MG Hector 3200.00 KL07AA1003 7 AUTOMATIC SUV \N \N \N OWNED ACTIVE 1 \N \N \N
4 t PETROL /images/bmwx3.png BMW X3 8500.00 KL07AA1004 5 AUTOMATIC LUXURY \N \N \N OWNED ACTIVE 1 \N \N \N
5 t PETROL /images/bike.png Royal Enfield Classic 350 800.00 KL07AA1005 2 MANUAL BIKE \N \N \N OWNED ACTIVE 1 \N \N \N
6 t PETROL /images/car.png Maruti Swift 1500.00 KL07AA1006 5 MANUAL HATCHBACK \N \N \N OWNED ACTIVE 1 \N \N \N
7 t \N \N Tesla Model 3 4500.00 KL-99-EV-0001 5 \N SEDAN \N \N \N OWNED MAINTENANCE 2 \N \N \N
1 t PETROL /images/virtus.png Volkswagen Virtus 2200.00 KL07AA1001 5 MANUAL SEDAN \N \N \N VENDOR ACTIVE 1 \N \N 1
2 t DIESEL /images/thar.png Mahindra Thar 3500.00 KL07AA1002 4 MANUAL SUV \N \N \N OWNED ACTIVE 1 \N \N \N
\.
--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.categories (id, active, description, name, type) FROM stdin;
1 t \N Hatchback VEHICLE
2 t \N Sedan VEHICLE
3 t \N SUV VEHICLE
4 t \N MUV VEHICLE
5 t \N Luxury VEHICLE
7 t \N Standard DRIVER
8 t \N Premium DRIVER
9 t \N Chauffeur DRIVER
10 t \N Individual CUSTOMER
11 t \N Company CUSTOMER
12 t \N Corporate CUSTOMER
13 t \N Convertible VEHICLE
6 t \N Bike VEHICLE
\.
--
-- Data for Name: driver_documents; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.driver_documents (id, doc_type, expiry_date, file_url, issued_date, driver_id) FROM stdin;
2 LICENCE 2028-01-01 /uploads/1d098844-4bf8-42dd-a1f9-81774ecc8cd1.pdf \N 1
4 LICENCE \N /uploads/547f9315-f272-4bc2-88af-f5e22797fc5e.pdf \N 3
\.
--
-- Data for Name: drivers; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.drivers (id, daily_charge, employment_type, hourly_charge, licence_expiry, licence_number, monthly_charge, name, phone, photo_url, status, years_experience, category_id, vendor_id) FROM stdin;
1 800.00 EMPLOYED \N 2028-06-26 KL07-2018-0012345 \N Rajesh Kumar +91 9847012345 \N AVAILABLE 6 7 \N
2 1200.00 VENDOR \N 2027-06-26 KL01-2015-0098765 \N Suresh Nair +91 9847098765 \N AVAILABLE 11 8 1
3 1500.00 EMPLOYED \N 2029-01-06 KL05-2020-0055555 \N Anil Joseph 9876562345 /uploads/d327034b-1819-464d-bcbe-4f96a34e0022.png AVAILABLE 4 7 \N
\.
--
-- Data for Name: inspection_records; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.inspection_records (id, condition, created_at, damage_notes, fuel_level, inspection_date, inspector, odometer, photo_url, type, booking_id, car_id) FROM stdin;
\.
--
-- Data for Name: invoices; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.invoices (id, invoice_number, issued_at, subtotal, tax_amount, total, booking_id) FROM stdin;
1 INV-00002 2026-06-26 16:15:49.416851 10500.00 2100.00 12600.00 2
2 INV-00003 2026-06-26 16:15:49.580328 8600.00 1720.00 10320.00 3
3 INV-00004 2026-06-26 16:29:10.705891 6600.00 1320.00 7920.00 4
4 INV-00005 2026-06-27 15:00:13.544753 10500.00 2100.00 12600.00 5
5 INV-00006 2026-06-27 15:00:13.664738 12900.00 2580.00 15480.00 6
6 INV-00007 2026-06-27 16:09:16.206627 6400.00 1280.00 7680.00 7
7 INV-00008 2026-06-27 16:12:07.14763 6400.00 1280.00 7680.00 8
\.
--
-- Data for Name: maintenance_records; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.maintenance_records (id, cost, created_at, garage, next_service_date, next_service_odometer, notes, odometer, service_date, status, type, car_id) FROM stdin;
1 4800.00 2026-06-27 15:32:22.220144 AutoCare Kochi 2026-10-27 46500 Engine oil, filter, brake pads 36500 2026-04-27 COMPLETED SERVICE 2
2 \N 2026-06-27 15:40:15.001632 \N \N \N \N \N 2026-06-27 COMPLETED REPAIR 2
\.
--
-- Data for Name: organization; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.organization (id, address, contact_email, currency_code, gst_number, legal_name, logo_url, name, phone) FROM stdin;
1 \N \N INR \N \N \N MV Rent \N
\.
--
-- Data for Name: payments; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.payments (id, amount, created_at, method, notes, paid_at, recorded_by, reference, booking_id) FROM stdin;
1 1000.00 2026-06-27 16:08:45.911914 UPI \N 2026-06-27 admin UPI-TEST-1 1
\.
--
-- Data for Name: reviews; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.reviews (id, approved, comment, created_at, rating, booking_id, car_id, user_id) FROM stdin;
1 t Spotless car and a smooth booking experience. Highly recommend! 2026-06-27 15:32:22.226167 5 \N 2 2
2 t Great value for money. Pickup was quick. 2026-06-27 15:32:22.229143 4 \N 2 2
3 t Tested via API - excellent! 2026-06-27 15:46:50.059737 5 \N 2 2
\.
--
-- Data for Name: system_config; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.system_config (id, currency_code, default_commission_percent, default_driver_daily_charge, default_tax_percent, invoice_prefix, settlement_cycle) FROM stdin;
1 INR 15.00 800.00 20.00 INV MONTHLY
\.
--
-- Data for Name: user_permissions; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.user_permissions (user_id, permission) FROM stdin;
1 MANAGE_USERS
1 VIEW_REPORTS
1 MANAGE_VENDORS
1 MANAGE_FLEET
1 MANAGE_BOOKINGS
1 MANAGE_BILLING
1 MANAGE_DRIVERS
1 MANAGE_CONFIG
9 MANAGE_FLEET
9 MANAGE_BOOKINGS
\.
--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.users (id, email, enabled, full_name, license_number, password, phone, role, username, vendor_id, customer_category_id, driver_id) FROM stdin;
5 vendor1@evmwheels.local t Kerala Cabs (Vendor) \N $2a$10$XrJ14wd5DejnjowxQRAd/.twJfFcHYFtGGPMqGXg8ld0WnNxbmdli \N VENDOR vendor1 1 \N \N
6 v1b@evmwheels.local t Kerala Cabs (Vendor) \N $2a$10$QUmUt4ben/OZAZkfYgyVN.S/yPuTsfxzxfpgiXnn6xWGaEQkdp.V2 \N VENDOR vendor1b 1 \N \N
2 demo@evmwheels.local t Demo Customer \N $2a$10$Tnkt18J40FaI/eccELPWE.wcer0pL2xoqLqBSp2N.B6mGSlQopS0O \N CUSTOMER demo \N 10 \N
7 acme2@test.com t Acme Corp \N $2a$10$dMv6PgInTGuAoawwRW7J9OFSXXETIT1hV2QhsxWvD4jcwOlv3Tlxa \N CUSTOMER acme2 \N 11 \N
1 admin@evmwheels.local t EVM Admin \N $2a$10$ToT.ACMiefUqo1Qzo1aqO.bpYXEAtUiZkahRccL9xMmDVR1Zt9lri \N ADMIN admin \N \N \N
8 counterguest@walkin.local t Counter Guest \N $2a$10$Y/I5EOYecBc6grAYargC2ejsXvnHX9qTVDbRJShy/m/7dJwmdB9Ly 9876500000 CUSTOMER counterguest \N \N \N
9 priya@evmwheels.local t Priya Staff \N $2a$10$1ZR6RVnMjgM6jXZK5xaAm.3s6sldh30vxj3THNsk9f6JSZBbvqc5W \N STAFF staff1 \N \N \N
10 driver1@mvrent.local t Anil Joseph \N $2a$10$WzxLal6ubyQUgixnKyA/7uVB19C4G4XD9GeVrv49jBNvjNTmdF6Re 9876562345 DRIVER driver1 \N \N 3
\.
--
-- Data for Name: vehicle_locations; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.vehicle_locations (id, heading, ignition_on, latitude, longitude, odometer, speed_kph, updated_at, car_id) FROM stdin;
2 90 t 8.5241 76.9366 43200 42 2026-06-27 15:31:22.21293 3
3 180 f 11.2588 75.7804 48400 0 2026-06-27 15:30:22.213693 4
4 270 t 10.5276 76.2144 53600 42 2026-06-27 15:29:22.214259 5
5 360 f 9.5916 76.5222 58800 0 2026-06-27 15:28:22.214754 6
1 120 t 10 76.3 41000 55.5 2026-06-27 15:40:14.968041 2
\.
--
-- Data for Name: vendor_settlements; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.vendor_settlements (id, commission_amount, driver_charges, generated_at, gross_revenue, net_payable, period_end, period_start, status, trip_count, vendor_id) FROM stdin;
1 792.00 0.00 2026-06-26 16:29:11.019085 6600.00 5808.00 2026-11-30 2026-11-01 DRAFT 1 1
\.
--
-- Data for Name: vendors; Type: TABLE DATA; Schema: public; Owner: -
--
COPY public.vendors (id, active, address, commission_percent, contact_person, email, gst_number, name, phone, settlement_details) FROM stdin;
1 t \N 12.00 Joby Thomas ops@keralacabs.local 32ABCDE1234F1Z5 Kerala Cabs +91 9847000000 A/C 00112233, IFSC SBIN0001234
\.
--
-- Name: audit_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.audit_logs_id_seq', 35, true);
--
-- Name: bookings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.bookings_id_seq', 8, true);
--
-- Name: car_documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.car_documents_id_seq', 3, true);
--
-- Name: car_photos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.car_photos_id_seq', 3, true);
--
-- Name: cars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.cars_id_seq', 8, true);
--
-- Name: categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.categories_id_seq', 14, true);
--
-- Name: driver_documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.driver_documents_id_seq', 4, true);
--
-- Name: drivers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.drivers_id_seq', 4, true);
--
-- Name: inspection_records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.inspection_records_id_seq', 1, false);
--
-- Name: invoices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.invoices_id_seq', 7, true);
--
-- Name: maintenance_records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.maintenance_records_id_seq', 2, true);
--
-- Name: organization_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.organization_id_seq', 1, true);
--
-- Name: payments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.payments_id_seq', 1, true);
--
-- Name: reviews_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.reviews_id_seq', 3, true);
--
-- Name: system_config_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.system_config_id_seq', 1, true);
--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.users_id_seq', 10, true);
--
-- Name: vehicle_locations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.vehicle_locations_id_seq', 5, true);
--
-- Name: vendor_settlements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.vendor_settlements_id_seq', 1, true);
--
-- Name: vendors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--
SELECT pg_catalog.setval('public.vendors_id_seq', 2, true);
--
-- Name: audit_logs audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.audit_logs
ADD CONSTRAINT audit_logs_pkey PRIMARY KEY (id);
--
-- Name: bookings bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookings
ADD CONSTRAINT bookings_pkey PRIMARY KEY (id);
--
-- Name: car_documents car_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.car_documents
ADD CONSTRAINT car_documents_pkey PRIMARY KEY (id);
--
-- Name: car_photos car_photos_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.car_photos
ADD CONSTRAINT car_photos_pkey PRIMARY KEY (id);
--
-- Name: cars cars_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.cars
ADD CONSTRAINT cars_pkey PRIMARY KEY (id);
--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.categories
ADD CONSTRAINT categories_pkey PRIMARY KEY (id);
--
-- Name: driver_documents driver_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.driver_documents
ADD CONSTRAINT driver_documents_pkey PRIMARY KEY (id);
--
-- Name: drivers drivers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.drivers
ADD CONSTRAINT drivers_pkey PRIMARY KEY (id);
--
-- Name: inspection_records inspection_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.inspection_records
ADD CONSTRAINT inspection_records_pkey PRIMARY KEY (id);
--
-- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invoices
ADD CONSTRAINT invoices_pkey PRIMARY KEY (id);
--
-- Name: maintenance_records maintenance_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.maintenance_records
ADD CONSTRAINT maintenance_records_pkey PRIMARY KEY (id);
--
-- Name: organization organization_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.organization
ADD CONSTRAINT organization_pkey PRIMARY KEY (id);
--
-- Name: payments payments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.payments
ADD CONSTRAINT payments_pkey PRIMARY KEY (id);
--
-- Name: reviews reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.reviews
ADD CONSTRAINT reviews_pkey PRIMARY KEY (id);
--
-- Name: system_config system_config_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.system_config
ADD CONSTRAINT system_config_pkey PRIMARY KEY (id);
--
-- Name: categories uk17k21odm3kbnriiikewhatvlm; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.categories
ADD CONSTRAINT uk17k21odm3kbnriiikewhatvlm UNIQUE (type, name);
--
-- Name: drivers uk5v2gvq951rwadgpkg6wcr8ue9; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.drivers
ADD CONSTRAINT uk5v2gvq951rwadgpkg6wcr8ue9 UNIQUE (licence_number);
--
-- Name: users uk6dotkott2kjsp8vw4d0m25fb7; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT uk6dotkott2kjsp8vw4d0m25fb7 UNIQUE (email);
--
-- Name: cars uki3ldfyekqw49cw6omv99rrfkx; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.cars
ADD CONSTRAINT uki3ldfyekqw49cw6omv99rrfkx UNIQUE (registration_number);
--
-- Name: vehicle_locations ukke1m6iutu0pt6jorg1jr4ejx2; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vehicle_locations
ADD CONSTRAINT ukke1m6iutu0pt6jorg1jr4ejx2 UNIQUE (car_id);
--
-- Name: invoices ukl1x55mfsay7co0r3m9ynvipd5; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invoices
ADD CONSTRAINT ukl1x55mfsay7co0r3m9ynvipd5 UNIQUE (invoice_number);
--
-- Name: invoices ukqn380ix1ge287r0rd8th12bwi; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invoices
ADD CONSTRAINT ukqn380ix1ge287r0rd8th12bwi UNIQUE (booking_id);
--
-- Name: users ukr43af9ap4edm43mmtq01oddj6; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT ukr43af9ap4edm43mmtq01oddj6 UNIQUE (username);
--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- Name: vehicle_locations vehicle_locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vehicle_locations
ADD CONSTRAINT vehicle_locations_pkey PRIMARY KEY (id);
--
-- Name: vendor_settlements vendor_settlements_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vendor_settlements
ADD CONSTRAINT vendor_settlements_pkey PRIMARY KEY (id);
--
-- Name: vendors vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vendors
ADD CONSTRAINT vendors_pkey PRIMARY KEY (id);
--
-- Name: idx_audit_created; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_audit_created ON public.audit_logs USING btree (created_at);
--
-- Name: idx_audit_username; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_audit_username ON public.audit_logs USING btree (username);
--
-- Name: reviews fk28an517hrxtt2bsg93uefugrm; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.reviews
ADD CONSTRAINT fk28an517hrxtt2bsg93uefugrm FOREIGN KEY (booking_id) REFERENCES public.bookings(id);
--
-- Name: driver_documents fk4cqh5sfs29eeky0q37t2x78vq; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.driver_documents
ADD CONSTRAINT fk4cqh5sfs29eeky0q37t2x78vq FOREIGN KEY (driver_id) REFERENCES public.drivers(id);
--
-- Name: car_feature_tags fk6js0s623ar2p4tjoa6ank1lm2; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.car_feature_tags
ADD CONSTRAINT fk6js0s623ar2p4tjoa6ank1lm2 FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: cars fk6lq0lg9o4o6c4weriter6574f; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.cars
ADD CONSTRAINT fk6lq0lg9o4o6c4weriter6574f FOREIGN KEY (vendor_id) REFERENCES public.vendors(id);
--
-- Name: inspection_records fk753d5fiil3olhyi5t0sbpn8eh; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.inspection_records
ADD CONSTRAINT fk753d5fiil3olhyi5t0sbpn8eh FOREIGN KEY (booking_id) REFERENCES public.bookings(id);
--
-- Name: car_photos fk75ncp53p4jb47tewrlvtwmh41; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.car_photos
ADD CONSTRAINT fk75ncp53p4jb47tewrlvtwmh41 FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: maintenance_records fka4dsfs77eje856jth3peepq16; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.maintenance_records
ADD CONSTRAINT fka4dsfs77eje856jth3peepq16 FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: invoices fkb9bhb7xre5v64qvjeholh3qj0; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.invoices
ADD CONSTRAINT fkb9bhb7xre5v64qvjeholh3qj0 FOREIGN KEY (booking_id) REFERENCES public.bookings(id);
--
-- Name: payments fkc52o2b1jkxttngufqp3t7jr3h; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.payments
ADD CONSTRAINT fkc52o2b1jkxttngufqp3t7jr3h FOREIGN KEY (booking_id) REFERENCES public.bookings(id);
--
-- Name: reviews fkcgy7qjc1r99dp117y9en6lxye; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.reviews
ADD CONSTRAINT fkcgy7qjc1r99dp117y9en6lxye FOREIGN KEY (user_id) REFERENCES public.users(id);
--
-- Name: drivers fkdgi05p3479yd57btyrgmp4mle; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.drivers
ADD CONSTRAINT fkdgi05p3479yd57btyrgmp4mle FOREIGN KEY (category_id) REFERENCES public.categories(id);
--
-- Name: bookings fkeyog2oic85xg7hsu2je2lx3s6; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookings
ADD CONSTRAINT fkeyog2oic85xg7hsu2je2lx3s6 FOREIGN KEY (user_id) REFERENCES public.users(id);
--
-- Name: inspection_records fkhla1wpktqjsujkg3ihm79iaxh; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.inspection_records
ADD CONSTRAINT fkhla1wpktqjsujkg3ihm79iaxh FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: reviews fkieeb3p5v84i1xja7nbj1vkkeg; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.reviews
ADD CONSTRAINT fkieeb3p5v84i1xja7nbj1vkkeg FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: bookings fkj0bxwbe92tfc6xwp7pdffo3pq; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookings
ADD CONSTRAINT fkj0bxwbe92tfc6xwp7pdffo3pq FOREIGN KEY (driver_id) REFERENCES public.drivers(id);
--
-- Name: bookings fkj1y19nc7wf0rdp24pyhomn7ck; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookings
ADD CONSTRAINT fkj1y19nc7wf0rdp24pyhomn7ck FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: car_documents fkjr1xvrrs96ey2efq4jww071bh; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.car_documents
ADD CONSTRAINT fkjr1xvrrs96ey2efq4jww071bh FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: vehicle_locations fkkgfol016f9hl7pt1nphs5yrsn; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vehicle_locations
ADD CONSTRAINT fkkgfol016f9hl7pt1nphs5yrsn FOREIGN KEY (car_id) REFERENCES public.cars(id);
--
-- Name: user_permissions fkkowxl8b2bngrxd1gafh13005u; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.user_permissions
ADD CONSTRAINT fkkowxl8b2bngrxd1gafh13005u FOREIGN KEY (user_id) REFERENCES public.users(id);
--
-- Name: users fkl4l7wq0lyhhq2pje8wro9gfh9; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT fkl4l7wq0lyhhq2pje8wro9gfh9 FOREIGN KEY (customer_category_id) REFERENCES public.categories(id);
--
-- Name: drivers fko2ld66drmgv084wws15u6hqor; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.drivers
ADD CONSTRAINT fko2ld66drmgv084wws15u6hqor FOREIGN KEY (vendor_id) REFERENCES public.vendors(id);
--
-- Name: users fkp3aufrqlptl7jn77avemkbpxr; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT fkp3aufrqlptl7jn77avemkbpxr FOREIGN KEY (vendor_id) REFERENCES public.vendors(id);
--
-- Name: users fkrq6el5qawr0fnqofn8yjmqr0i; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT fkrq6el5qawr0fnqofn8yjmqr0i FOREIGN KEY (driver_id) REFERENCES public.drivers(id);
--
-- Name: bookings fkstpgklh4a1lexve7b5qn8ebwp; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.bookings
ADD CONSTRAINT fkstpgklh4a1lexve7b5qn8ebwp FOREIGN KEY (vendor_id) REFERENCES public.vendors(id);
--
-- Name: vendor_settlements fkt7l1kk79o5lc6uod8jv910mnf; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.vendor_settlements
ADD CONSTRAINT fkt7l1kk79o5lc6uod8jv910mnf FOREIGN KEY (vendor_id) REFERENCES public.vendors(id);
--
-- PostgreSQL database dump complete
--
\unrestrict rJe1Gy5GMPzawpaJZiQmUDxD6gCxnwjfhMGsGM8QvA0b3acVAPjT7ftg1eemfem
Reference in New Issue View Git Blame Copy Permalink