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 1,601–1,625 of 4,762

card_payment, page 65 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
190619Hamburg JungfernstiegGermanyMia Becker43376623112018NULL
190719München MarienplatzGermanyMia Becker5415441322020NULL
19085Chicago LoopUnited StatesOlivia Anderson3739472392022NULL
190928Rotterdam CoolsingelNetherlandsSem de Jong4232013912022NULL
191014Milano DuomoItalyLorenzo Ferrari5325210482020NULL
19117Seattle Pike PlaceUnited StatesEmma Wilson5141248982022NULL
19136Atlanta MidtownUnited StatesEmma Wilson4591750222020Apple Pay
191414Torino CentroItalyGiulia Bianchi5426075252019NULL
19153Toulouse CapitoleFranceLéa Petit5542213232018NULL
19169Shenzhen FutianChinaXin Zhang62459192102020Google Pay
19182Paris La DéfenseFranceInès Laurent4178952912019NULL
19197Denver Union StationUnited StatesMason Williams5447331512020NULL
19206Boston Back BayUnited StatesNoah Smith4776626262018NULL
192115Roma TerminiItalyLorenzo Romano4350221532021NULL
19226Boston Back BayUnited StatesLogan Taylor5271983562021NULL
19249Shenzhen FutianChinaLei Sun62540418102020NULL
19252Lille Grand PlaceFranceLéa Martin5255450262018NULL
192615Firenze Santa Maria NovellaItalyLorenzo Ferrari54380417112019NULL
192714Milano DuomoItalyAurora Greco5347976632020NULL
19287Seattle Pike PlaceUnited StatesEthan Garcia5157117592020NULL
19297Seattle Pike PlaceUnited StatesAva Brown55894458102019NULL
19303Rennes RépubliqueFranceLucas Durand54785131112022NULL
19312Paris La DéfenseFranceManon Leroy44571849102021NULL
193228Rotterdam CoolsingelNetherlandsEmma Meijer40120183102021NULL
19333Bordeaux ChartronsFranceZoé Dubois4073036972018NULL
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;