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

card_payment, page 121 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
349432Stockholm Sergels TorgSwedenLucas Larsson4984736362023NULL
349517Bilbao AbandoSpainValeria Fernández4842559662020NULL
34964Paris LouvreFranceChloé Simon4904506132021NULL
34979Shenzhen FutianChinaJun Zhao6298149772020Google Pay
34983Bordeaux ChartronsFranceJules Martin4012364332019NULL
34997Seattle Pike PlaceUnited StatesElla Anderson4991017552021NULL
35009Shenzhen FutianChinaTao Sun4881098672023NULL
350110Hangzhou XihuChinaWei Xu4040776132022NULL
35022Marseille CanebièreFranceManon Durand5482009372022NULL
350316Madrid Gran VíaSpainPablo García4301729492023NULL
350516Madrid Gran VíaSpainÁlvaro Sánchez5549934022023NULL
35069Shenzhen FutianChinaJun Zhao4317705052022NULL
350733Oslo BjørvikaNorwayElla Hansen4645966072020NULL
350923Yokohama MinatomiraiJapanAoi Tanaka43453823112020NULL
35109Shenzhen FutianChinaTao Zhang4833731322023NULL
35113Toulouse CapitoleFranceGabriel Lefebvre40463589102023NULL
35124Paris LouvreFranceChloé Thomas4673785862019NULL
35135Manhattan MidtownUnited StatesLiam Williams54511852102021NULL
351411Manchester Market StUnited KingdomAva Williams4013678322019NULL
351614Torino CentroItalyAurora Greco40563610112021NULL
351823Yokohama MinatomiraiJapanSota Yamamoto4176949742023NULL
351923Yokohama MinatomiraiJapanHaruto Tanaka5527820492019NULL
352023Kyoto ShijoJapanSota Yamamoto4831535072022NULL
35216San Francisco Market StUnited StatesNoah Anderson4493801752020NULL
35245Austin DowntownUnited StatesHarper Davis3738891572022NULL
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;