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,176–3,200 of 4,762

card_payment, page 128 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
369235Toronto Bay StCanadaWilliam Gagnon5534724662020NULL
369311Manchester Market StUnited KingdomGrace Jones54601802122022NULL
369413Edinburgh Princes StUnited KingdomGrace Jones4171148882022NULL
369513Bristol Corn StUnited KingdomGrace Jones4451615562021NULL
36966San Francisco Market StUnited StatesMason Moore53082867122021NULL
36975Manhattan MidtownUnited StatesElla Anderson5289297462023NULL
369830Saint Petersburg NevskyRussiaAlexander Ivanov4721686822019NULL
369926Adelaide Rundle MallAustraliaAmelia Williams5356460292023NULL
370010Hangzhou XihuChinaWei Zhou6208697652023NULL
370129Utrecht CentrumNetherlandsLucas de Jong40337937122020NULL
370231Warszawa ŚródmieściePolandZuzanna Zieliński4668255942020NULL
370335Toronto Bay StCanadaCharlotte Martin4249428472023Google Pay
370425Seoul GangnamSouth KoreaSeo-yeon Cho47725413112019Apple Pay
37054Strasbourg KléberFranceLéa Thomas4973921392019NULL
37064Paris LouvreFranceLéa Thomas4669424422020NULL
370724Busan SeomyeonSouth KoreaSeo-yeon Cho5387381522023NULL
37086San Francisco Market StUnited StatesAva Wilson5336602732021NULL
370922Tokyo MarunouchiJapanYui Nakamura55612500102019NULL
371022Osaka UmedaJapanYui Nakamura52517461122021NULL
37115Austin DowntownUnited StatesAva Anderson37027213112023NULL
371232Stockholm Sergels TorgSwedenLucas Persson5303719132022NULL
37132Lille Grand PlaceFranceChloé Bernard5507021182023NULL
371435Toronto Bay StCanadaNoah Smith4116363212021NULL
37151Lyon BellecourFranceChloé Dubois4408226292019NULL
371634Tampere HämeenkatuFinlandVäinö Korhonen5123825532022Apple 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;