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,976–2,000 of 4,762

card_payment, page 80 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
23434Paris LouvreFranceManon Bernard5112389352021NULL
234410Chengdu JinjiangChinaLin Wu4264737582019NULL
23451Nantes CommerceFranceCamille Thomas49379965122022NULL
23463Bordeaux ChartronsFranceGabriel Lefebvre4045883052020NULL
234714Torino CentroItalyFrancesco Marino5141350052019NULL
23485Chicago LoopUnited StatesEthan Smith48349616122018NULL
23494Strasbourg KléberFranceGabriel Lefebvre52504304102022NULL
23502Paris La DéfenseFranceLéa Lefebvre5263175812020NULL
235128Rotterdam CoolsingelNetherlandsJulia Jansen4927570432019NULL
235219Hamburg JungfernstiegGermanyBen Koch41643863122022NULL
23531Lyon BellecourFranceCamille Thomas5278633272019Apple Pay
235532Göteborg AvenynSwedenHugo Nilsson5260347762018NULL
235617Barcelona EixampleSpainPaula López5283137062018NULL
23577Denver Union StationUnited StatesLiam Johnson3796191442020NULL
23585Manhattan MidtownUnited StatesElla Davis55908617112020NULL
235925Incheon SongdoSouth KoreaDo-yun Park5237768262020NULL
236124Seoul YeouidoSouth KoreaDo-yun Park5150650522020NULL
236314Torino CentroItalySofia Romano53465340122020NULL
23641Nantes CommerceFranceGabriel Thomas5167984852020Google Pay
236523Yokohama MinatomiraiJapanHaruto Suzuki35262327122018NULL
236628Rotterdam CoolsingelNetherlandsNoah Smit54270082102021NULL
236718Frankfurt TaunusanlageGermanyLeon Hoffmann51456394112018NULL
23692Paris La DéfenseFranceCamille Petit4409066362021NULL
23701Lyon BellecourFranceArthur Leroy5456684912019NULL
237215Roma TerminiItalyFrancesco Marino4432041442020NULL
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;