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 2,926–2,950 of 4,762

card_payment, page 118 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
340320Rio CentroBrazilDavi Souza55300194112021NULL
34049Shenzhen FutianChinaJing Yang62297384102021NULL
340516Sevilla TrianaSpainLucía Fernández54908647122021NULL
340615Firenze Santa Maria NovellaItalySofia Rossi5382880872022NULL
340718Berlin Unter den LindenGermanyLina Becker43236066102023NULL
340918Frankfurt TaunusanlageGermanyHannah Hoffmann53669712112023NULL
341019München MarienplatzGermanyBen Schneider4425347322022NULL
341119München MarienplatzGermanyLina Müller5168497132020Google Pay
34124Paris LouvreFranceChloé Moreau5287848552021NULL
34145Austin DowntownUnited StatesMia Davis4653165112023NULL
34161Paris OpéraFranceArthur Leroy4692555472022NULL
341722Tokyo MarunouchiJapanYuto Watanabe4206728932020Apple Pay
341934Helsinki AleksanterinkatuFinlandVäinö Virtanen4744523332023NULL
34206Boston Back BayUnited StatesLiam Davis5145741672022NULL
34226Boston Back BayUnited StatesEmma Jones52497539112019NULL
342322Osaka UmedaJapanSakura Suzuki3514593152022NULL
34243Rennes RépubliqueFranceLéa Moreau54166661112022Apple Pay
342520Rio CentroBrazilValentina Souza55704907112022NULL
342619München MarienplatzGermanyBen Meyer45962682102022NULL
34279Shenzhen FutianChinaHao Li4086219552019Apple Pay
34281Lyon BellecourFranceHugo Leroy4438696732023NULL
34295Manhattan MidtownUnited StatesMia Brown3754231432023NULL
34303Rennes RépubliqueFranceHugo Petit49399385112019NULL
343111Manchester Market StUnited KingdomAmelia Brown37965097122023NULL
343313Edinburgh Princes StUnited KingdomGrace Evans4866632222020NULL
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;