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,801–3,825 of 4,762

card_payment, page 153 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
437213Edinburgh Princes StUnited KingdomHarry Patel4377820782021NULL
43732Lille Grand PlaceFranceZoé Leroy47217543112021NULL
437433Bergen BryggenNorwayNoah Nilsen5213161422024NULL
43752Paris La DéfenseFranceCamille Simon5519873112024Google Pay
43762Paris La DéfenseFranceChloé Lefebvre5400176552023Apple Pay
43777Denver Union StationUnited StatesHarper Moore4479253922021NULL
437830Moscow TverskayaRussiaMikhail Popov48108168122024NULL
43798Beijing XidanChinaJing Wu5575168792020Apple Pay
43801Lyon BellecourFranceLucas Martin5406739822022NULL
438130Moscow TverskayaRussiaAnastasia Ivanov5332553512022NULL
43823Bordeaux ChartronsFranceZoé Leroy4918585842023NULL
43835Chicago LoopUnited StatesOlivia Williams46096234122024NULL
43846Boston Back BayUnited StatesOlivia Williams3769542742024NULL
43855Chicago LoopUnited StatesOlivia Williams4639676542021Apple Pay
43865Manhattan MidtownUnited StatesLiam Taylor5465356582022Apple Pay
43872Marseille CanebièreFranceHugo Thomas5312275722020Apple Pay
438823Kyoto ShijoJapanYui Takahashi4191754542023NULL
43899Shenzhen FutianChinaJing Wu4700043872023NULL
439026WoolloomoolooAustraliaRuby Nguyen3735325322020NULL
439131Warszawa ŚródmieściePolandJulia Wójcik5581189822021Apple Pay
43922Marseille CanebièreFranceZoé Robert49899279102022Apple Pay
439311London Canary WharfUnited KingdomHarry Johnson45397154122020NULL
43942Marseille CanebièreFranceArthur Martin5462035232022NULL
43951Nantes CommerceFranceLucas Thomas4321156022021NULL
43965Manhattan MidtownUnited StatesOlivia Wilson4520699752022NULL
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;