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 2,826–2,850 of 4,762

card_payment, page 114 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
329612Birmingham New StUnited KingdomAmelia Smith48701166102021NULL
32972Paris La DéfenseFranceLouis Simon4221349572022NULL
329827Brisbane Queen StAustraliaJack Williams53036572112020NULL
32995Chicago LoopUnited StatesElla Wilson4192551942021Apple Pay
330017Bilbao AbandoSpainMartina López4100566432023NULL
33013Toulouse CapitoleFranceManon Bernard5484792672021NULL
33024Paris LouvreFranceLéa Leroy5136290392023NULL
330331Warszawa ŚródmieściePolandMaja Kamiński4924133912022NULL
330413Edinburgh Princes StUnited KingdomGrace Johnson4877299552022NULL
33053Toulouse CapitoleFranceManon Laurent4151187742020NULL
33062Marseille CanebièreFranceHugo Robert4446942752019NULL
33085Chicago LoopUnited StatesHarper Taylor5502567032019NULL
33091Paris OpéraFranceLucas Dubois4556410662020NULL
331010Hangzhou XihuChinaYang Sun6213330182021NULL
331110Chengdu JinjiangChinaWei Zhao5404544942021NULL
331228Amsterdam ZuidasNetherlandsNoah Jansen4022763342020NULL
331327Sydney Martin PlaceAustraliaMia Jones5542871082020NULL
331412Birmingham New StUnited KingdomHarry Smith4687533892022NULL
331513Edinburgh Princes StUnited KingdomGrace Johnson3741219882022NULL
33167Denver Union StationUnited StatesMia Smith44967122122023NULL
331729Eindhoven StratumseindNetherlandsSem de Jong4330890922021Google Pay
33187Seattle Pike PlaceUnited StatesLogan Smith53268635122020NULL
331911London Canary WharfUnited KingdomHarry Johnson5239028582022NULL
332131Kraków RynekPolandHanna Lewandowski5426310062022Google Pay
33226Boston Back BayUnited StatesMia Jones5597568182020Apple 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;