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,876–1,900 of 4,762

card_payment, page 76 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
222114Milano DuomoItalyLorenzo Rossi5469018712018NULL
22254Strasbourg KléberFranceLouis Moreau53401119122022NULL
222729Utrecht CentrumNetherlandsLucas Smit4524530122018NULL
222820São Paulo PaulistaBrazilValentina Oliveira46923587102018NULL
222920Rio CentroBrazilValentina Oliveira4457008112021NULL
22307Denver Union StationUnited StatesLogan Garcia40340413122021NULL
22317Denver Union StationUnited StatesLogan Garcia37096763102019Apple Pay
22337Denver Union StationUnited StatesJames Brown3778414742018NULL
22344Strasbourg KléberFranceZoé Simon41694391122021NULL
223522Tokyo MarunouchiJapanRen Sato4965199292018NULL
22384Paris LouvreFranceGabriel Bernard4902998132021NULL
224021Brasília Asa SulBrazilMiguel Alves49156344112020NULL
22413Bordeaux ChartronsFranceCamille Laurent5277204642021NULL
224424Busan SeomyeonSouth KoreaDo-yun Lee4023311142020NULL
224524Seoul YeouidoSouth KoreaMin-jun Park4362487142019NULL
22474Strasbourg KléberFranceLouis Petit4735462742021NULL
224830Saint Petersburg NevskyRussiaIvan Vasiliev42647759112021NULL
22491Paris OpéraFranceHugo Thomas5500698462020NULL
225021Belo Horizonte SavassiBrazilLaura Ferreira4053354492021NULL
225122Osaka UmedaJapanRen Ito5561319812018NULL
225214Milano DuomoItalyGiulia Esposito49621478102022NULL
22532Paris La DéfenseFranceCamille Petit5107038272019NULL
22543Rennes RépubliqueFranceArthur Moreau5569430552022NULL
225711London Canary WharfUnited KingdomSophie Walker4828240932020NULL
225812Birmingham New StUnited KingdomLily Walker37135456122022NULL
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;