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 701–725 of 4,762

card_payment, page 29 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
85525Incheon SongdoSouth KoreaJi-woo Kim4529784152018NULL
85623Yokohama MinatomiraiJapanHina Tanaka4086260722019NULL
85726Adelaide Rundle MallAustraliaJack Ryan4963032982018NULL
85830Saint Petersburg NevskyRussiaAnna Popov4802470032016NULL
85915Roma TerminiItalyMatteo Russo4801312522019NULL
8603Bordeaux ChartronsFranceCamille Martin4216608592017NULL
86230Saint Petersburg NevskyRussiaDaria Sokolov4800869482020NULL
8633Rennes RépubliqueFranceCamille Bernard4776377982019NULL
8642Marseille CanebièreFranceChloé Leroy5246020322018NULL
8659Shenzhen FutianChinaYang Zhang6265178732019NULL
86625Seoul GangnamSouth KoreaSeo-jun Kim4818962312018NULL
8677Denver Union StationUnited StatesJames Jones4376110392019NULL
8682Paris La DéfenseFranceZoé Bernard4356713792016NULL
86919München MarienplatzGermanyElias Koch47285447102020NULL
8711Lyon BellecourFranceLouis Lefebvre4421221222020NULL
8733Toulouse CapitoleFranceLucas Laurent4836107232020NULL
8743Toulouse CapitoleFranceLucas Laurent4356346182020NULL
8751Lyon BellecourFranceLéa Durand4533023332018Apple Pay
8765Manhattan MidtownUnited StatesOlivia Anderson37062087112017NULL
87732Göteborg AvenynSwedenHugo Karlsson5256526472018NULL
8785Chicago LoopUnited StatesOlivia Davis3736203772019NULL
88012Birmingham New StUnited KingdomSophie Wright5402927372020NULL
8814Paris LouvreFranceLucas Laurent4995797172018NULL
88214Milano DuomoItalyGinevra Rossi5583719032017NULL
88329Eindhoven StratumseindNetherlandsSem Meijer5508579332018NULL
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;