```json { "action": "final", "content": "Here is the complete list of columns in the `ai_job_dataset`, along with their data types and a description of what each represents based on the dataset's metadata:\n\n### Job Details\n* **`job_id`** (`VARCHAR`): A unique identifier for each job posting (e.g., AI00001).\n* **`job_title`** (`VARCHAR`): The specific role or title of the AI job (e.g., AI Architect, Robotics Engineer).\n* **`job_description_length`** (`BIGINT`): The length of the job description text (ranging from 500 to 2,499).\n* **`posting_date`** (`DATE`): The date the job was posted (covers Jan 2024 to Apr 2025).\n* **`application_deadline`** (`DATE`): The final date to apply for the position.\n\n### Compensation & Benefits\n* **`salary_usd`** (`BIGINT`): The salary offered for the role, standardized to US Dollars (ranging from ~$32k to ~$399k).\n* **`salary_currency`** (`VARCHAR`): The original currency the salary was posted in (e.g., USD, EUR).\n* **`benefits_score`** (`DOUBLE`): A numerical rating of the benefits package offered, scored from 5.0 to 10.0.\n\n### Requirements & Qualifications\n* **`experience_level`** (`VARCHAR`): The seniority level required for the role (e.g., EN for Entry-level, SE for Senior).\n* **`years_experience`** (`BIGINT`): The specific number of years of experience required (ranging from 0 to 19 years).\n* **`education_required`** (`VARCHAR`): The minimum educational degree expected (e.g., Associate, Bachelor's, Master's, PhD).\n* **`required_skills`** (`VARCHAR`): A comma-separated list of technical skills needed (e.g., AWS, Azure, TensorFlow, SQL).\n\n### Work Arrangements\n* **`employment_type`** (`VARCHAR`): The nature of the employment contract (e.g., FT for Full-Time, PT for Part-Time, CT for Contract).\n* **`remote_ratio`** (`BIGINT`): The percentage of the role that can be performed remotely (typically 0, 50, or 100).\n* **`employee_residence`** (`VARCHAR`): The country or region where the employee is expected or allowed to reside.\n\n### Company Information\n* **`company_name`** (`VARCHAR`): The name of the hiring organization (e.g., TechCorp Inc).\n* **`company_location`** (`VARCHAR`): The country or region where the company or office is located.\n* **`company_size`** (`VARCHAR`): The size category of the company (e.g., S for Small, M for Medium, L for Large).\n* **`industry`** (`VARCHAR`): The economic sector the company operates within (e.g., Automotive, Transportation).\n\n### System Metadata (Internal)\n* **`_ingestion_timestamp`** (`TIMESTAMP`): The exact date and time the record was loaded into the database.\n* **`_batch_id`** (`VARCHAR`): An internal identifier for the data load batch.\n* **`_source_file`** (`VARCHAR`): The file path from which the data was extracted.\n* **`_source_system`** (`VARCHAR`): The system that provided the data (e.g., API)." } ```