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,551–4,575 of 4,762

card_payment, page 183 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
51781Nantes CommerceFranceJules Moreau5416701582020NULL
517914Torino CentroItalyAlessandro Colombo4807302242022NULL
51803Rennes RépubliqueFranceLéa Laurent5129314742022NULL
51817Seattle Pike PlaceUnited StatesEmma Anderson3714913562023Google Pay
51821Nantes CommerceFranceJules Bernard4707749552020NULL
518316Sevilla TrianaSpainLucía García42922761102022Apple Pay
51845Manhattan MidtownUnited StatesJames Jones5420509062021NULL
518522Osaka UmedaJapanYui Watanabe3572605772023Apple Pay
518625Incheon SongdoSouth KoreaSeo-yeon Jung44918853102024NULL
518826Adelaide Rundle MallAustraliaOliver Brown3772269062020NULL
51904Strasbourg KléberFranceCamille Martin4111792212021Apple Pay
51915Austin DowntownUnited StatesMason Miller53456253122023NULL
51921Nantes CommerceFranceHugo Laurent53570538112023NULL
519333Bergen BryggenNorwayEmil Nilsen4609911782022NULL
51945Chicago LoopUnited StatesMason Miller5407346442020NULL
51952Marseille CanebièreFranceLouis Leroy4159221022021Google Pay
51961Paris OpéraFranceManon Bernard5549792582024NULL
51974Strasbourg KléberFranceLucas Thomas45464953112024NULL
51984Paris LouvreFranceLéa Bernard5212499412022NULL
519915Firenze Santa Maria NovellaItalyAlessandro Colombo5533526682024NULL
52003Rennes RépubliqueFranceLéa Laurent5198803312021NULL
52019Guangzhou TianheChinaYang Huang4812688052022NULL
520218Frankfurt TaunusanlageGermanyPaul Schmidt53496210122021NULL
520322Tokyo MarunouchiJapanAoi Suzuki40680621102023Google Pay
520425Seoul GangnamSouth KoreaSu-ah Kang4601219832023NULL
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;