---
title: "Clubs Memberships Data Lake Sample Schema [Up to date as of Nov 6, 2023]"
slug: "clubs-memberships-data-lake-schema-up-to-date-as-of-nov-6-2023"
updated: 2024-03-06T18:20:57Z
published: 2024-03-06T18:20:57Z
canonical: "docs.winedirect.com/clubs-memberships-data-lake-schema-up-to-date-as-of-nov-6-2023"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.winedirect.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Clubs Memberships Data Lake Schema [Up to date as of Nov 6, 2023]

```actionscript
[
  {
    "Name": "op",
    "Type": "string"
  },
  {
    "Name": "id",
    "Type": "string"
  },
  {
    "Name": "club_id",
    "Type": "string"
  },
  {
    "Name": "customer_id",
    "Type": "string"
  },
  {
    "Name": "human_id",
    "Type": "int"
  },
  {
    "Name": "start_date",
    "Type": "timestamp"
  },
  {
    "Name": "cancellation_date",
    "Type": "timestamp"
  },
  {
    "Name": "status",
    "Type": "string"
  },
  {
    "Name": "delivery_preference",
    "Type": "string"
  },
  {
    "Name": "primary_shipping_address_id",
    "Type": "string"
  },
  {
    "Name": "primary_billing_address_id",
    "Type": "string"
  },
  {
    "Name": "wine_preference",
    "Type": "string"
  },
  {
    "Name": "manual_processing_required",
    "Type": "string"
  },
  {
    "Name": "creation_channel",
    "Type": "string"
  },
  {
    "Name": "created_at",
    "Type": "timestamp"
  },
  {
    "Name": "updated_at",
    "Type": "string"
  },
  {
    "Name": "club_option_id",
    "Type": "string"
  },
  {
    "Name": "terms_accepted_at",
    "Type": "timestamp"
  },
  {
    "Name": "stored_card_id",
    "Type": "string"
  },
  {
    "Name": "hard_deleted",
    "Type": "boolean"
  },
  {
    "Name": "tenant_id",
    "Type": "string"
  },
  {
    "Name": "wdc_id",
    "Type": "string"
  },
  {
    "Name": "pickup_location_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)"
  }
]
```