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 326–350 of 4,762

card_payment, page 14 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
3894Paris LouvreFranceGabriel Dubois4918270252020NULL
3901Nantes CommerceFranceChloé Dubois4084158382020NULL
39113Bristol Corn StUnited KingdomLily Johnson55497031122020NULL
39211Manchester Market StUnited KingdomLily Johnson4051285172017NULL
39511Manchester Market StUnited KingdomAmelia Wilson4000175552020Google Pay
39630Saint Petersburg NevskyRussiaIvan Petrov4065620492018NULL
39730Saint Petersburg NevskyRussiaIvan Petrov40109217112017NULL
39830Moscow TverskayaRussiaMaria Morozov5243580632020NULL
3995Manhattan MidtownUnited StatesAva Miller5170379652019NULL
4007Seattle Pike PlaceUnited StatesEmma Smith5561757732019NULL
40112Leeds BriggateUnited KingdomJack Walker55300944102017NULL
4021Paris OpéraFranceZoé Moreau4473278252016NULL
4041Nantes CommerceFranceArthur Robert6237286732018NULL
4062Paris La DéfenseFranceCamille Bernard5478375292019NULL
4076San Francisco Market StUnited StatesAva Anderson3743321152017NULL
4102Marseille CanebièreFranceZoé Petit5417976692018NULL
4126Atlanta MidtownUnited StatesLogan Wilson3707002642020NULL
4137Denver Union StationUnited StatesEthan Taylor4215212682017NULL
4156Atlanta MidtownUnited StatesHarper Jones5206777712020NULL
4165Manhattan MidtownUnited StatesEthan Garcia4726630332016NULL
4181Lyon BellecourFranceZoé Moreau4467902412018Google Pay
42023Yokohama MinatomiraiJapanYuto Nakamura3572346182020NULL
42211Manchester Market StUnited KingdomSophie Jones4154176812020NULL
4231Paris OpéraFranceZoé Petit5451188622017NULL
4241Paris OpéraFranceCamille Moreau4732183472019NULL
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;