-- ============================================================================
-- INSIGHTFUL SAGA SCHEMA EXPORT — SNOWFLAKE DDL
-- Generated: 2026-11-12T16:10:29.163Z
-- ============================================================================

CREATE TABLE IF NOT EXISTS "HUB_CUSTOMER" (
  "HK_CUSTOMER_ID"     CHAR(32) NOT NULL,
  "CUSTOMER_ID"        VARCHAR,
  "LOAD_DATE"          TIMESTAMP_NTZ,
  "RECORD_SOURCE"      VARCHAR,
  CONSTRAINT pk_hub_customer PRIMARY KEY ("HK_CUSTOMER_ID")
);

CREATE TABLE IF NOT EXISTS "HUB_ORDER" (
  "HK_ORDER_NUMBER"    CHAR(32) NOT NULL,
  "ORDER_NUMBER"       VARCHAR,
  "LOAD_DATE"          TIMESTAMP_NTZ,
  "RECORD_SOURCE"      VARCHAR,
  CONSTRAINT pk_hub_order PRIMARY KEY ("HK_ORDER_NUMBER")
);

CREATE TABLE IF NOT EXISTS "LNK_CUSTOMER_ORDER" (
  "HK_LNK_CUSTOMER_ORDER" CHAR(32) NOT NULL,
  "HK_CUSTOMER_ID"     CHAR(32),
  "HK_ORDER_NUMBER"    CHAR(32),
  "LOAD_DATE"          TIMESTAMP_NTZ,
  "RECORD_SOURCE"      VARCHAR,
  CONSTRAINT pk_lnk_customer_order PRIMARY KEY ("HK_LNK_CUSTOMER_ORDER")
);

CREATE TABLE IF NOT EXISTS "SAT_CUSTOMER_PROFILE" (
  "HK_CUSTOMER_ID"     CHAR(32) NOT NULL,
  "LOAD_DATE"          TIMESTAMP_NTZ NOT NULL,
  "HASH_DIFF"          CHAR(32),
  "FIRST_NAME"         VARCHAR,
  "LAST_NAME"          VARCHAR,
  "EMAIL"              VARCHAR,
  "RECORD_SOURCE"      VARCHAR,
  CONSTRAINT pk_sat_customer_profile PRIMARY KEY ("HK_CUSTOMER_ID", "LOAD_DATE")
);

CREATE TABLE IF NOT EXISTS "SAT_ORDER_DETAILS" (
  "HK_ORDER_NUMBER"    CHAR(32) NOT NULL,
  "LOAD_DATE"          TIMESTAMP_NTZ NOT NULL,
  "HASH_DIFF"          CHAR(32),
  "ORDER_TOTAL"        DECIMAL(12,2),
  "STATUS"             VARCHAR,
  "PAYMENT_METHOD"     VARCHAR,
  "RECORD_SOURCE"      VARCHAR,
  CONSTRAINT pk_sat_order_details PRIMARY KEY ("HK_ORDER_NUMBER", "LOAD_DATE")
);