汽车销售数据库

-- 创建汽车销售数据库
CREATE DATABASE car_sales;

-- 使用car_sales数据库
USE car_sales;

-- 创建汽车表
CREATE TABLE cars (
    id INT AUTO_INCREMENT PRIMARY KEY,
    brand VARCHAR(50),
    model VARCHAR(50),
    year INT,
    color VARCHAR(20)
);

-- 创建客户表
CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    phone VARCHAR(20),
    email VARCHAR(50)
);

-- 创建销售记录表
CREATE TABLE sales (
    id INT AUTO_INCREMENT PRIMARY KEY,
    car_id INT,
    customer_id INT,
    sale_date DATE,
    price DECIMAL(10, 2),
    FOREIGN KEY (car_id) REFERENCES cars(id),
    FOREIGN KEY (customer_id) REFERENCES customers(id)
);

-- 插入示例数据
INSERT INTO cars (brand, model, year, color) VALUES
('Toyota', 'Camry', 2020, 'Red'),
('Honda', 'Civic', 2021, 'Blue');

INSERT INTO customers (name, phone, email) VALUES
('John Doe', '1234567890', 'john.doe@example.com'),
('Jane Smith', '0987654321', 'jane.smith@example.com');

INSERT INTO sales (car_id, customer_id, sale_date, price) VALUES
(1, 1, '2023-01-15', 25000),
(2, 2, '2023-02-20', 22000);