Store Service

CREATE TABLE store (
  id             UUID         PRIMARY KEY DEFAULT gen_random_uuid(),
  name           VARCHAR(255) NOT NULL,
  status         VARCHAR(16)  NOT NULL DEFAULT 'ACTIVE'
                   CHECK (status IN ('ACTIVE', 'SUSPENDED', 'DEPROVISIONED')),
  plan           VARCHAR(32)  NOT NULL,
  created_at     TIMESTAMPTZ  NOT NULL DEFAULT now(),
  updated_at     TIMESTAMPTZ  NOT NULL DEFAULT now()
);

-- Supported locales per store (BCP 47)
CREATE TABLE store_locale (
  store_id    UUID    NOT NULL REFERENCES store(id) ON DELETE CASCADE,
  locale      CHAR(5) NOT NULL,
  is_default  BOOLEAN NOT NULL DEFAULT FALSE,
  PRIMARY KEY (store_id, locale)
);

-- Supported currencies per store (ISO 4217)
CREATE TABLE store_currency (
  store_id    UUID    NOT NULL REFERENCES store(id) ON DELETE CASCADE,
  currency    CHAR(3) NOT NULL,
  is_default  BOOLEAN NOT NULL DEFAULT FALSE,
  PRIMARY KEY (store_id, currency)
);

-- All other store-level config in typed JSONB columns
CREATE TABLE store_settings (
  store_id    UUID PRIMARY KEY REFERENCES store(id) ON DELETE CASCADE,
  timezone    VARCHAR(64)  NOT NULL DEFAULT 'UTC',
  contact     JSONB,   -- { email, phone }
  business    JSONB,   -- { legal_name, tax_id, address }
  storefront  JSONB,   -- { title, description, logo_s3_key, favicon_s3_key, colors }
  checkout    JSONB,   -- { guest_checkout_enabled, require_phone, ... }
  updated_at  TIMESTAMPTZ NOT NULL DEFAULT now()
);

-- Custom domains
CREATE TABLE store_domain (
  id          UUID         PRIMARY KEY DEFAULT gen_random_uuid(),
  store_id    UUID         NOT NULL REFERENCES store(id) ON DELETE CASCADE,
  domain      VARCHAR(255) NOT NULL UNIQUE,
  is_primary  BOOLEAN      NOT NULL DEFAULT FALSE,
  ssl_status  VARCHAR(16)  NOT NULL DEFAULT 'PENDING'
                CHECK (ssl_status IN ('PENDING', 'ACTIVE', 'FAILED')),
  created_at  TIMESTAMPTZ  NOT NULL DEFAULT now()
);

-- Feature flags (seeded from plan matrix at provisioning; overridable per store)
CREATE TABLE store_feature_flag (
  store_id  UUID         NOT NULL REFERENCES store(id) ON DELETE CASCADE,
  flag      VARCHAR(128) NOT NULL,
  enabled   BOOLEAN      NOT NULL DEFAULT TRUE,
  config    JSONB,
  PRIMARY KEY (store_id, flag)
);

service StoreReaderService {
  rpc GetStore(GetStoreRequest) returns (StoreResponse);
  rpc GetStoreSettings(GetStoreSettingsRequest) returns (StoreSettingsResponse);
  rpc IsFeatureEnabled(IsFeatureEnabledRequest) returns (IsFeatureEnabledResponse);
  rpc GetFeatureFlags(GetFeatureFlagsRequest) returns (FeatureFlagsResponse);

  // Domain-based store resolution — called by gateway-service on every storefront request
  rpc GetStoreByDomain(GetStoreByDomainRequest) returns (StoreResponse);
}