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,376–1,400 of 4,762

card_payment, page 56 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
164514Milano DuomoItalySofia Ferrari4821646422021NULL
164617Barcelona EixampleSpainSofía Sánchez5398187082018NULL
16484Strasbourg KléberFranceArthur Robert5550290212020NULL
164919München MarienplatzGermanyLeon Schmidt5135265912019NULL
16504Strasbourg KléberFranceLucas Durand4861637682017NULL
16512Paris La DéfenseFranceLéa Laurent4666590792020NULL
16529Guangzhou TianheChinaYang Huang4663045452017Apple Pay
16532Marseille CanebièreFranceLucas Durand5149157382020NULL
165410Hangzhou XihuChinaYang Zhou4546416552019NULL
16551Paris OpéraFranceManon Leroy5297166732021NULL
16561Lyon BellecourFranceManon Lefebvre4895672962019NULL
165822Osaka UmedaJapanAoi Watanabe4679941852017NULL
165926Melbourne Collins StAustraliaRuby Jones4684927832020NULL
166017Bilbao AbandoSpainMateo Gómez46566669102017NULL
16616Atlanta MidtownUnited StatesAva Wilson5262922922017NULL
16627Seattle Pike PlaceUnited StatesMia Taylor51395954122018NULL
16637Denver Union StationUnited StatesAva Smith42901700102019NULL
166415Firenze Santa Maria NovellaItalyBeatrice Greco5597686522017NULL
166522Osaka UmedaJapanAoi Sato41126713112019NULL
16661Lyon BellecourFranceZoé Bernard4600307742017NULL
166712Birmingham New StUnited KingdomHarry Patel44870816102018NULL
16693Rennes RépubliqueFranceArthur Moreau5320565352021NULL
16702Marseille CanebièreFranceArthur Robert5117192372018NULL
167133Bergen BryggenNorwayIngrid Olsen5246619822019NULL
167219München MarienplatzGermanyLeon Schmidt5407113442021NULL
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;