30 lines
1.6 KiB
SQL
30 lines
1.6 KiB
SQL
CREATE TABLE IF NOT EXISTS global_center_assessment_types (
|
|
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
title VARCHAR(190) NOT NULL,
|
|
category VARCHAR(80) NOT NULL DEFAULT 'أداء',
|
|
scale_type VARCHAR(40) NOT NULL DEFAULT 'percentage',
|
|
max_score DECIMAL(8,2) NOT NULL DEFAULT 100.00,
|
|
weight_percentage DECIMAL(5,2) NOT NULL DEFAULT 0.00,
|
|
is_active TINYINT(1) NOT NULL DEFAULT 1,
|
|
notes TEXT NULL,
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
INDEX idx_global_center_assessment_types_active (is_active),
|
|
INDEX idx_global_center_assessment_types_category (category)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
CREATE TABLE IF NOT EXISTS global_center_assessment_criteria (
|
|
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
assessment_type_id INT UNSIGNED NOT NULL,
|
|
title VARCHAR(190) NOT NULL,
|
|
max_score DECIMAL(8,2) NOT NULL DEFAULT 0.00,
|
|
sort_order INT UNSIGNED NOT NULL DEFAULT 1,
|
|
is_active TINYINT(1) NOT NULL DEFAULT 1,
|
|
notes TEXT NULL,
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
INDEX idx_global_center_assessment_criteria_assessment (assessment_type_id),
|
|
INDEX idx_global_center_assessment_criteria_active (assessment_type_id, is_active),
|
|
CONSTRAINT fk_global_center_assessment_criteria_assessment FOREIGN KEY (assessment_type_id) REFERENCES global_center_assessment_types(id) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|