22 lines
930 B
SQL
22 lines
930 B
SQL
CREATE TABLE IF NOT EXISTS center_applications (
|
|
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
center_name VARCHAR(190) NOT NULL,
|
|
city VARCHAR(120) NOT NULL,
|
|
center_type VARCHAR(60) NOT NULL,
|
|
gender_scope VARCHAR(30) NOT NULL,
|
|
director_name VARCHAR(150) NOT NULL,
|
|
phone VARCHAR(60) NOT NULL,
|
|
email VARCHAR(190) NOT NULL,
|
|
expected_students INT UNSIGNED NOT NULL,
|
|
start_date DATE NOT NULL,
|
|
end_date DATE NOT NULL,
|
|
notes TEXT NULL,
|
|
status VARCHAR(30) NOT NULL DEFAULT 'submitted',
|
|
admin_notes TEXT NULL,
|
|
evaluation_score TINYINT UNSIGNED NULL,
|
|
submitted_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
INDEX idx_center_applications_status (status),
|
|
INDEX idx_center_applications_submitted_at (submitted_at)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|