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,851–3,875 of 4,762

card_payment, page 155 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
442335Montréal Ville-MarieCanadaEmma Brown51998809122020NULL
44242Marseille CanebièreFranceZoé Martin5221880242021NULL
442524Seoul YeouidoSouth KoreaMin-jun Park4136322112020Apple Pay
44267Seattle Pike PlaceUnited StatesNoah Smith4110350272024NULL
442717Bilbao AbandoSpainÁlvaro Pérez44456715122024NULL
44283Rennes RépubliqueFranceGabriel Bernard45043552122022Apple Pay
442919Hamburg JungfernstiegGermanyLea Koch5258942812020NULL
44301Lyon BellecourFranceInès Leroy4180326332022Apple Pay
44316Boston Back BayUnited StatesMason Wilson4808565932022NULL
44325Austin DowntownUnited StatesMason Wilson5570564412024NULL
443319München MarienplatzGermanyMia Wagner5559579352022NULL
44341Paris OpéraFranceArthur Lefebvre47560337122024Apple Pay
44357Seattle Pike PlaceUnited StatesMason Johnson3752567712022NULL
443633Bergen BryggenNorwayNora Andersen5250808352023Google Pay
44371Nantes CommerceFranceInès Laurent4999475992020NULL
443830Saint Petersburg NevskyRussiaAnastasia Vasiliev45826137102022NULL
443921Brasília Asa SulBrazilArthur Rodrigues5534690522021NULL
44406Atlanta MidtownUnited StatesNoah Jones52315299122023Apple Pay
444130Moscow TverskayaRussiaAnastasia Vasiliev5418015872020NULL
44424Paris LouvreFranceHugo Thomas4896943862023Google Pay
444335Montréal Ville-MarieCanadaChloé Lee42302700112022NULL
44445Chicago LoopUnited StatesLiam Anderson44566971112023NULL
44454Paris LouvreFranceLucas Leroy4469067312022NULL
444613Edinburgh Princes StUnited KingdomIsla Johnson4733230162020NULL
44471Lyon BellecourFranceGabriel Dubois4846664632022NULL
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;