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

card_payment, page 58 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
16985Manhattan MidtownUnited StatesLogan Anderson5182815712021NULL
16997Denver Union StationUnited StatesLogan Williams5102430422017NULL
17008Shanghai PudongChinaXin Zhao5205274852017NULL
170123Yokohama MinatomiraiJapanYui Yamamoto41280658112019NULL
17028Beijing XidanChinaYang Yang6200974882019NULL
170410Hangzhou XihuChinaXin Sun45500482112017Apple Pay
17054Strasbourg KléberFranceManon Moreau5137058372021NULL
17065Manhattan MidtownUnited StatesNoah Miller5536069842020NULL
170712Birmingham New StUnited KingdomIsla Davies4807182482021NULL
170811Manchester Market StUnited KingdomIsla Davies5175262482017NULL
17095Manhattan MidtownUnited StatesLiam Brown37748816112020Apple Pay
17106San Francisco Market StUnited StatesLiam Brown3796576212018NULL
17111Paris OpéraFranceInès Bernard5204283442018NULL
171326WoolloomoolooAustraliaOliver Williams4913670222018NULL
171417Barcelona EixampleSpainDaniel López4437068922018NULL
171529Utrecht CentrumNetherlandsDaan van den Berg47757476122018NULL
171727Sydney Martin PlaceAustraliaMia Brown4249548392021Apple Pay
171921Brasília Asa SulBrazilLaura Oliveira5470108232017NULL
17201Nantes CommerceFranceLéa Bernard5160883142018NULL
172115Roma TerminiItalySofia Russo4959505492021NULL
17225Manhattan MidtownUnited StatesHarper Jones37394659112020NULL
172414Milano DuomoItalyGiulia Ricci4616131182017NULL
17254Paris LouvreFranceLéa Martin4357599642018NULL
17285Austin DowntownUnited StatesEmma Williams5255395382018NULL
17294Strasbourg KléberFranceJules Leroy5480453092021Apple 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;