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,676–4,700 of 4,762

card_payment, page 188 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
53173Rennes RépubliqueFranceHugo Simon4018081772023NULL
53194Paris LouvreFranceLucas Moreau5579432742025NULL
532031Kraków RynekPolandJakub Wiśniewski41202238102025Google Pay
53213Bordeaux ChartronsFranceZoé Lefebvre4054394062025NULL
53227Seattle Pike PlaceUnited StatesElla Moore4968233832021NULL
53237Denver Union StationUnited StatesOlivia Williams47619809122023NULL
53243Rennes RépubliqueFranceLéa Lefebvre5479723332023NULL
532521Belo Horizonte SavassiBrazilDavi Silva4715999932023NULL
53268Beijing XidanChinaLin Zhao6204940982022NULL
53275Austin DowntownUnited StatesHarper Jones5404913782021NULL
532826WoolloomoolooAustraliaJack Kelly43552037122024NULL
53317Seattle Pike PlaceUnited StatesElla Moore45171354122023NULL
53323Rennes RépubliqueFranceHugo Thomas55847930122024NULL
533326Melbourne Collins StAustraliaAmelia Brown37628711122025NULL
533421Brasília Asa SulBrazilDavi Ferreira5131016112023NULL
533522Osaka UmedaJapanRen Watanabe5578178712023NULL
533610Chengdu JinjiangChinaLin Zhao62603426112022NULL
533722Tokyo MarunouchiJapanYui Yamamoto4516111082021NULL
53383Bordeaux ChartronsFranceLouis Thomas5436593872025Apple Pay
533929Eindhoven StratumseindNetherlandsDaan de Vries5537973642023NULL
53412Lille Grand PlaceFranceLucas Robert4613246982022NULL
53425Austin DowntownUnited StatesNoah Johnson52647936112022NULL
534317Barcelona EixampleSpainÁlvaro Fernández4114078132024NULL
53441Nantes CommerceFranceLouis Petit5163930452023NULL
53451Paris OpéraFranceArthur Dubois4851092522024NULL
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;