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,326–3,350 of 4,762

card_payment, page 134 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
386030Saint Petersburg NevskyRussiaAlexander Morozov5313313632020NULL
386110Hangzhou XihuChinaTao Li6211879982020NULL
386221Belo Horizonte SavassiBrazilDavi Rodrigues4432252122019NULL
386331Kraków RynekPolandJakub Wójcik4287420532022Google Pay
38654Paris LouvreFranceZoé Petit5547754892021NULL
386617Bilbao AbandoSpainÁlvaro Gómez4527401772020Apple Pay
386712Leeds BriggateUnited KingdomFreddie Walker3782085152020NULL
386821Brasília Asa SulBrazilValentina Alves4317874292020NULL
38691Nantes CommerceFranceArthur Durand5509823472019NULL
387026WoolloomoolooAustraliaAmelia Williams5269107912020NULL
38714Strasbourg KléberFranceInès Thomas4891317062023NULL
38721Nantes CommerceFranceInès Thomas49245914112022NULL
38731Nantes CommerceFranceLéa Petit43678500102021NULL
387431Warszawa ŚródmieściePolandJakub Zieliński4174636012021NULL
387527Sydney Martin PlaceAustraliaAmelia Williams4956519892020NULL
38768Beijing XidanChinaTao Li54834465102020NULL
38771Nantes CommerceFranceCamille Robert4520210982021NULL
38782Paris La DéfenseFranceChloé Petit5112140082023NULL
387921Belo Horizonte SavassiBrazilHeitor Santos5232097192019NULL
388113Edinburgh Princes StUnited KingdomAmelia Johnson5276096992020NULL
38829Shenzhen FutianChinaXin Yang62155537112023NULL
38835Austin DowntownUnited StatesElla Miller4154108762023NULL
38841Nantes CommerceFranceLucas Dubois4136600282022NULL
388521Belo Horizonte SavassiBrazilArthur Pereira4291602672023NULL
38867Seattle Pike PlaceUnited StatesLogan Garcia4581759282019NULL
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;