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 651–675 of 4,762

card_payment, page 27 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
7913Rennes RépubliqueFranceChloé Laurent5252400862017NULL
79211Manchester Market StUnited KingdomIsla Davies3707751942016NULL
79435Toronto Bay StCanadaLiam Lee4222428072016NULL
79624Seoul YeouidoSouth KoreaHa-eun Choi4199381852020NULL
7976Boston Back BayUnited StatesEthan Wilson40773802102019NULL
7983Rennes RépubliqueFranceArthur Thomas55620116112018NULL
7994Strasbourg KléberFranceManon Simon5180933932019NULL
8001Paris OpéraFranceLouis Petit4311692992017NULL
8024Strasbourg KléberFranceManon Thomas4328661632019NULL
8034Paris LouvreFranceHugo Moreau5221984692017NULL
8042Paris La DéfenseFranceManon Bernard5403985822016NULL
8058Beijing XidanChinaYang Zhou4284195982018NULL
8075Chicago LoopUnited StatesMason Garcia5307246272020NULL
80919Hamburg JungfernstiegGermanyLea Fischer4542687952017NULL
8104Paris LouvreFranceLouis Robert42229792122016NULL
8114Strasbourg KléberFranceManon Dubois4039576062018NULL
8122Lille Grand PlaceFranceLouis Simon4634426022016NULL
81311Manchester Market StUnited KingdomLily Johnson4314879312017NULL
81515Firenze Santa Maria NovellaItalyMatteo Russo5275478992020NULL
81712Birmingham New StUnited KingdomLily Johnson55444582112017NULL
81823Yokohama MinatomiraiJapanSota Nakamura4337887742018NULL
81922Tokyo MarunouchiJapanSota Nakamura46933862112019NULL
82016Sevilla TrianaSpainValeria López4718457122019NULL
82117Barcelona EixampleSpainValeria López5349259552020NULL
8221Lyon BellecourFranceInès Dubois44643168112019NULL
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;