CREATE TABLE device (
    Company VARCHAR(255),
    model VARCHAR(255),
    area VARCHAR(255)
);

CREATE TABLE store (
    name VARCHAR(255),
    site VARCHAR(255),
    times VARCHAR(255)
);

CREATE TABLE customer (
    name VARCHAR(255),
    Phone_number VARCHAR(255),
    gender VARCHAR(255)
);

CREATE TABLE employee (
    name VARCHAR(255),
    Job_title VARCHAR(255),
    id INT PRIMARY KEY
);
CREATE TABLE EQUIPMENT (
    EquipmentID VARCHAR(20) PRIMARY KEY,
    EquipmentName VARCHAR(100),
    EquipmentType VARCHAR(50),
    SerialNumber VARCHAR(50),
    Status VARCHAR(20)
);
SHOW TABLES;