Dive Application Schema

DROP DATABASE diving_log_book;
CREATE DATABASE diving_log_book;
USE diving_log_book;
CREATE TABLE dive (
    id MEDIUMINT NOT NULL AUTO_INCREMENT,
    dive_date DATE,
    dive_number MEDIUMINT,
    place VARCHAR(255),
    buddy VARCHAR(255),
    start_code VARCHAR(1),
    surfacing_code VARCHAR(1),
    time_down TIMESTAMP,
    time_up TIMESTAMP,
    total_time MEDIUMINT,
    max_depth DECIMAL(3,2),
    visibility VARCHAR(50),
    water_speed VARCHAR(50),
    weather_conditions VARCHAR(255),
    equipment_details VARCHAR(255),
    verified_by VARCHAR(255),
    entry ENUM('Shore', 'RIB', 'Hard boat'),
    entry_details VARCHAR(255),
    dive_details TEXT,
    air_in TINYINT,
    air_out TINYINT,
    weight TINYINT,
    PRIMARY KEY (id)
);

INSERT INTO dive 
    (dive_date, dive_number, place, buddy, start_code, surfacing_code, time_down, time_up, total_time, max_depth, visibility, water_speed, weather_conditions, equipment_details, verified_by, entry, entry_details, dive_details, air_in, air_out, weight
) VALUES (
...
)