Editing Openai/69111a25-dab4-8000-8929-8d5e16a9da88 (section)

==== Schema snippet: ====

<syntaxhighlight lang="sql">CREATE TABLE card_master (
  id UUID PRIMARY KEY,
  card_token TEXT UNIQUE,
  card_bin CHAR(6),
  last_four CHAR(4),
  card_number_masked TEXT,
  card_network TEXT,
  expiry_month SMALLINT,
  expiry_year SMALLINT,
  pci_dss_compliant BOOLEAN,
  encryption_key_id TEXT,
  tokenization_provider TEXT,
  credit_limit BIGINT,
  status TEXT,
  validation_errors JSONB,
  created_at TIMESTAMP,
  updated_at TIMESTAMP
);

</syntaxhighlight>

Quick check query (expired as of specific date):

<syntaxhighlight lang="sql">SELECT card_token FROM card_master
WHERE (expiry_year < 2025) OR (expiry_year = 2025 AND expiry_month < 10);

</syntaxhighlight>