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 4,051–4,075 of 4,762

card_payment, page 163 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
46344Paris LouvreFranceLucas Simon4114122682020NULL
46357Seattle Pike PlaceUnited StatesJames Garcia5370854492024NULL
46368Shanghai PudongChinaJing Wang62077663122022NULL
46375Chicago LoopUnited StatesEthan Williams5157435882020NULL
46399Shenzhen FutianChinaYan Yang5259777812024NULL
464010Hangzhou XihuChinaHao Li62664929122022NULL
46419Guangzhou TianheChinaHao Li62926360112021NULL
46422Marseille CanebièreFranceHugo Simon5415687572020NULL
46436San Francisco Market StUnited StatesMason Johnson37080948112020NULL
464417Bilbao AbandoSpainPablo Fernández4675391562020NULL
46457Seattle Pike PlaceUnited StatesJames Garcia54310410122021NULL
46479Shenzhen FutianChinaYang Zhou6230707752022NULL
46481Nantes CommerceFranceArthur Durand4368015342021NULL
464927Brisbane Queen StAustraliaIsla Smith37606411122023NULL
465031Kraków RynekPolandJakub Kowalczyk5248060912021NULL
465112Leeds BriggateUnited KingdomGrace Taylor4346117652022NULL
465213Bristol Corn StUnited KingdomGrace Taylor4991340882023NULL
46537Seattle Pike PlaceUnited StatesMia Anderson4937479292020NULL
46547Seattle Pike PlaceUnited StatesAva Davis4673998552020NULL
46552Paris La DéfenseFranceLucas Durand4841787612022NULL
465718Frankfurt TaunusanlageGermanyHannah Becker4324221062021NULL
465816Madrid Gran VíaSpainPaula López5435355042022NULL
465925Incheon SongdoSouth KoreaJi-woo Park5192023362024NULL
466013Edinburgh Princes StUnited KingdomGrace Taylor3783737232021NULL
466231Warszawa ŚródmieściePolandHanna Kowalczyk5181679052020Google 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;