CREATE DATABASE draft;

use draft;

CREATE TABLE player (
    name            VARCHAR(30) NOT NULL,
    PRIMARY KEY (name)
);

CREATE TABLE draftSlot (
    round           INT NOT NULL,
    pick            INT NOT NULL,
    original        VARCHAR(3) NOT NULL,
    team            VARCHAR(3) NOT NULL,
    player          VARCHAR(30),
    PRIMARY KEY (round, pick)
);
