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 251–275 of 4,762

card_payment, page 11 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
2955Austin DowntownUnited StatesElla Anderson4015208442017NULL
29635Toronto Bay StCanadaLiam Lee4375568982016NULL
2978Beijing XidanChinaXin Wang62641153102018NULL
2982Marseille CanebièreFranceChloé Leroy4557460222018NULL
29930Saint Petersburg NevskyRussiaAlexander Popov5259854172016NULL
3007Denver Union StationUnited StatesElla Johnson55967205102018NULL
30122Osaka UmedaJapanSakura Sato52166771122019NULL
3026Atlanta MidtownUnited StatesAva Miller3715153322018NULL
30322Osaka UmedaJapanSakura Sato35445669122020NULL
3042Paris La DéfenseFranceInès Robert5527265422020NULL
3051Nantes CommerceFranceInès Robert5339407652016NULL
3063Bordeaux ChartronsFranceLéa Durand5483983372020NULL
30811Manchester Market StUnited KingdomLily Jones4553068662018NULL
3093Bordeaux ChartronsFranceChloé Leroy4001177622017NULL
3103Rennes RépubliqueFranceHugo Simon4649146072020NULL
3115Manhattan MidtownUnited StatesMia Brown3780908822018NULL
31215Firenze Santa Maria NovellaItalyLeonardo Russo44718567102019NULL
31315Firenze Santa Maria NovellaItalyLeonardo Russo5141661532018NULL
3144Paris LouvreFranceArthur Simon4389616312019NULL
3152Lille Grand PlaceFranceLucas Durand42332378112017NULL
3165Chicago LoopUnited StatesElla Anderson52872621112018NULL
3176Boston Back BayUnited StatesNoah Garcia52630375112018NULL
31830Moscow TverskayaRussiaAlexander Petrov4355015852019NULL
31916Sevilla TrianaSpainLucía Martínez54905416122016NULL
32029Utrecht CentrumNetherlandsDaan de Vries46540595122016NULL
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;