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,201–2,225 of 4,762

card_payment, page 89 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
26056San Francisco Market StUnited StatesLiam Taylor5462806662020NULL
260624Busan SeomyeonSouth KoreaJi-woo Jung4142340232018NULL
260720São Paulo PaulistaBrazilHelena Souza5362232612021Google Pay
26094Paris LouvreFranceZoé Simon4795141222021NULL
261110Chengdu JinjiangChinaLin Zhou6252673332018NULL
26123Rennes RépubliqueFranceZoé Simon4595703342018Apple Pay
26137Seattle Pike PlaceUnited StatesMason Taylor5381958822018NULL
261419Hamburg JungfernstiegGermanyLeon Müller5574605382021NULL
26155Manhattan MidtownUnited StatesLogan Moore55686911122020NULL
26165Manhattan MidtownUnited StatesMia Smith5156713712021NULL
261729Eindhoven StratumseindNetherlandsSophie Meijer5219686352022NULL
261817Barcelona EixampleSpainHugo López5356481022021NULL
26193Bordeaux ChartronsFranceZoé Petit51753231102021NULL
262033Bergen BryggenNorwayEmil Kristiansen4981928322022NULL
26233Toulouse CapitoleFranceHugo Bernard5180704232018NULL
262511London Canary WharfUnited KingdomOliver Johnson44707246122019NULL
26262Marseille CanebièreFranceLucas Petit4073002412020Apple Pay
26274Strasbourg KléberFranceLouis Martin5133575882020NULL
262834Tampere HämeenkatuFinlandLeo Korhonen47437907112019NULL
26294Strasbourg KléberFranceLucas Dubois48704995112020NULL
26307Seattle Pike PlaceUnited StatesMason Johnson4660304282019NULL
26314Paris LouvreFranceHugo Thomas5467755942019NULL
263212Leeds BriggateUnited KingdomGrace Williams5117701872021Apple Pay
263313Bristol Corn StUnited KingdomSophie Patel5386212052018Apple Pay
263417Barcelona EixampleSpainMartina Rodríguez5505247072020NULL
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;