DATABASE FP

 CREATE DATABASE Alfajr;

USE Alfajr;

CREATE TABLE users (

    user_id INT NOT NULL AUTO_INCREMENT,

    nama_lengkap VARCHAR(100),

    no_hp VARCHAR(100),

    email VARCHAR(100),

    password VARCHAR(100),

    alamat VARCHAR(100),

    PRIMARY KEY (user_id)

);

CREATE TABLE travel (

    travel_id INT NOT NULL AUTO_INCREMENT,

    car_name VARCHAR(100),

    type_car ENUM('sedan', 'SUV', 'minivan', 'coupe', 'wagon'), -- Contoh nilai ENUM untuk type_car

    PRIMARY KEY (travel_id)

);

CREATE TABLE review (

    review_id INT NOT NULL AUTO_INCREMENT,

    user_id INT,

    travel_id INT,

    rating ENUM('1', '2', '3', '4', '5'),

    review TEXT,

    PRIMARY KEY (review_id),

    FOREIGN KEY (user_id) REFERENCES users(user_id),

    FOREIGN KEY (travel_id) REFERENCES travel(travel_id)

);

CREATE TABLE reservation (

    reser_id INT NOT NULL AUTO_INCREMENT,

    user_id INT,

    reser_date DATE,

    start_time TIME,

    end_time TIME,

    duration_time TIME,

    booking_notes TEXT,

    total_price DECIMAL(10,2),

    status ENUM('pending', 'confirmed', 'completed', 'canceled'),

    PRIMARY KEY (reser_id),

    FOREIGN KEY (user_id) REFERENCES users(user_id)

);

CREATE TABLE payments (

    payments_id INT NOT NULL AUTO_INCREMENT,

    reservation_id INT,

    payment_method ENUM('transfer', 'cash'),

    amount DECIMAL(10,2),

    status ENUM('pending', 'paid', 'failed'),

    PRIMARY KEY (payments_id),

    FOREIGN KEY (reservation_id) REFERENCES reservation(reser_id)

);