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

card_payment, page 150 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
42931Nantes CommerceFranceArthur Thomas47200563122022NULL
429423Yokohama MinatomiraiJapanHaruto Nakamura3507400052024NULL
429525Seoul GangnamSouth KoreaHa-eun Kang4189996552023NULL
42963Toulouse CapitoleFranceCamille Bernard47803524112022NULL
429711Manchester Market StUnited KingdomIsla Johnson43953586102023Apple Pay
429825Seoul GangnamSouth KoreaMin-jun Yoon5507808142021NULL
43016Atlanta MidtownUnited StatesLiam Anderson5262090532021NULL
430218Berlin Unter den LindenGermanyElias Schneider4970976352023NULL
43033Rennes RépubliqueFranceHugo Simon4915673372020Google Pay
43044Strasbourg KléberFranceLucas Simon44604619122023NULL
43056San Francisco Market StUnited StatesLogan Jones47680212122022NULL
43066Boston Back BayUnited StatesElla Wilson55274966102022NULL
43071Paris OpéraFranceManon Dubois4662678852024Apple Pay
43089Shenzhen FutianChinaTao Sun62768407102023Apple Pay
43093Bordeaux ChartronsFranceLéa Bernard5273143842021NULL
43104Paris LouvreFranceManon Martin5425558792024NULL
43112Marseille CanebièreFranceLouis Durand4885612052022NULL
43126Atlanta MidtownUnited StatesLiam Davis4679504812023Apple Pay
43139Guangzhou TianheChinaJun Wu6255612462021NULL
431419Hamburg JungfernstiegGermanyLina Meyer5448551992021NULL
431526Adelaide Rundle MallAustraliaOliver Williams4954414242020NULL
43163Rennes RépubliqueFranceCamille Leroy5409189762024NULL
43178Beijing XidanChinaHao Xu46524680122023NULL
431826Melbourne Collins StAustraliaRuby Brown5144153192021NULL
431915Roma TerminiItalyLorenzo Bianchi51154233112021NULL
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;