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

card_payment, page 185 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
52356Atlanta MidtownUnited StatesLiam Williams4840270492021NULL
523628Amsterdam ZuidasNetherlandsJulia de Jong44430542122023NULL
523827Sydney Martin PlaceAustraliaWilliam Ryan51389495122023Apple Pay
52394Strasbourg KléberFranceHugo Bernard5543336512021NULL
524025Seoul GangnamSouth KoreaSu-ah Kang5512448852020Apple Pay
52421Paris OpéraFranceArthur Petit5464393142020NULL
52432Marseille CanebièreFranceGabriel Bernard4442222932021NULL
52444Strasbourg KléberFranceHugo Martin41544841102024NULL
52455Manhattan MidtownUnited StatesOlivia Moore44084343122022NULL
524615Roma TerminiItalySofia Russo4045372722025NULL
524723Yokohama MinatomiraiJapanSakura Nakamura48383594122025NULL
52484Strasbourg KléberFranceCamille Durand42293767112023NULL
52492Paris La DéfenseFranceInès Leroy4728715092021NULL
525014Milano DuomoItalyAlessandro Esposito4099154412024NULL
52516San Francisco Market StUnited StatesHarper Wilson4453258582024NULL
52525Manhattan MidtownUnited StatesHarper Johnson4052746962021NULL
525316Madrid Gran VíaSpainSofía Pérez5339719452023Google Pay
52541Nantes CommerceFranceArthur Laurent45962241112024NULL
52551Lyon BellecourFranceJules Durand40789599112022NULL
525619München MarienplatzGermanyElias Meyer5210602212022NULL
52576Boston Back BayUnited StatesOlivia Moore4475113882021NULL
525819Hamburg JungfernstiegGermanyPaul Müller42577225112023NULL
525926Adelaide Rundle MallAustraliaRuby Kelly4304046572023NULL
526022Osaka UmedaJapanSota Nakamura35642817112025NULL
526123Kyoto ShijoJapanSota Nakamura3577691542023Apple 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;