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,276–2,300 of 4,762

card_payment, page 92 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
26926San Francisco Market StUnited StatesJames Brown4916846612022NULL
269326Adelaide Rundle MallAustraliaCharlotte Jones4243940812020NULL
269424Busan SeomyeonSouth KoreaJi-woo Kim53034230122020NULL
26957Seattle Pike PlaceUnited StatesEmma Anderson5320487892022NULL
269610Chengdu JinjiangChinaJun Li4701455582020NULL
269715Firenze Santa Maria NovellaItalyLeonardo Ferrari5158765412019NULL
26984Paris LouvreFranceGabriel Leroy54894736102019Apple Pay
26995Chicago LoopUnited StatesJames Wilson5366263362022NULL
27009Shenzhen FutianChinaHao Zhao6236317552019Apple Pay
270213Bristol Corn StUnited KingdomGeorge Evans3747294732019NULL
27039Shenzhen FutianChinaJun Sun4110550252020NULL
27054Strasbourg KléberFranceInès Moreau4956238932019NULL
270625Seoul GangnamSouth KoreaSeo-jun Kim4862145212020Apple Pay
27082Lille Grand PlaceFranceGabriel Robert5263366592021NULL
27092Paris La DéfenseFranceJules Laurent4569164372021NULL
27104Strasbourg KléberFranceManon Moreau5174648132021NULL
271120São Paulo PaulistaBrazilDavi Santos5360311382018NULL
27124Paris LouvreFranceGabriel Laurent4746743872020NULL
27144Strasbourg KléberFranceArthur Durand5362275032018NULL
27154Strasbourg KléberFranceGabriel Dubois5565868922018NULL
271616Sevilla TrianaSpainPablo López4528675342020Apple Pay
271831Kraków RynekPolandHanna Lewandowski4120067942018NULL
27191Paris OpéraFranceArthur Laurent5133417092022NULL
27203Rennes RépubliqueFranceInès Durand4938240392022NULL
272126Melbourne Collins StAustraliaRuby Jones3726814662021NULL
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;