🔍 Explore Table Structure

Let's see what's in your new Express Entry draws table

✅ Table Found!

Table Name: ImmiWatch

📊 Sample Data (First 3 Rows)

[
  {
    "whalesync_postgres_id": "9933520f-f761-45bd-9909-def9250b1240",
    "name": "OINP-FWS - 2025-06-03",
    "program": "OINP-FWS",
    "region": "ALL",
    "draw_date_most_recent": "2025-06-03",
    "score": 32,
    "scoring_system": "PNP",
    "filter_by_program": "OINP",
    "invitation": 411,
    "category": "REDI"
  },
  {
    "whalesync_postgres_id": "d99b5a2c-bb45-4e5b-8e6a-e508cfc2b598",
    "name": "OINP-FWS - 2025-09-03",
    "program": "OINP-FWS",
    "region": "ALL",
    "draw_date_most_recent": "2025-09-03",
    "score": 42,
    "scoring_system": "PNP",
    "filter_by_program": "OINP",
    "invitation": 1134,
    "category": "Other Priority Occupations"
  },
  {
    "whalesync_postgres_id": "d28d4f2d-73d6-45f5-8734-2d522441df4f",
    "name": "EE-Education - 2025-05-01",
    "program": "EE-Education",
    "region": "ALL",
    "draw_date_most_recent": "2025-05-01",
    "score": 479,
    "scoring_system": "CRS",
    "filter_by_program": "Express Entry",
    "invitation": 1000,
    "category": "Education"
  }
]

🔍 Column Analysis

whalesync_postgres_id

Type: string
Sample Value: 9933520f-f761-45bd-9909-def9250b1240

name

Type: string
Sample Value: OINP-FWS - 2025-06-03

program

Type: string
Sample Value: OINP-FWS

region

Type: string
Sample Value: ALL

draw_date_most_recent

Type: string
Sample Value: 2025-06-03

score

Type: number
Sample Value: 32

scoring_system

Type: string
Sample Value: PNP

filter_by_program

Type: string
Sample Value: OINP

invitation

Type: number
Sample Value: 411

🔧 Manual Table Check

If the automatic detection didn't work, please provide the exact table name:

Common places to find table name:
• Supabase Dashboard → Table Editor → Look for your table name
• Check if it's in a different schema (not 'public')
• The name might be slightly different than expected