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,001–1,025 of 4,762

card_payment, page 41 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
120623Kyoto ShijoJapanSakura Watanabe5435241022018NULL
120724Seoul YeouidoSouth KoreaSeo-yeon Park49733353112018NULL
12084Strasbourg KléberFranceLéa Moreau44311495102021NULL
12091Paris OpéraFranceInès Leroy4883092152017NULL
12102Paris La DéfenseFranceGabriel Moreau44333427122021NULL
121220Rio CentroBrazilAlice Rodrigues4801507462018NULL
12138Shanghai PudongChinaLei Zhou4412225212018NULL
12151Nantes CommerceFranceChloé Lefebvre55200510122018NULL
12168Shanghai PudongChinaTao Chen6289927522017NULL
12187Denver Union StationUnited StatesLiam Davis5435936422020Google Pay
12191Paris OpéraFranceZoé Simon4341905972017Google Pay
12207Denver Union StationUnited StatesJames Wilson51679339122019NULL
12218Shanghai PudongChinaLei Zhou42137373122018Google Pay
122334Tampere HämeenkatuFinlandSofia Hämäläinen4558237522020NULL
122434Helsinki AleksanterinkatuFinlandSofia Hämäläinen4433728392019NULL
122521Brasília Asa SulBrazilAlice Rodrigues4839990982020NULL
12267Seattle Pike PlaceUnited StatesAva Brown46741517112018NULL
122710Chengdu JinjiangChinaJun Chen6220390882020NULL
12284Paris LouvreFranceArthur Bernard4325559472019NULL
122921Brasília Asa SulBrazilAlice Oliveira5509178722021NULL
123027Brisbane Queen StAustraliaCharlotte Ryan4455027022018Google Pay
123129Eindhoven StratumseindNetherlandsJulia Bakker49928911122020NULL
123221Brasília Asa SulBrazilHelena Pereira4978050922021NULL
123325Incheon SongdoSouth KoreaMin-jun Lee5221967692018NULL
123419Hamburg JungfernstiegGermanyElias Schmidt4040103582021NULL
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;