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 1,226–1,250 of 4,762

card_payment, page 50 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
14716San Francisco Market StUnited StatesLogan Moore5532823152021NULL
147211London Canary WharfUnited KingdomOliver Wilson4626784362017NULL
147317Bilbao AbandoSpainPablo Sánchez4563880192019NULL
14745Chicago LoopUnited StatesLiam Williams5444455852019Google Pay
14757Seattle Pike PlaceUnited StatesJames Miller5501890562017NULL
147614Milano DuomoItalyFrancesco Ferrari4112029472017NULL
14771Lyon BellecourFranceGabriel Thomas4418934892019Apple Pay
14806Boston Back BayUnited StatesMia Miller4324926432019NULL
148117Bilbao AbandoSpainMateo López5591085822017NULL
14837Seattle Pike PlaceUnited StatesLiam Brown4827390832019NULL
148428Rotterdam CoolsingelNetherlandsTess Meijer5423211362018NULL
148529Eindhoven StratumseindNetherlandsTess Jansen5176467962019NULL
148827Brisbane Queen StAustraliaAmelia Smith4771932622020NULL
148920São Paulo PaulistaBrazilAlice Santos54413022102021NULL
14909Shenzhen FutianChinaYang Huang62316185122020NULL
14919Guangzhou TianheChinaYang Huang4586496362020Apple Pay
14924Strasbourg KléberFranceLouis Dubois4279716172017NULL
149311London Canary WharfUnited KingdomSophie Taylor5457290272018Apple Pay
149525Seoul GangnamSouth KoreaJi-woo Park5149886342021NULL
14963Rennes RépubliqueFranceLucas Simon4725833352019NULL
14984Strasbourg KléberFranceZoé Dubois4850489732021NULL
149930Moscow TverskayaRussiaDaria Popov5196702672021NULL
150123Yokohama MinatomiraiJapanAoi Takahashi4892117582019Apple Pay
150435Toronto Bay StCanadaBenjamin Gagnon40601740122019NULL
150535Montréal Ville-MarieCanadaBenjamin Gagnon5361374362018NULL
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;