bigquery table's JSON schema definition

schema.json

[
  {
    "type": "INTEGER",
    "mode": "REQUIRED",
    "name": "event_id"
  },
  {
    "type": "STRING",
    "mode": "REQUIRED",
    "name": "event_name"
  },
  {
    "type": "STRING",
    "mode": "REPEATED",
    "name": "event_types"
  },
  {
    "type": "STRING",
    "mode": "REQUIRED",
    "name": "product_code"
  },
  {
    "type": "STRING",
    "mode": "REPEATED",
    "name": "product_sub_code"
  },
  {
    "fields": [
      {
        "fields": [
          {
            "type": "STRING",
            "mode": "REQUIRED",
            "name": "name"
          },
          {
            "type": "TIMESTAMP",
            "mode": "REQUIRED",
            "name": "timestamp"
          }
        ],
        "type": "RECORD",
        "mode": "NULLABLE",
        "name": "internal"
      },
      {
        "fields": [
          {
            "type": "STRING",
            "mode": "REQUIRED",
            "name": "name"
          },
          {
            "type": "TIMESTAMP",
            "mode": "REQUIRED",
            "name": "timestamp"
          }
        ],
        "type": "RECORD",
        "mode": "NULLABLE",
        "name": "external"
      }
    ],
    "type": "RECORD",
    "mode": "REQUIRED",
    "name": "source"
  },
  {
    "type": "TIMESTAMP",
    "mode": "REQUIRED",
    "name": "timestamp"
  },
  {
    "fields": [
      {
        "type": "STRING",
        "mode": "NULLABLE",
        "name": "device_id"
      },
      {
        "type": "STRING",
        "mode": "NULLABLE",
        "name": "cookie_id"
      },
      {
        "type": "STRING",
        "mode": "NULLABLE",
        "name": "profile_id"
      },
      {
        "type": "STRING",
        "mode": "REQUIRED",
        "name": "best_id"
      }
    ],
    "type": "RECORD",
    "mode": "REQUIRED",
    "name": "user_key"
  },
  {
    "type": "STRING",
    "mode": "REQUIRED",
    "name": "message_id"
  },
  {
    "type": "STRING",
    "mode": "REQUIRED",
    "name": "message_type"
  },
  {
    "type": "STRING",
    "mode": "NULLABLE",
    "name": "tracking_id"
  },
  {
    "type": "STRING",
    "mode": "NULLABLE",
    "name": "funnel_stage"
  },
  {
    "fields": [
      {
        "type": "FLOAT",
        "mode": "REQUIRED",
        "name": "latitude"
      },
      {
        "type": "FLOAT",
        "mode": "REQUIRED",
        "name": "longitude"
      },
      {
        "type": "INTEGER",
        "mode": "NULLABLE",
        "name": "geo_region_id"
      }
    ],
    "type": "RECORD",
    "mode": "NULLABLE",
    "name": "location"
  },
  {
    "type": "STRING",
    "mode": "NULLABLE",
    "name": "campaign_id"
  },
  {
    "type": "STRING",
    "mode": "REQUIRED",
    "name": "topic"
  }
]