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,151–3,175 of 4,762

card_payment, page 127 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
366322Osaka UmedaJapanYui Sato4508816622022NULL
366411London Canary WharfUnited KingdomAlfie Jones4233204182021NULL
366512Birmingham New StUnited KingdomAlfie Jones37632322112021Apple Pay
366618Frankfurt TaunusanlageGermanyHannah Koch48883412102021Apple Pay
366735Toronto Bay StCanadaEmma Tremblay4461915672021NULL
36683Rennes RépubliqueFranceLouis Thomas4943939312022NULL
366915Roma TerminiItalyLorenzo Russo4073470622020NULL
36712Lille Grand PlaceFranceInès Martin4370180762022Apple Pay
367235Toronto Bay StCanadaCharlotte Lee4520919322019NULL
36733Bordeaux ChartronsFranceLouis Moreau4195786322022NULL
367435Montréal Ville-MarieCanadaOlivia Brown4288858922022NULL
367518Berlin Unter den LindenGermanyLeon Meyer51016367112019NULL
367618Berlin Unter den LindenGermanyElias Schneider4616272252022NULL
367818Berlin Unter den LindenGermanyElias Schneider48214876102022NULL
36797Seattle Pike PlaceUnited StatesLiam Brown4960489352021NULL
368124Seoul YeouidoSouth KoreaDo-yun Kang4098423112019NULL
368210Chengdu JinjiangChinaLin Huang6293907222020NULL
36839Shenzhen FutianChinaLin Huang52873847102022NULL
36843Toulouse CapitoleFranceZoé Laurent5499937082020NULL
36867Denver Union StationUnited StatesAva Johnson4326575622021NULL
368710Chengdu JinjiangChinaWei Zhou41958059112019NULL
368817Barcelona EixampleSpainÁlvaro Rodríguez5113163162023NULL
36892Paris La DéfenseFranceZoé Moreau4014203252023NULL
369019Hamburg JungfernstiegGermanyPaul Wagner5578452462021NULL
369110Chengdu JinjiangChinaWei Zhou6201451672020Apple Pay
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;