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,951–1,975 of 4,762

card_payment, page 79 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
23154Paris LouvreFranceChloé Laurent4585444532022NULL
231632Stockholm Sergels TorgSwedenMaja Persson47351099102022NULL
231730Moscow TverskayaRussiaDaria Vasiliev5117982222022NULL
23181Nantes CommerceFranceHugo Laurent5389859042020Apple Pay
23194Strasbourg KléberFranceGabriel Lefebvre42904263122021NULL
232017Barcelona EixampleSpainValeria González4557455432021NULL
232134Tampere HämeenkatuFinlandOliver Virtanen5404284062022NULL
232210Chengdu JinjiangChinaFang Yang4955839642022NULL
23249Guangzhou TianheChinaJun Zhou62540385102022NULL
232510Hangzhou XihuChinaJun Zhou4737928022022NULL
23261Nantes CommerceFranceZoé Moreau4505615912018NULL
232731Kraków RynekPolandHanna Wiśniewski4791172572022NULL
23286Boston Back BayUnited StatesMia Jones3786954392022NULL
232926Adelaide Rundle MallAustraliaCharlotte Ryan5338009012019NULL
23307Denver Union StationUnited StatesNoah Smith4299823232020NULL
233114Milano DuomoItalyMatteo Marino4128662632018NULL
233216Madrid Gran VíaSpainValeria López53581448102021NULL
233323Yokohama MinatomiraiJapanSakura Suzuki5415714892020NULL
23346San Francisco Market StUnited StatesElla Anderson4505509652022NULL
23354Paris LouvreFranceManon Moreau4303375662020NULL
233731Kraków RynekPolandHanna Wiśniewski5469189532022Apple Pay
23387Denver Union StationUnited StatesMason Moore53820572112018NULL
23397Seattle Pike PlaceUnited StatesEmma Brown3724400652019NULL
234121Belo Horizonte SavassiBrazilHelena Ferreira4908497292022NULL
23422Lille Grand PlaceFranceCamille Leroy4559130722019NULL
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;