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,251–3,275 of 4,762

card_payment, page 131 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
377818Berlin Unter den LindenGermanyFinn Schneider4853689462022NULL
37797Denver Union StationUnited StatesLiam Smith5510911452019Google Pay
378035Toronto Bay StCanadaChloé Roy4114685792020NULL
37812Lille Grand PlaceFranceChloé Lefebvre4206529732019NULL
378219München MarienplatzGermanyLeon Wagner49028128112021NULL
378318Berlin Unter den LindenGermanyLeon Wagner5379007682020Google Pay
37845Chicago LoopUnited StatesElla Garcia3746334782021NULL
37852Paris La DéfenseFranceInès Leroy5291697212021NULL
37863Toulouse CapitoleFranceHugo Leroy4820034872020NULL
378724Seoul YeouidoSouth KoreaMin-jun Kang4281325352019NULL
378810Chengdu JinjiangChinaJun Zhao4909664392023NULL
37895Chicago LoopUnited StatesMason Smith53255668102021Apple Pay
379027Brisbane Queen StAustraliaAmelia Nguyen5543583692019NULL
379125Incheon SongdoSouth KoreaSeo-yeon Kang4994136482020NULL
37924Strasbourg KléberFranceCamille Leroy4004412682021NULL
37933Toulouse CapitoleFranceLouis Petit5241135342020NULL
379435Toronto Bay StCanadaWilliam Gagnon5142688212023Apple Pay
379524Seoul YeouidoSouth KoreaYe-jun Jung4836322062023NULL
379718Frankfurt TaunusanlageGermanyLina Schneider51444280102023NULL
37982Lille Grand PlaceFranceChloé Petit47236309102020NULL
379930Saint Petersburg NevskyRussiaMikhail Vasiliev4722029042021NULL
380011Manchester Market StUnited KingdomAlfie Smith46782341122023NULL
38012Marseille CanebièreFranceInès Leroy54620030102021NULL
38027Seattle Pike PlaceUnited StatesJames Anderson5412284842023NULL
380319München MarienplatzGermanyLea Wagner5268495212022NULL
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;