CREATE TABLE IF NOT EXISTS t_education (
    education_id          INT AUTO_INCREMENT PRIMARY KEY,
    education_degree      VARCHAR(255) NOT NULL,
    education_school      VARCHAR(255) NOT NULL,
    education_location    VARCHAR(255) NULL,
    education_year_start  YEAR NOT NULL,
    education_year_end    YEAR NULL,
    education_description TEXT NULL,
    education_order       INT NOT NULL DEFAULT 0,
    education_created_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx01_education (education_year_start)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- DOWN

DROP TABLE IF EXISTS t_education;
