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,626–3,650 of 4,762

card_payment, page 146 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
418730Saint Petersburg NevskyRussiaAnastasia Morozov4413162092021NULL
418832Göteborg AvenynSwedenMaja Larsson4852990732021NULL
41893Rennes RépubliqueFranceChloé Laurent55068772102021Google Pay
419012Birmingham New StUnited KingdomJack Jones5261147772022Google Pay
41927Seattle Pike PlaceUnited StatesEmma Anderson3772788322021NULL
41934Paris LouvreFranceLouis Laurent5559255582020NULL
41949Guangzhou TianheChinaJun Zhao5197244942022NULL
41957Seattle Pike PlaceUnited StatesHarper Johnson5529141452023NULL
41965Chicago LoopUnited StatesHarper Anderson3720225722024Google Pay
41977Seattle Pike PlaceUnited StatesJames Davis5237396742021NULL
419814Torino CentroItalySofia Esposito5532734152022NULL
42007Seattle Pike PlaceUnited StatesEmma Wilson5380992822023Google Pay
420122Tokyo MarunouchiJapanYui Yamamoto4721339052021NULL
42025Manhattan MidtownUnited StatesElla Taylor4796917372021NULL
420323Kyoto ShijoJapanRen Watanabe5113346232020NULL
420419München MarienplatzGermanyBen Wagner4880671982024NULL
420535Montréal Ville-MarieCanadaBenjamin Tremblay5121701252024NULL
420635Montréal Ville-MarieCanadaWilliam Roy55293727122020NULL
42073Bordeaux ChartronsFranceLucas Dubois41823652122024NULL
420810Hangzhou XihuChinaXin Yang5205666922022NULL
42091Nantes CommerceFranceInès Simon4601515252024NULL
42105Austin DowntownUnited StatesJames Williams4547653612023NULL
42117Denver Union StationUnited StatesElla Garcia52921888102021Apple Pay
421223Yokohama MinatomiraiJapanYui Takahashi4698259262024NULL
421330Moscow TverskayaRussiaDmitry Popov5487177512022NULL
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;