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,576–3,600 of 4,762

card_payment, page 144 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
41344Strasbourg KléberFranceHugo Durand4519482742020NULL
41353Toulouse CapitoleFranceLucas Leroy4549245782023Google Pay
41361Paris OpéraFranceGabriel Durand4678882822021NULL
413724Busan SeomyeonSouth KoreaDo-yun Choi54140989122020NULL
41384Paris LouvreFranceHugo Laurent49578910102023NULL
413919München MarienplatzGermanyBen Wagner5109205912022Google Pay
41407Denver Union StationUnited StatesMia Anderson3765181122020NULL
41414Strasbourg KléberFranceHugo Leroy4478936152024NULL
414228Amsterdam ZuidasNetherlandsTess Smit5451705162022NULL
41438Beijing XidanChinaXin Sun4962318772023NULL
41443Toulouse CapitoleFranceHugo Laurent5541640792021Apple Pay
41452Lille Grand PlaceFranceArthur Laurent5249700242020NULL
41462Lille Grand PlaceFranceGabriel Simon5495107682021NULL
41475Austin DowntownUnited StatesMia Williams4362703462021NULL
414810Hangzhou XihuChinaJun Huang4411396022022NULL
41491Lyon BellecourFranceLouis Moreau5580424942022NULL
415024Busan SeomyeonSouth KoreaJi-woo Kim41443493112022Apple Pay
41512Lille Grand PlaceFranceManon Simon4943575272024NULL
415234Helsinki AleksanterinkatuFinlandAino Mäkinen4454481992024NULL
415318Frankfurt TaunusanlageGermanyPaul Fischer5400791762024NULL
41542Lille Grand PlaceFranceChloé Robert5239540282024NULL
41556San Francisco Market StUnited StatesLiam Johnson37565631112024Google Pay
41564Paris LouvreFranceCamille Laurent4675008592020Apple Pay
41575Austin DowntownUnited StatesEthan Taylor4388092392020Google Pay
415812Leeds BriggateUnited KingdomAmelia Patel4526678662022NULL
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;