```json { "action": "final", "content": "Based on the dataset metadata, both the `ittf_rankings` and `ittf_rankings_women` tables share the exact same schema. Here is the list of columns, their data types, and what each represents:\n\n### Player & Ranking Details\n* **`Rank`** (`BIGINT`): The player's current ranking position for the given period (e.g., 1 for the top-ranked player).\n* **`Previous`** (`DOUBLE`): The player's ranking position in the previous ranking period.\n* **`ID`** (`BIGINT`): A unique identifier assigned to each player by the ITTF.\n* **`Name`** (`VARCHAR`): The full name of the table tennis player.\n* **`Assoc`** (`VARCHAR`): The association or country code the player represents (e.g., CHN, GER, ZAM).\n* **`Gender`** (`VARCHAR`): The gender category for the ranking (e.g., 'M' for Men, 'W' for Women).\n* **`Points`** (`BIGINT`): The current total ranking points the player has accumulated.\n* **`Previous Points`** (`DOUBLE`): The total ranking points the player held in the previous ranking period.\n\n### Temporal Columns (When the ranking was published)\n* **`WeekNum`** (`BIGINT`): The week number of the year the ranking applies to (ranges from 0 to 49).\n* **`MonthNum`** (`BIGINT`): The month number of the year the ranking applies to (ranges from 0 to 12).\n* **`YearNum`** (`BIGINT`): The year the ranking was published (covers 2001 to 2020).\n\n### System / Metadata Columns\nThese columns are automatically generated by the data pipeline and track how the data was loaded:\n* **`_ingestion_timestamp`** (`TIMESTAMP`): The exact date and time the record was loaded into the database.\n* **`_batch_id`** (`VARCHAR`): The identifier for the specific data loading batch.\n* **`_source_file`** (`VARCHAR`): The file path of the original CSV file the data was extracted from.\n* **`_source_system`** (`VARCHAR`): The system that provided the data (e.g., `api`)." } ```