CREATE TABLE iq_idb_info (
    id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    sprint_type INTEGER NOT NULL,
    project_id INTEGER NOT NULL,
    project_status_id INTEGER,
    name VARCHAR(512),
    description VARCHAR(255),
    start_date date DEFAULT NULL,
    end_date date DEFAULT NULL,
    total_quote DECIMAL(20, 10),
    total_quote_qa DECIMAL(20, 10),
    total_quoted_efforts DECIMAL(20, 10),
    total_quoted_efforts_qa DECIMAL(20, 10),
    jira_project_id_ext INTEGER,
    updated_at TIMESTAMP DEFAULT NULL,
    department_id INTEGER NOT NULL,
    customer_satisfaction VARCHAR(255),
    team_satisfaction VARCHAR(255),
    criticality VARCHAR(255),
    flc_weekly decimal(20, 2),
    flc_weekly_qa DECIMAL(20, 10),
    sow_end_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    jira_link VARCHAR(255),
    planned_ebitda DECIMAL(20, 10),
    planned_calendar_efforts INTEGER,
    billing_rate decimal(20, 10),
    billing_rate_qa DECIMAL(20, 10),
    main_project_id INTEGER DEFAULT NULL,
    total_target_efforts DECIMAL(20, 10),
    total_target_efforts_qa decimal(20, 2),
    total_extension_efforts decimal(20, 10),
    technical_lead JSON,
    project_owner JSON,
    project_manager JSON,
    delivery_manager JSON,
    project_type JSON,
    project_status JSON,
    is_created INTEGER,
    total_planned_cost DECIMAL(20, 10),
    planned_ebitda_percent DECIMAL(20, 10),
    total_target_cost DECIMAL(20, 10),
    target_ebitda DECIMAL(20, 10),
    target_ebitda_percent DECIMAL(20, 10),
    total_logged_efforts decimal(20, 10),
    total_actual_cost decimal(20, 10),
    current_revenue DECIMAL(20, 10),
    actual_ebitda decimal(20, 10),
    actual_ebitda_percent DECIMAL(20, 10),
    business_days INTEGER,
    current_business_days INTEGER,
    expected_min_billing decimal(20, 2),
    expected_max_billing decimal(20, 2),
    expected_current_max_billing DECIMAL(20, 10),
    expected_current_min_billing DECIMAL(20, 10),
    total_estimated_efforts DECIMAL(20, 10),
    effort_delay decimal(20, 10),
    effort_delay_percentage DECIMAL(20, 10),
    cr_consumed_efforts DECIMAL(20, 10),
    cr_consumed_efforts_percent DECIMAL(20, 10),
    billing_status_rate DECIMAL(20, 10),
    extension_logged_efforts decimal(20, 10),
    revenue_absorbed_by_over_logging DECIMAL(20, 10),
    revenue_absorbed_by_ext_tickets DECIMAL(20, 10),
    process_adherence DECIMAL(20, 10),
    active_sprint tinyint(1),
    process_adherence_percentage_data JSON,
    parent_id int,
    cr_planned_efforts DECIMAL(20, 10),
    total_logged_efforts_qa decimal(20, 10),
    deleted_at timestamp,
    created_at timestamp,
    FOREIGN KEY (project_status_id) references iq_project_status(project_status_id),
    FOREIGN KEY (project_id) REFERENCES iq_project(project_id)
);