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 2,726–2,750 of 4,762

card_payment, page 110 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
31821Nantes CommerceFranceChloé Dubois4852091882020NULL
318327Sydney Martin PlaceAustraliaMia Brown5583582262019NULL
318426Adelaide Rundle MallAustraliaMia Brown4268000032022NULL
318513Edinburgh Princes StUnited KingdomGeorge Smith4143023272023NULL
318618Berlin Unter den LindenGermanyFinn Koch4612397162020NULL
31874Paris LouvreFranceCamille Dubois4977913872020NULL
318927Brisbane Queen StAustraliaJack Wilson5437082622019NULL
319115Roma TerminiItalyFrancesco Bianchi42741244122023NULL
31923Rennes RépubliqueFranceInès Martin4026789622022Apple Pay
319310Chengdu JinjiangChinaJing Zhou5117281122019NULL
319414Torino CentroItalyGinevra Colombo4782855382019NULL
31954Paris LouvreFranceZoé Dubois5148555582022NULL
31966Atlanta MidtownUnited StatesAva Moore4320640042021NULL
31976San Francisco Market StUnited StatesEmma Smith5281471212021NULL
319821Brasília Asa SulBrazilArthur Silva5185804682021NULL
319916Sevilla TrianaSpainDaniel López4950393752022NULL
320013Bristol Corn StUnited KingdomGrace Brown5530409982022NULL
320111London Canary WharfUnited KingdomGrace Brown5575309532020NULL
32024Paris LouvreFranceArthur Petit4208398582021NULL
32032Paris La DéfenseFranceLéa Bernard5313950972019NULL
320611London Canary WharfUnited KingdomGeorge Davies43494870122022Google Pay
320721Belo Horizonte SavassiBrazilArthur Silva5489652022021NULL
320821Brasília Asa SulBrazilArthur Silva45544455122019NULL
32096San Francisco Market StUnited StatesHarper Moore5298016132019NULL
321130Saint Petersburg NevskyRussiaIvan Kuznetsov5583029512019NULL
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;