-- Eğitim Tamamlanma ve ERP Kurulum Takip Tablosu
CREATE TABLE IF NOT EXISTS training_completion (
    id INT AUTO_INCREMENT PRIMARY KEY,
    company_id VARCHAR(50) NOT NULL COMMENT 'Firma ID',
    company_name VARCHAR(255) NOT NULL COMMENT 'Firma Adı',
    sales_source VARCHAR(100) DEFAULT NULL COMMENT 'Satış Kaynağı',
    support_representative VARCHAR(255) DEFAULT NULL COMMENT 'Destek Temsilcisi',
    training_completion_date DATE DEFAULT NULL COMMENT 'Eğitim Tamamlanma Tarihi',
    sales_type VARCHAR(100) DEFAULT NULL COMMENT 'Satış Tipi (Yeni Satış, Yenileme, vb.)',
    package_type VARCHAR(100) DEFAULT NULL COMMENT 'Paket Türü',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_company_id (company_id),
    INDEX idx_training_date (training_completion_date),
    INDEX idx_support_rep (support_representative),
    INDEX idx_package_type (package_type),
    INDEX idx_sales_type (sales_type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Eğitim Tamamlanma ve ERP Kurulum Takip';
