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,751–2,775 of 4,762

card_payment, page 111 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
321228Rotterdam CoolsingelNetherlandsNoah Jansen46487641112020NULL
321324Seoul YeouidoSouth KoreaJi-woo Park4844526512023Apple Pay
32146Atlanta MidtownUnited StatesAva Garcia5461106472023NULL
321513Edinburgh Princes StUnited KingdomSophie Johnson54897373112023NULL
32166Atlanta MidtownUnited StatesMason Jones5180934252020NULL
32175Manhattan MidtownUnited StatesMason Jones5313922632022NULL
32182Marseille CanebièreFranceHugo Lefebvre41477685102023NULL
321914Milano DuomoItalyLeonardo Rossi4060954072020NULL
322032Stockholm Sergels TorgSwedenMaja Karlsson5168057162022NULL
32217Seattle Pike PlaceUnited StatesAva Moore4481420112021NULL
32246Atlanta MidtownUnited StatesJames Miller4085827762022NULL
32268Shanghai PudongChinaHao Liu5527631392019NULL
322710Hangzhou XihuChinaLei Huang62849116112023NULL
322827Sydney Martin PlaceAustraliaWilliam Jones5461523062023NULL
322915Firenze Santa Maria NovellaItalyGiulia Bianchi4638697132022NULL
32301Paris OpéraFranceJules Dubois5208169472023Google Pay
32317Denver Union StationUnited StatesAva Miller5581161082022NULL
323230Saint Petersburg NevskyRussiaIvan Kuznetsov54068786112022NULL
323430Moscow TverskayaRussiaMaria Ivanov48718375122020NULL
323530Moscow TverskayaRussiaIvan Kuznetsov4819638812021NULL
323620Rio CentroBrazilHelena Santos46771863102021NULL
323724Seoul YeouidoSouth KoreaJi-woo Jung4202649612023NULL
32384Strasbourg KléberFranceArthur Martin4825322252019NULL
323914Torino CentroItalyAlessandro Romano5406530372023NULL
324112Leeds BriggateUnited KingdomAlfie Wilson5597142612022Apple Pay
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;