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,001–2,025 of 4,762

card_payment, page 81 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
23733Bordeaux ChartronsFranceHugo Thomas5564795162019NULL
237410Hangzhou XihuChinaWei Li4112508792018Apple Pay
237522Osaka UmedaJapanYuto Tanaka5215409912021NULL
237631Warszawa ŚródmieściePolandMaja Zieliński4704640882022NULL
237731Kraków RynekPolandZuzanna Wójcik4618345742018NULL
237818Berlin Unter den LindenGermanyBen Schneider5540241442020NULL
237914Milano DuomoItalyFrancesco Colombo5263391462018NULL
238015Firenze Santa Maria NovellaItalySofia Romano46118350112020NULL
238132Göteborg AvenynSwedenOscar Karlsson46137179122021NULL
238332Göteborg AvenynSwedenOscar Karlsson5178994352021NULL
23841Lyon BellecourFranceArthur Simon4015185512022NULL
23859Guangzhou TianheChinaWei Li4692074942020NULL
238625Incheon SongdoSouth KoreaSu-ah Cho5238705732021NULL
238716Madrid Gran VíaSpainPaula Fernández4791944642020NULL
238818Berlin Unter den LindenGermanyPaul Fischer5213954062021NULL
23894Strasbourg KléberFranceHugo Simon5102058392020NULL
239025Seoul GangnamSouth KoreaDo-yun Park4773408952022NULL
23915Manhattan MidtownUnited StatesMason Williams43107150122021NULL
239217Bilbao AbandoSpainPaula Pérez4998730062019NULL
23946San Francisco Market StUnited StatesMason Anderson4103677292019NULL
23978Shanghai PudongChinaXin Zhao6267009932018NULL
23987Denver Union StationUnited StatesElla Davis4968042412022Apple Pay
240025Seoul GangnamSouth KoreaDo-yun Park5475848872018NULL
24018Beijing XidanChinaJing Yang4955046662022NULL
24023Toulouse CapitoleFranceGabriel Simon4406408282019Apple 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;