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 4,526–4,550 of 4,762

card_payment, page 182 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
515224Busan SeomyeonSouth KoreaYe-jun Cho4351268842021NULL
515323Kyoto ShijoJapanRen Tanaka3577837652023NULL
51544Strasbourg KléberFranceGabriel Simon4599989062021Google Pay
51553Bordeaux ChartronsFranceGabriel Lefebvre5152998152024NULL
515621Brasília Asa SulBrazilHeitor Rodrigues4457072032020NULL
515721Brasília Asa SulBrazilHeitor Rodrigues40444104102024Apple Pay
515920São Paulo PaulistaBrazilLaura Rodrigues5180800492023NULL
516032Stockholm Sergels TorgSwedenHugo Eriksson53723153112022NULL
516130Moscow TverskayaRussiaDmitry Petrov4975000022023NULL
516232Göteborg AvenynSwedenMaja Olsson5457605492022NULL
516331Warszawa ŚródmieściePolandJan Kowalski5162988162024NULL
516432Göteborg AvenynSwedenElsa Eriksson5544816912024NULL
51654Paris LouvreFranceChloé Lefebvre4004309582020NULL
516624Seoul YeouidoSouth KoreaSu-ah Kim5442682082024NULL
516717Bilbao AbandoSpainÁlvaro Gómez4243337332024NULL
516825Seoul GangnamSouth KoreaDo-yun Cho5388074472024Google Pay
516917Barcelona EixampleSpainMateo Martín51006534102022Apple Pay
517018Frankfurt TaunusanlageGermanyLina Becker40496796102022NULL
517112Birmingham New StUnited KingdomIsla Patel5286214522023NULL
517233Oslo BjørvikaNorwayIngrid Kristiansen5327367152020NULL
51736Atlanta MidtownUnited StatesNoah Wilson3794525582024NULL
517423Kyoto ShijoJapanSakura Ito5561016112020NULL
51758Shanghai PudongChinaJun Yang4765801342022NULL
51767Seattle Pike PlaceUnited StatesEthan Wilson4927386242021NULL
517713Bristol Corn StUnited KingdomAlfie Wright55675674122024NULL
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;