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

card_payment, page 130 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
374413Bristol Corn StUnited KingdomAmelia Smith4461621462022NULL
374535Montréal Ville-MarieCanadaWilliam Smith41144567122021NULL
374635Toronto Bay StCanadaNoah Smith5152164682022NULL
37486Boston Back BayUnited StatesHarper Brown46138426112023NULL
37497Denver Union StationUnited StatesHarper Brown49366670102022NULL
37505Chicago LoopUnited StatesElla Williams4785874542019NULL
37516Boston Back BayUnited StatesMia Taylor53327313112021NULL
37521Paris OpéraFranceChloé Martin53778495122020Apple Pay
37535Manhattan MidtownUnited StatesNoah Taylor5301376862023NULL
37547Denver Union StationUnited StatesNoah Taylor4554419492020NULL
37551Nantes CommerceFranceChloé Leroy48168018122021NULL
37564Strasbourg KléberFranceChloé Leroy5566897282023NULL
37585Manhattan MidtownUnited StatesMia Garcia3791237482019NULL
375924Seoul YeouidoSouth KoreaHa-eun Kim46185397102023NULL
376023Yokohama MinatomiraiJapanHina Sato5328487572019NULL
37618Beijing XidanChinaHao Li5206968632020NULL
376218Frankfurt TaunusanlageGermanyPaul Becker5116255662020NULL
37658Shanghai PudongChinaWei Zhao62832847102023NULL
37666Atlanta MidtownUnited StatesMia Williams5218132082020Apple Pay
376716Sevilla TrianaSpainLucía Sánchez4552960482021NULL
377017Bilbao AbandoSpainDaniel Martín40140671102019NULL
377326WoolloomoolooAustraliaRuby Wilson3705626372019NULL
37747Denver Union StationUnited StatesEmma Jones5160233362022NULL
377522Osaka UmedaJapanAoi Takahashi4175628462023Google Pay
377723Kyoto ShijoJapanAoi Takahashi3539982842022NULL
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;