masara_db.sql

--
-- PostgreSQL database dump
--

\restrict KYpNSJsQzohscfyHYqsRqdJpgCP45V4jmx5vcSmuTcy4pYv2hSAUl08uaqN0GuK

-- Dumped from database version 17.6 (Debian 17.6-2.pgdg13+1)
-- Dumped by pg_dump version 18.0

-- Started on 2025-10-31 05:16:09

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;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 217 (class 1259 OID 16444)
-- Name: airports; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.airports (
    airport_id integer NOT NULL,
    region character varying(20),
    airport_name character varying(100),
    airport_code character varying(10),
    city character varying(100),
    states character varying(100),
    country character varying(100),
    business_hour text
);


ALTER TABLE public.airports OWNER TO postgres;

--
-- TOC entry 218 (class 1259 OID 16449)
-- Name: airport_airport_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.airport_airport_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.airport_airport_id_seq OWNER TO postgres;

--
-- TOC entry 3501 (class 0 OID 0)
-- Dependencies: 218
-- Name: airport_airport_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.airport_airport_id_seq OWNED BY public.airports.airport_id;


--
-- TOC entry 219 (class 1259 OID 16450)
-- Name: booking; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.booking (
    booking_id integer NOT NULL,
    user_id integer,
    pd_id integer,
    car_id integer,
    driver_id integer,
    payment_id integer,
    created_at timestamp without time zone DEFAULT now(),
    booking_status text
);


ALTER TABLE public.booking OWNER TO postgres;

--
-- TOC entry 220 (class 1259 OID 16456)
-- Name: booking_booking_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.booking_booking_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.booking_booking_id_seq OWNER TO postgres;

--
-- TOC entry 3502 (class 0 OID 0)
-- Dependencies: 220
-- Name: booking_booking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.booking_booking_id_seq OWNED BY public.booking.booking_id;


--
-- TOC entry 221 (class 1259 OID 16457)
-- Name: car_detail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.car_detail (
    car_id integer NOT NULL,
    car_brand character varying(100),
    name_model character varying(100),
    car_segment character varying(100),
    seats integer,
    baggage integer,
    door integer,
    gear text,
    energy text,
    price_per_day numeric(10,2),
    img_car text
);


ALTER TABLE public.car_detail OWNER TO postgres;

--
-- TOC entry 222 (class 1259 OID 16462)
-- Name: car_detail_car_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.car_detail_car_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.car_detail_car_id_seq OWNER TO postgres;

--
-- TOC entry 3503 (class 0 OID 0)
-- Dependencies: 222
-- Name: car_detail_car_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.car_detail_car_id_seq OWNED BY public.car_detail.car_id;


--
-- TOC entry 223 (class 1259 OID 16463)
-- Name: driver_detail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.driver_detail (
    driver_id integer NOT NULL,
    name character varying(100),
    surname character varying(100),
    age integer,
    email character varying(100),
    phone character varying(10),
    flight_number character varying(6),
    created_at timestamp with time zone DEFAULT now(),
    booking_id integer,
    license_number bigint
);


ALTER TABLE public.driver_detail OWNER TO postgres;

--
-- TOC entry 224 (class 1259 OID 16467)
-- Name: driver_detail_driver_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.driver_detail_driver_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.driver_detail_driver_id_seq OWNER TO postgres;

--
-- TOC entry 3504 (class 0 OID 0)
-- Dependencies: 224
-- Name: driver_detail_driver_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.driver_detail_driver_id_seq OWNED BY public.driver_detail.driver_id;


--
-- TOC entry 225 (class 1259 OID 16468)
-- Name: payment; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.payment (
    payment_id integer NOT NULL,
    payment_method character varying(100),
    total_price numeric(10,2),
    payment_status text,
    created_at timestamp without time zone,
    booking_id integer
);


ALTER TABLE public.payment OWNER TO postgres;

--
-- TOC entry 226 (class 1259 OID 16473)
-- Name: payment_payment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.payment_payment_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.payment_payment_id_seq OWNER TO postgres;

--
-- TOC entry 3505 (class 0 OID 0)
-- Dependencies: 226
-- Name: payment_payment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.payment_payment_id_seq OWNED BY public.payment.payment_id;


--
-- TOC entry 227 (class 1259 OID 16474)
-- Name: pd_location; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pd_location (
    pd_id integer NOT NULL,
    booking_id integer,
    airport_id integer,
    pickup_date timestamp without time zone,
    dropoff_date timestamp without time zone,
    total_day integer
);


ALTER TABLE public.pd_location OWNER TO postgres;

--
-- TOC entry 228 (class 1259 OID 16477)
-- Name: pd_location_pd_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pd_location_pd_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.pd_location_pd_id_seq OWNER TO postgres;

--
-- TOC entry 3506 (class 0 OID 0)
-- Dependencies: 228
-- Name: pd_location_pd_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pd_location_pd_id_seq OWNED BY public.pd_location.pd_id;


--
-- TOC entry 229 (class 1259 OID 16478)
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users (
    user_id integer NOT NULL,
    email character varying(100) NOT NULL,
    password text NOT NULL,
    status text,
    created_at timestamp without time zone DEFAULT now(),
    gender character varying(20),
    region character varying(20),
    img_path text,
    phone character varying(10),
    name character varying(100),
    surname character varying(100),
    display_name character varying(100)
);


ALTER TABLE public.users OWNER TO postgres;

--
-- TOC entry 230 (class 1259 OID 16484)
-- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.users_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.users_user_id_seq OWNER TO postgres;

--
-- TOC entry 3507 (class 0 OID 0)
-- Dependencies: 230
-- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_user_id_seq OWNED BY public.users.user_id;


--
-- TOC entry 3304 (class 2604 OID 16485)
-- Name: airports airport_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.airports ALTER COLUMN airport_id SET DEFAULT nextval('public.airport_airport_id_seq'::regclass);


--
-- TOC entry 3305 (class 2604 OID 16486)
-- Name: booking booking_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking ALTER COLUMN booking_id SET DEFAULT nextval('public.booking_booking_id_seq'::regclass);


--
-- TOC entry 3307 (class 2604 OID 16487)
-- Name: car_detail car_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.car_detail ALTER COLUMN car_id SET DEFAULT nextval('public.car_detail_car_id_seq'::regclass);


--
-- TOC entry 3308 (class 2604 OID 16488)
-- Name: driver_detail driver_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.driver_detail ALTER COLUMN driver_id SET DEFAULT nextval('public.driver_detail_driver_id_seq'::regclass);


--
-- TOC entry 3310 (class 2604 OID 16489)
-- Name: payment payment_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment ALTER COLUMN payment_id SET DEFAULT nextval('public.payment_payment_id_seq'::regclass);


--
-- TOC entry 3311 (class 2604 OID 16490)
-- Name: pd_location pd_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pd_location ALTER COLUMN pd_id SET DEFAULT nextval('public.pd_location_pd_id_seq'::regclass);


--
-- TOC entry 3312 (class 2604 OID 16491)
-- Name: users user_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users ALTER COLUMN user_id SET DEFAULT nextval('public.users_user_id_seq'::regclass);


--
-- TOC entry 3482 (class 0 OID 16444)
-- Dependencies: 217
-- Data for Name: airports; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.airports (airport_id, region, airport_name, airport_code, city, states, country, business_hour) FROM stdin;
1	North America	Los Angeles International Airport	LAX	Los Angeles	California	United States	05:00 - 23:00
2	North America	San Francisco International Airport	SFO	San Francisco	California	United States	12:00 - 21:00
3	North America	Orlando International Airport	MCO	Orlando	Florida	United States	11:00 - 23:00
4	North America	Harry Reid International Airport	LAS	Las Vegas	Nevada	United States	12:00 - 19:00
5	North America	O’Hare International Airport	ORD	Chicago	Illinois	United States	06:00 - 21:00
6	Asia	Jeju International Airport	CJU	Jeju	Jeju Province	South Korea	05:00 - 21:00
7	Asia	Naha Airport	OKA	Okinawa	Okinawa Prefecture	Japan	12:00 - 21:00
8	Asia	Narita International Airport	NRT	Tokyo		Japan	08:00 - 24:00
9	Asia	New Chitose Airport	CTS	Sapporo	Hokkaido	Japan	08:00 - 18:00
10	Asia	Phuket International Airport	HKT	Phuket	Phuket Province	Thailand	10:00 - 21:00
11	Europe	Heathrow Airport	LHR	London	Greater London	United Kingdom	11:00 - 18:00
12	Europe	Paris Charles de Gaulle Airport	CDG	Paris	Île-de-France	France	09:00 - 23:00
13	Europe	Barcelona Airport	BCN	Barcelona	Catalonia	Spain	08:00 - 21:00
14	Europe	Milan Malpensa Airport	MXP	Milan	Lombardy	Italy	08:00 - 24:00
15	Europe	Munich Airport	MUC	Munich	Bavaria	Germany	06:00 - 22:00
16	Oceania	Melbourne Airport	MEL	Melbourne	Victoria	Australia	12:00 - 23:00
17	Oceania	Auckland Airport	AKL	Auckland	Auckland Region	New Zealand	08:00 - 23:00
18	Oceania	Brisbane Airport	BNE	Brisbane	Queensland	Australia	05:00 - 22:00
19	Oceania	Hobart International Airport	HBA	Hobart	Tasmania	Australia	09:00 - 22:00
20	Oceania	Perth Airport	PER	Perth	Western Australia	Australia	07:00 - 22:00
\.


--
-- TOC entry 3484 (class 0 OID 16450)
-- Dependencies: 219
-- Data for Name: booking; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.booking (booking_id, user_id, pd_id, car_id, driver_id, payment_id, created_at, booking_status) FROM stdin;
13	10	13	1	13	13	2025-10-30 13:22:00.558318	success
14	10	14	1	14	14	2025-10-30 13:46:21.912816	awaiting payment
15	10	15	3	15	15	2025-10-30 13:54:29.170791	awaiting payment
16	10	16	3	16	16	2025-10-30 14:00:46.918069	awaiting payment
17	10	17	1	17	17	2025-10-30 14:01:29.861073	awaiting payment
18	10	18	1	18	18	2025-10-30 14:02:12.669342	awaiting payment
19	10	19	1	19	19	2025-10-30 14:09:05.672373	awaiting payment
21	10	21	1	21	21	2025-10-30 14:16:19.965181	awaiting payment
22	10	22	1	22	22	2025-10-30 14:18:17.883659	Completed
20	10	20	1	20	20	2025-10-30 14:14:13.228743	Completed
23	10	23	1	23	23	2025-10-30 14:25:39.918477	Completed
24	10	24	2	24	24	2025-10-30 15:02:05.428926	awaiting payment
25	10	25	1	25	25	2025-10-30 15:43:43.659318	Completed
26	10	26	1	26	26	2025-10-30 16:36:18.878206	upcoming
27	10	27	1	27	27	2025-10-30 16:38:41.675065	upcoming
28	10	28	1	28	28	2025-10-30 16:39:53.373025	upcoming
29	10	29	1	29	29	2025-10-30 17:50:59.277939	upcoming
30	10	30	2	30	30	2025-10-30 17:55:21.716504	upcoming
\.


--
-- TOC entry 3486 (class 0 OID 16457)
-- Dependencies: 221
-- Data for Name: car_detail; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.car_detail (car_id, car_brand, name_model, car_segment, seats, baggage, door, gear, energy, price_per_day, img_car) FROM stdin;
89	Tesla	Cybertruck	pickup	6	3	4	Automatic	Electric	2196.40	img_cars/89_Tesla_Cybertruck.jpg
104	Mazda	MX-5 (Miata)	coupe	2	1	2	Manual	Fuel (Gasoline)	1850.25	img_cars/104_Mazda_MX-5 (Miata).jpg
105	Mazda	MX-5 (Miata)	coupe	2	1	2	Automatic	Fuel (Gasoline)	1850.25	img_cars/105_Mazda_MX-5 (Miata).jpg
106	Audi	A5 Coupé	coupe	4	2	2	Automatic	Fuel (Gasoline)	2410.99	img_cars/106_Audi_A5 Coupé.jpg
107	Audi	A5 Coupé	coupe	4	2	2	Automatic	Hybrid	2410.99	img_cars/107_Audi_A5 Coupé.jpg
108	Nissan	Z (Fairlady Z)	coupe	2	1	2	Manual	Fuel (Gasoline)	2155.50	img_cars/108_Nissan_Z (Fairlady Z).jpg
109	Nissan	Z (Fairlady Z)	coupe	2	1	2	Automatic	Fuel (Gasoline)	2155.50	img_cars/109_Nissan_Z (Fairlady Z).jpg
110	Toyota	GR Supra	coupe	2	1	2	Automatic	Fuel (Gasoline)	2390.80	img_cars/110_Toyota_GR Supra.jpg
111	Toyota	GR Supra	coupe	2	1	2	Manual	Fuel (Gasoline)	2390.80	img_cars/111_Toyota_GR Supra.jpg
113	Ford	Mustang Coupé	coupe	4	2	2	Automatic	Fuel (Gasoline)	2275.40	img_cars/113_Ford_Mustang Coupé.jpg
114	Ford	Mustang Coupé	coupe	4	2	2	Manual	Fuel (Gasoline)	2275.40	img_cars/114_Ford_Mustang Coupé.jpg
115	Chevrolet	Corvette (Stingray)	coupe	2	2	2	Automatic	Fuel (Gasoline)	2480.10	img_cars/115_Chevrolet_Corvette (Stingray).jpg
116	Chevrolet	Corvette (E-Ray)	coupe	2	2	2	Automatic	Hybrid	2480.10	img_cars/116_Chevrolet_Corvette (E-Ray).jpg
117	BMW	4 Series Coupé	coupe	4	2	2	Automatic	Fuel (Gasoline)	2050.75	img_cars/117_BMW_4 Series Coupé.jpg
118	BMW	4 Series Coupé	coupe	4	2	2	Automatic	Fuel (Diesel)	2050.75	img_cars/118_BMW_4 Series Coupé.jpg
112	Volkswagen	Scirocco	coupe	4	2	2	Automatic	Fuel (Gasoline)	1620.35	img_cars/112_Volkswagen_Scirocco (ยกเลิก).jpg
3	Audi	A1	Small car	4	1	5	Automatic	Fuel (Gasoline)	1625.91	img_cars/3_Audi_A1.jpg
95	Volkswagen	Caravelle	van	7	3	4	Automatic	Fuel (Gasoline)	1872.38	img_cars/95_Volkswagen_Caravelle.jpg
21	Volkswagen	Golf	Medium & Large	5	2	5	Automatic	Fuel (Gasoline)	1435.38	img_cars/21_Volkswagen_Golf.jpg
5	Nissan	Almera	Small car	4	2	4	Automatic	Fuel (Gasoline)	1275.53	img_cars/5_Nissan_Almera.jpg
119	BMW	4 Series Coupé	coupe	4	2	2	Automatic	Hybrid	2050.75	img_cars/119_BMW_4 Series Coupé.jpg
90	Hyundai	Staria	van	11	4	5	Automatic	Fuel (Diesel)	1775.95	img_cars/90_Hyundai_Staria.jpg
91	Nissan	Urvan	van	13	1	4	Manual	Fuel (Diesel)	1753.05	img_cars/91_Nissan_Urvan.jpg
1	Mazda	Mazda2 Sedan	Small car	4	2	4	Automatic	Fuel (Gasoline)	1204.11	img_cars/1_Mazda_Mazda2 Sedan.jpg
92	Nissan	Urvan	van	13	1	4	Automatic	Fuel (Diesel)	2063.21	img_cars/92_Nissan_Urvan.jpg
93	Toyota	Commuter	van	12	3	4	Automatic	Fuel (Diesel)	1161.72	img_cars/93_Toyota_Commuter.jpg
94	Toyota	Alphard	van	7	3	4	Automatic	Hybrid	1965.88	img_cars/94_Toyota_Alphard.jpg
17	Hyundai	Elantra	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	2234.56	img_cars/17_Hyundai_Elantra.jpg
18	Nissan	Sylphy	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	1948.40	img_cars/18_Nissan_Sylphy.jpg
23	Honda	Civic	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	2202.67	img_cars/23_Honda_Civic.jpg
24	Honda	Civic	Medium & Large	5	2	4	Automatic	Hybrid	1510.05	img_cars/24_Honda_Civic.jpg
25	Chevrolet	Cruze	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	1929.79	img_cars/25_Chevrolet_Cruze.jpg
16	Audi	A3 Sedan	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	1890.09	img_cars/16_Audi_A3 Sedan.jpg
19	Toyota	Corolla Altis	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	2413.59	img_cars/19_Toyota_Corolla Altis.jpg
39	Toyota	Camry	Premium	5	2	4	Automatic	Hybrid	1765.22	img_cars/39_Toyota_Camry.jpg
31	Mazda	Mazda6	Premium	5	2	4	Automatic	Fuel (Gasoline)	1430.96	img_cars/31_Mazda_Mazda6.jpg
32	Mazda	Mazda6	Premium	5	2	4	Automatic	Fuel (Diesel)	2122.70	img_cars/32_Mazda_Mazda6.jpg
33	Audi	A4	Premium	5	2	4	Automatic	Fuel (Gasoline)	1615.43	img_cars/33_Audi_A4.jpg
34	Audi	A5	Premium	5	2	4	Automatic	Fuel (Gasoline)	2352.54	img_cars/34_Audi_A5.jpg
35	Hyundai	Sonata	Premium	5	2	4	Automatic	Fuel (Gasoline)	1884.69	img_cars/35_Hyundai_Sonata.jpg
36	Hyundai	Sonata	Premium	5	2	4	Automatic	Hybrid	2472.02	img_cars/36_Hyundai_Sonata.jpg
37	Nissan	Teana	Premium	5	2	4	Automatic	Fuel (Gasoline)	2245.07	img_cars/37_Nissan_Teana.jpg
38	Toyota	Camry	Premium	5	2	4	Automatic	Fuel (Gasoline)	1392.39	img_cars/38_Toyota_Camry.jpg
30	Tesla	Model 3	Medium & Large	5	2	4	Automatic	Electric	2155.02	img_cars/30_Tesla_Model 3.jpg
2	Mazda	Mazda2 Sedan	Small car	4	2	4	Automatic	Fuel (Diesel)	2067.51	img_cars/2_Mazda_Mazda2 Sedan.jpg
4	Hyundai	Grand i10	Small car	4	1	5	Automatic	Fuel (Gasoline)	1153.48	img_cars/4_Hyundai_Grand i10.jpg
7	Volkswagen	Polo	Small car	4	1	5	Automatic	Fuel (Gasoline)	2297.47	img_cars/7_Volkswagen_Polo.jpg
6	Toyota	Yaris Ativ	Small car	4	2	4	Automatic	Fuel (Gasoline)	2362.09	img_cars/6_Toyota_Yaris Ativ.jpg
13	BMW	1 Series	Small car	4	1	5	Automatic	Fuel (Gasoline)	1229.97	img_cars/13_BMW_1 Series.jpg
8	Ford	Fiesta	Small car	4	1	5	Automatic	Fuel (Gasoline)	1587.98	img_cars/8_Ford_Fiesta.jpg
9	Honda	City	Small car	4	2	4	Automatic	Fuel (Gasoline)	2197.08	img_cars/9_Honda_City.jpg
10	Honda	City	Small car	4	2	4	Automatic	Hybrid	1106.65	img_cars/10_Honda_City.jpg
11	Chevrolet	Sonic	Small car	4	1	4	Automatic	Fuel (Gasoline)	1927.69	img_cars/11_Chevrolet_Sonic.jpg
12	Mitsubishi	Attrage	Small car	4	2	4	Automatic	Fuel (Gasoline)	1369.09	img_cars/12_Mitsubishi_Attrage.jpg
20	Toyota	Corolla Altis	Medium & Large	5	2	4	Automatic	Hybrid	2499.87	img_cars/20_Toyota_Corolla Altis.jpg
26	Mitsubishi	Lancer EX	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	1503.78	img_cars/26_Mitsubishi_Lancer EX.jpg
27	BMW	3 Series	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	2214.34	img_cars/27_BMW_3 Series.jpg
28	BMW	3 Series	Medium & Large	5	2	4	Automatic	Fuel (Diesel)	1263.65	img_cars/28_BMW_3 Series.jpg
29	BMW	3 Series	Medium & Large	5	2	4	Automatic	Hybrid	1976.94	img_cars/29_BMW_3 Series.jpg
14	Mazda	Mazda3	Medium & Large	5	2	4	Automatic	Fuel (Gasoline)	1367.51	img_cars/14_Mazda_Mazda3.jpg
61	Honda	CR-V	suv	5	2	5	Automatic	Hybrid	1725.73	img_cars/61_Honda_CR-V.jpg
103	Mitsubishi	l300	van	7	2	5	Automatic	Fuel (Gasoline)	1167.46	img_cars/103_Mitsubishi_l300.jpg
99	Ford	Transit	van	15	1	4	Manual	Fuel (Diesel)	1635.88	img_cars/99_Ford_Transit.jpg
57	Volkswagen	Tiguan	suv	5	2	5	Automatic	Fuel (Gasoline)	1154.95	img_cars/57_Volkswagen_Tiguan.jpg
96	Volkswagen	Caravelle	van	7	3	4	Automatic	Fuel (Diesel)	2330.18	img_cars/96_Volkswagen_Caravelle.jpg
40	Volkswagen	Passat	Premium	5	2	4	Automatic	Fuel (Gasoline)	2120.10	img_cars/40_Volkswagen_Passat.jpg
100	Ford	Transit	van	15	1	4	Automatic	Fuel (Diesel)	2032.06	img_cars/100_Ford_Transit.jpg
101	Honda	Freed	van	7	2	5	Automatic	Fuel (Gasoline)	2298.92	img_cars/101_Honda_Freed.jpg
102	Chevrolet	Express Van	van	12	2	3	Automatic	Fuel (Gasoline)	2264.38	img_cars/102_Chevrolet_Express Van.jpg
71	Tesla	Model Y	suv	5	2	5	Automatic	Electric	1281.99	img_cars/71_Tesla_Model Y.jpg
15	Mazda	Mazda3	Medium & Large	5	2	4	Automatic	Fuel (Diesel)	1745.16	img_cars/15_Mazda_Mazda3.jpg
22	Ford	Focus	Medium & Large	5	2	5	Automatic	Fuel (Gasoline)	1104.60	img_cars/22_Ford_Focus.jpg
44	BMW	5 Series	Premium	5	2	4	Automatic	Fuel (Gasoline)	2220.59	img_cars/44_BMW_5 Series.jpg
45	BMW	5 Series	Premium	5	2	4	Automatic	Fuel (Diesel)	1556.73	img_cars/45_BMW_5 Series.jpg
46	BMW	5 Series	Premium	5	2	4	Automatic	Hybrid	1428.23	img_cars/46_BMW_5 Series.jpg
54	Toyota	Corolla Cross	suv	5	2	5	Automatic	Hybrid	2185.07	img_cars/54_Toyota_Corolla Cross.jpg
56	Isuzu	MU-X	suv	7	3	5	Automatic	Fuel (Diesel)	2296.16	img_cars/56_Isuzu_MU-X.jpg
59	Honda	CR-V	suv	5	2	5	Automatic	Fuel (Gasoline)	2165.26	img_cars/59_Honda_CR-V.jpg
60	Honda	CR-V	suv	7	2	5	Automatic	Fuel (Gasoline)	1739.10	img_cars/60_Honda_CR-V.jpg
62	Honda	HR-V	suv	5	2	5	Automatic	Fuel (Gasoline)	2448.89	img_cars/62_Honda_HR-V.jpg
63	Honda	HR-V	suv	5	2	5	Automatic	Hybrid	2393.06	img_cars/63_Honda_HR-V.jpg
64	Chevrolet	Trailblazer	suv	5	2	5	Automatic	Fuel (Diesel)	1499.03	img_cars/64_Chevrolet_Trailblazer.jpg
66	Mitsubishi	Outlander PHEV	suv	5	2	5	Automatic	Hybrid	1288.45	img_cars/66_Mitsubishi_Outlander PHEV.jpg
67	Mitsubishi	Pajero Sport	suv	7	2	5	Automatic	Fuel (Diesel)	1153.91	img_cars/67_Mitsubishi_Pajero Sport.jpg
72	Mazda	BT-50	pickup	5	3	4	Manual	Fuel (Diesel)	1726.27	img_cars/72_Mazda_BT-50.jpg
73	Mazda	BT-50	pickup	5	3	4	Automatic	Fuel (Diesel)	1235.77	img_cars/73_Mazda_BT-50.jpg
74	Hyundai	Santa Cruz	pickup	5	2	4	Automatic	Fuel (Gasoline)	1192.06	img_cars/74_Hyundai_Santa Cruz.jpg
77	Toyota	Hilux Revo	pickup	5	3	4	Manual	Fuel (Diesel)	2071.07	img_cars/77_Toyota_Hilux Revo.jpg
78	Toyota	Hilux Revo	pickup	5	3	4	Automatic	Fuel (Diesel)	1404.08	img_cars/78_Toyota_Hilux Revo.jpg
79	Isuzu	D-Max	pickup	5	3	4	Manual	Fuel (Diesel)	1568.52	img_cars/79_Isuzu_D-Max.jpg
41	Ford	Mondeo	Premium	5	2	4	Automatic	Fuel (Gasoline)	1702.82	img_cars/41_Ford_Mondeo.jpg
42	Honda	Accord	Premium	5	2	4	Automatic	Hybrid	1769.10	img_cars/42_Honda_Accord.jpg
43	Chevrolet	Malibu	Premium	5	2	4	Automatic	Fuel (Gasoline)	1739.94	img_cars/43_Chevrolet_Malibu.jpg
49	Audi	Q3	suv	5	2	5	Automatic	Fuel (Gasoline)	1445.26	img_cars/49_Audi_Q3.jpg
50	Hyundai	Creta	suv	5	2	5	Automatic	Fuel (Gasoline)	2495.06	img_cars/50_Hyundai_Creta.jpg
51	Hyundai	Tucson	suv	5	2	5	Automatic	Fuel (Gasoline)	1229.03	img_cars/51_Hyundai_Tucson.jpg
55	Toyota	Fortuner	suv	7	3	5	Automatic	Fuel (Diesel)	1586.52	img_cars/55_Toyota_Fortuner.jpg
58	Ford	Everest	suv	7	3	5	Automatic	Fuel (Diesel)	2249.84	img_cars/58_Ford_Everest.jpg
65	Chevrolet	Captiva	suv	7	2	5	Automatic	Fuel (Gasoline)	2346.75	img_cars/65_Chevrolet_Captiva.jpg
68	BMW	X1	suv	5	2	5	Automatic	Fuel (Gasoline)	2403.18	img_cars/68_BMW_X1.jpg
69	BMW	X1	suv	5	2	5	Automatic	Fuel (Diesel)	2465.26	img_cars/69_BMW_X1.jpg
70	BMW	X1	suv	5	2	5	Automatic	Hybrid	2416.19	img_cars/70_BMW_X1.jpg
97	Volkswagen	Multivan	van	7	3	4	Automatic	Fuel (Gasoline)	1971.46	img_cars/97_Volkswagen_Multivan.jpg
98	Volkswagen	Multivan	van	7	3	4	Automatic	Fuel (Diesel)	1958.06	img_cars/98_Volkswagen_Multivan.jpg
47	Mazda	CX-5	suv	5	2	5	Automatic	Fuel (Gasoline)	2317.81	img_cars/47_Mazda_CX-5.jpg
48	Mazda	CX-5	suv	5	2	5	Automatic	Fuel (Diesel)	1309.07	img_cars/48_Mazda_CX-5.jpg
52	Nissan	Kicks e-Power	suv	5	2	5	Automatic	Hybrid	1348.77	img_cars/52_Nissan_Kicks e-Power.jpg
53	Toyota	Corolla Cross	suv	5	2	5	Automatic	Fuel (Gasoline)	1582.22	img_cars/53_Toyota_Corolla Cross.jpg
80	Isuzu	D-Max	pickup	5	3	4	Automatic	Fuel (Diesel)	2276.81	img_cars/80_Isuzu_D-Max.jpg
75	Nissan	Navara	pickup	5	3	4	Manual	Fuel (Diesel)	2098.90	img_cars/75_Nissan_Navara.jpg
76	Nissan	Navara	pickup	5	3	4	Automatic	Fuel (Diesel)	1590.02	img_cars/76_Nissan_Navara.jpg
82	Ford	Ranger	pickup	5	3	4	Manual	Fuel (Diesel)	1836.93	img_cars/82_Ford_Ranger.jpg
83	Ford	Ranger	pickup	5	3	4	Automatic	Fuel (Diesel)	1213.72	img_cars/83_Ford_Ranger.jpg
84	Honda	Ridgeline	pickup	5	2	4	Automatic	Fuel (Gasoline)	1216.32	img_cars/84_Honda_Ridgeline.jpg
85	Chevrolet	Colorado	pickup	5	3	4	Manual	Fuel (Diesel)	1139.92	img_cars/85_Chevrolet_Colorado.jpg
86	Chevrolet	Colorado	pickup	5	3	4	Automatic	Fuel (Diesel)	2317.56	img_cars/86_Chevrolet_Colorado.jpg
87	Mitsubishi	Triton	pickup	5	3	4	Manual	Fuel (Diesel)	1148.70	img_cars/87_Mitsubishi_Triton.jpg
88	Mitsubishi	Triton	pickup	5	3	4	Automatic	Fuel (Diesel)	2104.38	img_cars/88_Mitsubishi_Triton.jpg
81	Volkswagen	Amarok	pickup	5	3	4	Automatic	Fuel (Diesel)	1880.34	img_cars/81_Volkswagen_Amarok.jpg
\.


--
-- TOC entry 3488 (class 0 OID 16463)
-- Dependencies: 223
-- Data for Name: driver_detail; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.driver_detail (driver_id, name, surname, age, email, phone, flight_number, created_at, booking_id, license_number) FROM stdin;
13	tp	pkk	21	th@gmail.com	0877777777	yy77	2025-10-30 06:22:00.558318+00	13	\N
15	th	pk	21	th@gma.com	0877777777	th	2025-10-30 06:54:29.170791+00	15	\N
16	sdf	sd	21	df@gm.com	0877777777	ff	2025-10-30 07:00:46.918069+00	16	\N
17	sdf	sdf	21	ttht@gm.com	0877777777	ghgh	2025-10-30 07:01:29.861073+00	17	\N
18	sdf	sdf	21	fg@gm.com	0877777777	ghgh	2025-10-30 07:02:12.669342+00	18	\N
19	หกดห	หกด	21	f@gm.com	0877777777	ff	2025-10-30 07:09:05.672373+00	19	\N
20	sdf	sdf	45	t@gm.com	0877777777	hh	2025-10-30 07:14:13.228743+00	20	\N
21	sdfs	sdfd	21	fg@gm.com	0877777777	hbh	2025-10-30 07:16:19.965181+00	21	\N
22	sdddd	ddddddddddd	21	f@g.com	0877777777	ff	2025-10-30 07:18:17.883659+00	22	\N
23	ddd	sss	21	g@g.com	0877777777	hh	2025-10-30 07:25:39.918477+00	23	\N
24	sdfsd	sdfsdf	21	f@g.com	0877777777	hh	2025-10-30 08:02:05.428926+00	24	\N
25	asd	ffffdfdd	21	fg@g.com	0877777777	ff	2025-10-30 08:43:43.659318+00	25	\N
26	ฟหกฟห	ฟหกฟ	21	fdg@gm.com	0877777777	df	2025-10-30 09:36:18.878206+00	26	\N
27	sdf	sdf	54	g@fg.com	0877777777	ff	2025-10-30 09:38:41.675065+00	27	\N
28	dsfsd	ddddddddddd	21	d@f.com	0877777777	fgg	2025-10-30 09:39:53.373025+00	28	\N
29	f	dd	21	h@g.com	0877777777	dd	2025-10-30 10:50:59.277939+00	29	\N
30	หหกด	หกดหก	21	g@gh.com	0877777777	fg	2025-10-30 10:55:21.716504+00	30	\N
14	Gay	ไอเหี้ยนี้หวังตอกเจ้า	99	th@gma.com	0877777777	uk45	2025-10-30 06:46:21.912816+00	14	12345678901234
\.


--
-- TOC entry 3490 (class 0 OID 16468)
-- Dependencies: 225
-- Data for Name: payment; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.payment (payment_id, payment_method, total_price, payment_status, created_at, booking_id) FROM stdin;
2	\N	4500.00	awaiting payment	2025-10-30 10:47:39.994692	2
3	\N	4500.00	awaiting payment	2025-10-30 11:20:44.73756	3
4	\N	1204.11	awaiting payment	2025-10-30 12:44:36.779743	4
5	\N	1204.11	awaiting payment	2025-10-30 12:58:30.703501	5
6	\N	35770.02	awaiting payment	2025-10-30 12:59:41.571195	6
7	\N	1204.11	awaiting payment	2025-10-30 13:00:37.434092	7
8	\N	1204.11	awaiting payment	2025-10-30 13:02:22.183848	8
9	\N	7224.66	awaiting payment	2025-10-30 13:04:42.380192	9
10	\N	33715.08	awaiting payment	2025-10-30 13:14:00.464292	10
11	\N	12405.06	awaiting payment	2025-10-30 13:15:14.228236	11
12	\N	1204.11	awaiting payment	2025-10-30 13:17:19.544912	12
13	\N	1204.11	awaiting payment	2025-10-30 13:22:00.558318	13
14	\N	1204.11	awaiting payment	2025-10-30 13:46:21.912816	14
15	\N	1625.91	awaiting payment	2025-10-30 13:54:29.170791	15
16	\N	1625.91	awaiting payment	2025-10-30 14:00:46.918069	16
17	\N	1204.11	awaiting payment	2025-10-30 14:01:29.861073	17
18	\N	1204.11	awaiting payment	2025-10-30 14:02:12.669342	18
19	\N	1204.11	awaiting payment	2025-10-30 14:09:05.672373	19
20	\N	1204.11	awaiting payment	2025-10-30 14:14:13.228743	20
21	\N	1204.11	awaiting payment	2025-10-30 14:16:19.965181	21
22	\N	1204.11	awaiting payment	2025-10-30 14:18:17.883659	22
23	\N	1204.11	awaiting payment	2025-10-30 14:25:39.918477	23
24	\N	0.00	awaiting payment	2025-10-30 15:02:05.428926	24
25	\N	1204.11	awaiting payment	2025-10-30 15:43:43.659318	25
26	\N	1204.11	awaiting payment	2025-10-30 16:36:18.878206	26
27	\N	1204.11	awaiting payment	2025-10-30 16:38:41.675065	27
28	\N	9632.88	awaiting payment	2025-10-30 16:39:53.373025	28
29	\N	18061.65	awaiting payment	2025-10-30 17:50:59.277939	29
30	\N	2067.51	awaiting payment	2025-10-30 17:55:21.716504	30
\.


--
-- TOC entry 3492 (class 0 OID 16474)
-- Dependencies: 227
-- Data for Name: pd_location; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.pd_location (pd_id, booking_id, airport_id, pickup_date, dropoff_date, total_day) FROM stdin;
2	2	5	2025-12-01 00:00:00	2025-12-05 00:00:00	4
3	3	1	2025-11-10 00:00:00	2025-11-15 00:00:00	5
4	4	0	2025-10-29 17:00:00	2025-10-30 17:00:00	1
5	5	5	2025-10-29 17:00:00	2025-10-30 17:00:00	1
6	6	1	2025-10-07 17:00:00	2025-10-29 17:00:00	22
7	7	4	2025-10-29 17:00:00	2025-10-30 17:00:00	1
8	8	0	2025-10-29 17:00:00	2025-10-30 17:00:00	1
9	9	0	2025-10-29 17:00:00	2025-11-04 17:00:00	6
10	10	4	2025-10-02 00:00:00	2025-10-30 00:00:00	28
11	11	0	2025-10-30 00:00:00	2025-11-05 00:00:00	6
12	12	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
13	13	4	2025-10-30 00:00:00	2025-10-31 00:00:00	1
14	14	4	2025-10-30 00:00:00	2025-10-31 00:00:00	1
15	15	9	2025-10-30 00:00:00	2025-10-31 00:00:00	1
16	16	9	2025-10-30 00:00:00	2025-10-31 00:00:00	1
17	17	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
18	18	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
19	19	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
20	20	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
21	21	6	2025-10-30 00:00:00	2025-10-31 00:00:00	1
22	22	7	2025-10-30 00:00:00	2025-10-31 00:00:00	1
23	23	0	2025-10-30 00:00:00	2025-10-31 00:00:00	1
24	24	0	2025-10-30 00:00:00	2025-10-30 00:00:00	0
25	25	0	2025-10-30 00:00:00	2025-10-31 00:00:00	1
26	26	3	2025-10-30 00:00:00	2025-10-31 00:00:00	1
27	27	3	2025-10-30 00:00:00	2025-10-31 00:00:00	1
28	28	6	2025-10-30 00:00:00	2025-11-07 00:00:00	8
29	29	3	2025-10-23 00:00:00	2025-11-07 00:00:00	15
30	30	5	2025-10-30 00:00:00	2025-10-31 00:00:00	1
\.


--
-- TOC entry 3494 (class 0 OID 16478)
-- Dependencies: 229
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (user_id, email, password, status, created_at, gender, region, img_path, phone, name, surname, display_name) FROM stdin;
3	test@customer2.com	$2b$10$xoBuWRwvcHlWCGXPT/nWG.mKXC1BZzKs2yLUDYE1WBUUKm5ViXm0e	customer	2025-10-26 14:30:14.024432	Female	Thailand	img_mem/customer2.jpg	0912345678	Akali	Ionia	Akali Ionia
2	test@customer1.com	$2b$16$7EKKtiFkUpGFsIkgtVuPAumj8IBX9X/wiK1296Yd7Ly49zKOX2zWS	Femboy	2025-10-26 14:25:02.488064	Female	Japan	img_mem/customer1.jpg	0812345566	Goth	Girl	Goth Girl
5	test@customer4.com	$2b$10$pDXHB9TXLY3QAWUJR9np1u72hSoddoTxRY7tFyMCpir8IdxnY.QpK	customer	2025-10-28 19:20:54.389279	Female	Thailand	img_mem/customer4.jpg	0712345678	Chad	Man	Chad Man
7	test@customer6.com	$2b$10$XpStl40VnjmE8OjdYS3GHekoD6pHsRFNgoTUbSAxHv1GWhumJzqlS	customer	2025-10-29 15:33:21.708943	Female	Thailand	img_mem/default.jpg	0921345678	Annonymous	User	Annonymous User
8	test@customer7.com	$2b$10$la1omrtEiQGUqLAmvFA4nutPfr21nmloYe3pWYwNzsGYF.3oas0uG	customer	2025-10-29 15:35:15.899953	Female	Thailand	img_mem/default.jpg	0921345678	Annonymous	User	Annonymous User
6	test@customer5.com	$2b$16$m.Ff49kvt1SeAm3ZcQiBhuT/Bglm/9EfoT0epYWnvu9W7NFArTnxC	customer	2025-10-29 15:32:59.488693	Male	Thailand	img_mem/customer5.jpg	0812345566	Chad	Man	Chad Man
9	thaporn14@gmail.com	$2b$10$t7ahMwIypsKB27Ki0Pi1S.HGO/vAFaNuzlskWdWTKFQgBLF3oJZ92	customer	2025-10-30 10:45:19.11647	\N	\N	img_mem/default.jpg	\N	\N	\N	\N
10	thaporn760@gmail.com	$2b$10$SpX9Rf9y5q7QcAFBqdyd6uNBqwx6v2jqR0jaIi/nzkMv2rc5FOlPW	customer	2025-10-30 13:21:13.82374	\N	\N	img_mem/Gemini_Generated_Image_oijpqyoijpqyoijp.png	\N	\N	\N	\N
1	test@admin.com	$2b$16$dPEMjbYRvaQ63bmmMWozo.fK37b58b3DW8UzFOUXRZX30yzx43zlS	Admin	2025-10-25 16:45:17.51983	Male	Japan	img_mem/admin.jpg	0812345566	Speed	Homeless	Speed Homeless
4	test@customer3.com	$2b$10$q/y4.K/lwE5a6tuBvxWKN.UNcR2R20BQZkq9xFscRQmkOoPaZ3KO6	Admin	2025-10-26 14:31:14.840067	Female	Thailand	img_mem/customer3.jpg	0212345678	Egirl	Teedet	Egirl Teedet
\.


--
-- TOC entry 3508 (class 0 OID 0)
-- Dependencies: 218
-- Name: airport_airport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.airport_airport_id_seq', 20, true);


--
-- TOC entry 3509 (class 0 OID 0)
-- Dependencies: 220
-- Name: booking_booking_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.booking_booking_id_seq', 30, true);


--
-- TOC entry 3510 (class 0 OID 0)
-- Dependencies: 222
-- Name: car_detail_car_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.car_detail_car_id_seq', 120, true);


--
-- TOC entry 3511 (class 0 OID 0)
-- Dependencies: 224
-- Name: driver_detail_driver_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.driver_detail_driver_id_seq', 30, true);


--
-- TOC entry 3512 (class 0 OID 0)
-- Dependencies: 226
-- Name: payment_payment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.payment_payment_id_seq', 30, true);


--
-- TOC entry 3513 (class 0 OID 0)
-- Dependencies: 228
-- Name: pd_location_pd_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.pd_location_pd_id_seq', 30, true);


--
-- TOC entry 3514 (class 0 OID 0)
-- Dependencies: 230
-- Name: users_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_user_id_seq', 10, true);


--
-- TOC entry 3315 (class 2606 OID 16493)
-- Name: airports airport_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.airports
    ADD CONSTRAINT airport_pkey PRIMARY KEY (airport_id);


--
-- TOC entry 3317 (class 2606 OID 16495)
-- Name: booking booking_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT booking_pkey PRIMARY KEY (booking_id);


--
-- TOC entry 3319 (class 2606 OID 16497)
-- Name: car_detail car_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.car_detail
    ADD CONSTRAINT car_detail_pkey PRIMARY KEY (car_id);


--
-- TOC entry 3321 (class 2606 OID 16499)
-- Name: driver_detail driver_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.driver_detail
    ADD CONSTRAINT driver_detail_pkey PRIMARY KEY (driver_id);


--
-- TOC entry 3324 (class 2606 OID 16501)
-- Name: payment payment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment
    ADD CONSTRAINT payment_pkey PRIMARY KEY (payment_id);


--
-- TOC entry 3327 (class 2606 OID 16503)
-- Name: pd_location pd_location_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pd_location
    ADD CONSTRAINT pd_location_pkey PRIMARY KEY (pd_id);


--
-- TOC entry 3329 (class 2606 OID 16505)
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- TOC entry 3331 (class 2606 OID 16507)
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (user_id);


--
-- TOC entry 3322 (class 1259 OID 16508)
-- Name: fki_payment_booking_id_fkey; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_payment_booking_id_fkey ON public.payment USING btree (booking_id);


--
-- TOC entry 3325 (class 1259 OID 16509)
-- Name: fki_pd_location_booking_id_fkey; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fki_pd_location_booking_id_fkey ON public.pd_location USING btree (booking_id);


--
-- TOC entry 3332 (class 2606 OID 16510)
-- Name: booking fk_car; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT fk_car FOREIGN KEY (car_id) REFERENCES public.car_detail(car_id) ON DELETE CASCADE;


--
-- TOC entry 3333 (class 2606 OID 16515)
-- Name: booking fk_driver; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT fk_driver FOREIGN KEY (driver_id) REFERENCES public.driver_detail(driver_id) ON DELETE CASCADE;


--
-- TOC entry 3334 (class 2606 OID 16520)
-- Name: booking fk_payment; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT fk_payment FOREIGN KEY (payment_id) REFERENCES public.payment(payment_id) ON DELETE CASCADE;


--
-- TOC entry 3335 (class 2606 OID 16525)
-- Name: booking fk_pd; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT fk_pd FOREIGN KEY (pd_id) REFERENCES public.pd_location(pd_id) ON DELETE CASCADE;


--
-- TOC entry 3336 (class 2606 OID 16530)
-- Name: booking fk_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking
    ADD CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


-- Completed on 2025-10-31 05:16:12

--
-- PostgreSQL database dump complete
--

\unrestrict KYpNSJsQzohscfyHYqsRqdJpgCP45V4jmx5vcSmuTcy4pYv2hSAUl08uaqN0GuK