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 51–75 of 4,762

card_payment, page 3 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
5828Amsterdam ZuidasNetherlandsNoah de Jong53204204122017NULL
5915Firenze Santa Maria NovellaItalyLorenzo Marino5216654332017NULL
6031Warszawa ŚródmieściePolandAntoni Kamiński4696085772017NULL
616Atlanta MidtownUnited StatesMia Taylor52162836102020NULL
622Paris La DéfenseFranceArthur Leroy5101116772019NULL
6313Edinburgh Princes StUnited KingdomAmelia Taylor5261543642017NULL
646San Francisco Market StUnited StatesLogan Williams4203917182016NULL
6619Hamburg JungfernstiegGermanyPaul Koch5318442382017NULL
685Chicago LoopUnited StatesEmma Brown5439979852016NULL
6920Rio CentroBrazilHeitor Alves4869641692020NULL
7021Belo Horizonte SavassiBrazilHeitor Alves4327150792019NULL
714Strasbourg KléberFranceGabriel Simon4898995362016NULL
726San Francisco Market StUnited StatesHarper Jones5479015322018NULL
7321Brasília Asa SulBrazilHelena Santos5110654392019NULL
7410Chengdu JinjiangChinaLei Zhao4768897542019NULL
758Shanghai PudongChinaWei Sun62302250122019NULL
7612Leeds BriggateUnited KingdomOliver Wilson4703719082020NULL
772Marseille CanebièreFranceJules Leroy4083246772018NULL
791Nantes CommerceFranceLéa Robert4255674152018NULL
8129Eindhoven StratumseindNetherlandsNoah de Jong42961473112019Google Pay
826Atlanta MidtownUnited StatesMia Moore4192391482019NULL
845Manhattan MidtownUnited StatesJames Wilson4116397012017NULL
8526Adelaide Rundle MallAustraliaCharlotte Williams4587815272017Apple Pay
8626Adelaide Rundle MallAustraliaCharlotte Williams5301079212020NULL
8735Montréal Ville-MarieCanadaNoah Gagnon4062275072019NULL
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;