Skip to content
Louvre Ops DB

Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Download CSV Query in playground

Rows 3,401–3,425 of 4,762

card_payment, page 137 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
39425Austin DowntownUnited StatesEmma Taylor3757795462020Apple Pay
39431Paris OpéraFranceCamille Dubois4931781252023NULL
39445Manhattan MidtownUnited StatesAva Anderson4184001842022NULL
39457Seattle Pike PlaceUnited StatesAva Johnson5412346772019NULL
39465Austin DowntownUnited StatesLiam Wilson4626689772019Google Pay
39473Rennes RépubliqueFranceChloé Durand5585468832019NULL
39491Nantes CommerceFranceChloé Durand4456517262020NULL
395133Bergen BryggenNorwayJakob Pedersen5472261482022NULL
39528Beijing XidanChinaHao Liu51918275122019NULL
39532Paris La DéfenseFranceHugo Robert5567303972021NULL
395422Osaka UmedaJapanSota Yamamoto48701223112021NULL
39556San Francisco Market StUnited StatesJames Johnson3736026142020NULL
39565Austin DowntownUnited StatesEthan Wilson54669306112020NULL
39572Marseille CanebièreFranceJules Durand5233958122022NULL
39587Seattle Pike PlaceUnited StatesOlivia Garcia3754892552021NULL
396015Roma TerminiItalyGinevra Russo45768864112022Apple Pay
396120São Paulo PaulistaBrazilLaura Pereira4568860312021NULL
396215Roma TerminiItalyMatteo Esposito4672689882019NULL
39636San Francisco Market StUnited StatesLiam Smith4023398042020NULL
396418Frankfurt TaunusanlageGermanyPaul Wagner4058274182023NULL
396518Frankfurt TaunusanlageGermanyPaul Wagner5103166562023NULL
396635Toronto Bay StCanadaWilliam Roy4198500952019NULL
396729Utrecht CentrumNetherlandsEmma de Vries5465387442020NULL
39683Toulouse CapitoleFranceLouis Laurent4139596862021NULL
396910Chengdu JinjiangChinaJun Wang5445100172023NULL
Table definition
CREATE TABLE card_payment (
  payment_id     INTEGER PRIMARY KEY REFERENCES payment (payment_id),
  institution_id INTEGER NOT NULL REFERENCES financial_institution (institution_id),
  issuing_branch TEXT NOT NULL,
  issued_country TEXT NOT NULL,
  account_name   TEXT NOT NULL,
  card_first4    TEXT NOT NULL CHECK (length(card_first4) = 4 AND card_first4 NOT GLOB '*[^0-9]*'),
  card_last4     TEXT NOT NULL CHECK (length(card_last4) = 4 AND card_last4 NOT GLOB '*[^0-9]*'),
  expiry_month   INTEGER NOT NULL CHECK (expiry_month BETWEEN 1 AND 12),
  expiry_year    INTEGER NOT NULL CHECK (expiry_year BETWEEN 2000 AND 2099),
  wallet         TEXT CHECK (wallet IN ('Apple Pay', 'Google Pay'))
) STRICT;