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,526–1,550 of 4,762

card_payment, page 62 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
18243Bordeaux ChartronsFranceLéa Martin4932958662017NULL
18252Paris La DéfenseFranceArthur Thomas4948156842021NULL
18261Paris OpéraFranceGabriel Lefebvre4556683362017NULL
18273Toulouse CapitoleFranceLéa Bernard5302587042019NULL
18286San Francisco Market StUnited StatesElla Wilson5140558912020NULL
18295Austin DowntownUnited StatesMia Moore40899068122021NULL
18309Guangzhou TianheChinaMin Yang5458008262017NULL
18311Lyon BellecourFranceChloé Durand47124327102018NULL
183216Sevilla TrianaSpainPablo Martínez41920386112021NULL
183314Milano DuomoItalyAlessandro Romano4290102912019NULL
18343Rennes RépubliqueFranceManon Moreau55218284112019NULL
18352Marseille CanebièreFranceGabriel Lefebvre5126735262019NULL
18362Marseille CanebièreFranceLucas Petit5137122892018NULL
18377Denver Union StationUnited StatesEthan Brown4252178072021NULL
18385Chicago LoopUnited StatesLogan Davis4005276582019NULL
18394Paris LouvreFranceLucas Bernard41835281122019NULL
184014Milano DuomoItalyAlessandro Romano4541837822018NULL
184212Leeds BriggateUnited KingdomGeorge Jones53338088102018NULL
184428Rotterdam CoolsingelNetherlandsLucas van den Berg5529963562020NULL
18454Strasbourg KléberFranceArthur Martin4907462192021NULL
18463Toulouse CapitoleFranceChloé Durand44388467102020NULL
18476Atlanta MidtownUnited StatesJames Moore5497677852020NULL
18484Paris LouvreFranceLouis Moreau4754950282019Apple Pay
18492Lille Grand PlaceFranceChloé Lefebvre44376907112021NULL
185027Sydney Martin PlaceAustraliaCharlotte Nguyen55471842122022NULL
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;