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 3,301–3,325 of 4,762

card_payment, page 133 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
38303Rennes RépubliqueFranceLouis Laurent4726751512023NULL
38313Bordeaux ChartronsFranceInès Leroy4312413032021NULL
38324Strasbourg KléberFranceGabriel Martin5344172622019NULL
383315Roma TerminiItalyAlessandro Esposito5421349132019NULL
38346San Francisco Market StUnited StatesHarper Wilson4284224682019NULL
383512Leeds BriggateUnited KingdomAva Davies4337878482023NULL
38362Lille Grand PlaceFranceCamille Leroy49311307102020NULL
383720São Paulo PaulistaBrazilValentina Santos5142980282019NULL
383835Toronto Bay StCanadaCharlotte Smith51226090112020NULL
38394Paris LouvreFranceCamille Petit51449304112020NULL
38402Lille Grand PlaceFranceInès Lefebvre5168293562023NULL
38425Chicago LoopUnited StatesHarper Moore5586179252021NULL
384330Saint Petersburg NevskyRussiaAlexander Popov4025192852022NULL
384430Saint Petersburg NevskyRussiaAlexander Kuznetsov5525799042020NULL
384711Manchester Market StUnited KingdomAmelia Patel47863792102023NULL
384915Firenze Santa Maria NovellaItalyFrancesco Greco5104299452020NULL
38502Paris La DéfenseFranceArthur Petit4460098382019NULL
385118Frankfurt TaunusanlageGermanyPaul Koch4527546462021NULL
385216Sevilla TrianaSpainValeria Fernández54136083112020NULL
38538Beijing XidanChinaLei Yang62560064102021NULL
385432Stockholm Sergels TorgSwedenOscar Larsson53717730102020NULL
38551Paris OpéraFranceManon Petit41325386122021NULL
385725Seoul GangnamSouth KoreaSu-ah Kim43622737122021NULL
38581Paris OpéraFranceZoé Robert4959471782020NULL
38596San Francisco Market StUnited StatesElla Smith41687466112019NULL
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;