Clubs Releases Products Data Lake Schema [Up to date as of Nov 6, 2023]

[
  {
    "Name": "op",
    "Type": "string"
  },
  {
    "Name": "id",
    "Type": "string"
  },
  {
    "Name": "release_id",
    "Type": "string"
  },
  {
    "Name": "product_id",
    "Type": "string"
  },
  {
    "Name": "unit_price",
    "Type": "decimal(28,6)"
  },
  {
    "Name": "quantity",
    "Type": "int"
  },
  {
    "Name": "created_at",
    "Type": "timestamp"
  },
  {
    "Name": "updated_at",
    "Type": "string"
  },
  {
    "Name": "bc_product_id",
    "Type": "bigint"
  },
  {
    "Name": "club_option_id",
    "Type": "string"
  },
  {
    "Name": "min_required",
    "Type": "int"
  },
  {
    "Name": "max_allowed",
    "Type": "int"
  },
  {
    "Name": "hard_deleted",
    "Type": "boolean"
  },
  {
    "Name": "tenant_id",
    "Type": "string"
  },
  {
    "Name": "p_tenant_id",
    "Type": "string",
    "PartitionKey": "Partition (0)"
  },
  {
    "Name": "year",
    "Type": "string",
    "PartitionKey": "Partition (1)"
  },
  {
    "Name": "month",
    "Type": "string",
    "PartitionKey": "Partition (2)"
  },
  {
    "Name": "day",
    "Type": "string",
    "PartitionKey": "Partition (3)"
  },
  {
    "Name": "source",
    "Type": "string",
    "PartitionKey": "Partition (4)"
  }
]