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,101–4,125 of 4,762

card_payment, page 165 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
46902Lille Grand PlaceFranceLucas Leroy4864984372024NULL
469120Rio CentroBrazilMiguel Oliveira5235784542024NULL
469221Belo Horizonte SavassiBrazilValentina Ferreira4960483682024NULL
46939Shenzhen FutianChinaMin Zhou6226884582022Apple Pay
46948Shanghai PudongChinaMin Zhou5114761842022NULL
469524Busan SeomyeonSouth KoreaMin-jun Cho4859718322024Apple Pay
469631Warszawa ŚródmieściePolandSzymon Kowalczyk47554002112024NULL
469718Berlin Unter den LindenGermanyLea Koch4788676962021NULL
469828Rotterdam CoolsingelNetherlandsJulia de Jong4709522292022NULL
46997Denver Union StationUnited StatesMason Jones3757973842021NULL
470019München MarienplatzGermanyEmma Wagner54183797102023NULL
470134Helsinki AleksanterinkatuFinlandVäinö Mäkinen45678623122021NULL
470210Chengdu JinjiangChinaLei Wu62296981102020NULL
47037Seattle Pike PlaceUnited StatesHarper Williams4576911872022NULL
470428Amsterdam ZuidasNetherlandsLucas de Vries4434417912024NULL
47051Nantes CommerceFranceManon Lefebvre4872030852022NULL
470622Osaka UmedaJapanSakura Nakamura40450008102024NULL
47076Boston Back BayUnited StatesJames Wilson4525337242022NULL
470813Edinburgh Princes StUnited KingdomOliver Patel5243439012024NULL
47099Shenzhen FutianChinaHao Chen4281408482024Apple Pay
471027Sydney Martin PlaceAustraliaWilliam Brown4861415922021NULL
471116Madrid Gran VíaSpainMateo González5307938552022NULL
47136Atlanta MidtownUnited StatesEthan Garcia3797207922024Google Pay
47147Seattle Pike PlaceUnited StatesEthan Garcia3728325692023NULL
47157Denver Union StationUnited StatesLogan Anderson4616567762023NULL
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;