
CREATE TABLE IF NOT EXISTS kyc_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    guarantor_name VARCHAR(255),
    guarantor_mobile VARCHAR(15),
    force_id VARCHAR(50),
	client_code VARCHAR(50),
    name VARCHAR(255),
    pan_number VARCHAR(10),
    pan_password VARCHAR(50),
    father_name VARCHAR(255),
    dob DATE,
    aadhar_no VARCHAR(12),
    address TEXT,
    district VARCHAR(100),
    state VARCHAR(100),
    pincode VARCHAR(6),
    mobile_no VARCHAR(15),
    email VARCHAR(100),
    ifsc_code VARCHAR(11),
    account_number VARCHAR(20),
	refund_amount DECIMAL(10,2),
    efile_date VARCHAR(20),  -- Changed from DATE to VARCHAR(20)
    refund_date VARCHAR(20),          -- Changed from DATE to VARCHAR(20)
    assessment_year VARCHAR(10),
    paid_date VARCHAR(20),            -- Changed from DATE to VARCHAR(20)
    paid_amount DECIMAL(10,2),
    comment TEXT,
    date DATE
);
