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 401–425 of 4,762

card_payment, page 17 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
48710Hangzhou XihuChinaHao Wang4801198712019NULL
4883Rennes RépubliqueFranceZoé Durand4953840842018NULL
48915Roma TerminiItalyGinevra Russo4222538582017NULL
49027Brisbane Queen StAustraliaCharlotte Taylor3791694382019NULL
49114Milano DuomoItalyGinevra Marino4729841722016NULL
4929Guangzhou TianheChinaWei Wang6242649382016Apple Pay
4934Paris LouvreFranceJules Robert4295571552020NULL
49414Milano DuomoItalyAlessandro Colombo46487454112019NULL
49519Hamburg JungfernstiegGermanyLina Koch53605241122019NULL
4967Seattle Pike PlaceUnited StatesHarper Jones47203529122019NULL
49715Roma TerminiItalyLorenzo Romano4032449972019NULL
49830Moscow TverskayaRussiaDmitry Popov4098088552018NULL
49914Torino CentroItalySofia Ferrari4185619762019Apple Pay
50013Bristol Corn StUnited KingdomSophie Brown3775575922019NULL
50115Roma TerminiItalyAurora Rossi4388392672019NULL
50228Rotterdam CoolsingelNetherlandsNoah Jansen4282104152020NULL
5032Paris La DéfenseFranceLucas Leroy4353696392017NULL
5047Seattle Pike PlaceUnited StatesEthan Anderson55063466112016Google Pay
50515Firenze Santa Maria NovellaItalyAurora Russo51063872122016NULL
5068Beijing XidanChinaTao Yang4714764122017Apple Pay
5088Shanghai PudongChinaYan Wang4578851522020NULL
51023Yokohama MinatomiraiJapanSota Sato35595565112019NULL
5112Paris La DéfenseFranceZoé Martin44854628122016NULL
5124Strasbourg KléberFranceChloé Martin4328957232016NULL
51312Leeds BriggateUnited KingdomSophie Smith4202904542018NULL
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;