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,426–3,450 of 4,762

card_payment, page 138 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
397010Hangzhou XihuChinaJun Li51240499102019NULL
397115Firenze Santa Maria NovellaItalyLeonardo Ferrari53805227102023NULL
397215Firenze Santa Maria NovellaItalyAlessandro Colombo5463000122023NULL
397335Toronto Bay StCanadaBenjamin Wilson4799065872023NULL
39749Guangzhou TianheChinaLin Wu6259052712023NULL
39752Lille Grand PlaceFranceInès Petit42495779102019Apple Pay
39763Toulouse CapitoleFranceLéa Martin4423286852022NULL
39777Denver Union StationUnited StatesEmma Garcia4220553212020NULL
397835Toronto Bay StCanadaLiam Lee44384918112020NULL
397924Busan SeomyeonSouth KoreaSu-ah Kang45430045112023NULL
39808Beijing XidanChinaLin Wu5556942532023NULL
39814Strasbourg KléberFranceHugo Durand4764134052020NULL
398212Leeds BriggateUnited KingdomLily Taylor4062470782019NULL
398325Incheon SongdoSouth KoreaMin-jun Park5155411552023NULL
398417Barcelona EixampleSpainLucía Pérez42040354112020NULL
39862Paris La DéfenseFranceLouis Leroy4207813652022NULL
398727Brisbane Queen StAustraliaOliver Brown4614368742019Google Pay
39882Lille Grand PlaceFranceLouis Bernard5536713122019NULL
399111London Canary WharfUnited KingdomFreddie Johnson4584742012020NULL
399227Brisbane Queen StAustraliaOliver Jones5161643932021NULL
39934Paris LouvreFranceCamille Laurent51095811102022NULL
39944Strasbourg KléberFranceLucas Moreau5186899952021NULL
39964Strasbourg KléberFranceArthur Bernard5189054142021NULL
39977Denver Union StationUnited StatesMia Brown4924900112022NULL
39988Beijing XidanChinaTao Zhang5581504782020Apple Pay
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;