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 4,701–4,725 of 4,762

card_payment, page 189 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
534624Seoul YeouidoSouth KoreaHa-eun Kang42898420102025NULL
534731Warszawa ŚródmieściePolandJulia Wiśniewski4672048872023Google Pay
534816Madrid Gran VíaSpainÁlvaro Fernández4229562612023NULL
534931Kraków RynekPolandJan Kowalczyk4368997772021NULL
535031Kraków RynekPolandJulia Wiśniewski4391023252023NULL
535110Hangzhou XihuChinaWei Zhang62402936122024NULL
535422Osaka UmedaJapanHaruto Sato3584994142023NULL
535514Milano DuomoItalyGiulia Ferrari5336126582021NULL
535614Torino CentroItalyGiulia Ferrari41294915112025NULL
535714Milano DuomoItalyGiulia Ferrari4943802442023NULL
53582Lille Grand PlaceFranceCamille Lefebvre4170228452022NULL
535930Moscow TverskayaRussiaMaria Sokolov4613840462022Apple Pay
536027Brisbane Queen StAustraliaJack Williams51856407122022NULL
536211Manchester Market StUnited KingdomGrace Walker4588539012022NULL
536310Hangzhou XihuChinaYang Chen6283216362023NULL
53647Denver Union StationUnited StatesLiam Wilson3760509172025Apple Pay
536531Kraków RynekPolandZuzanna Zieliński4832502292024NULL
536627Sydney Martin PlaceAustraliaWilliam Ryan4456050842022Google Pay
53675Austin DowntownUnited StatesJames Miller4675595932025Google Pay
53684Paris LouvreFranceZoé Simon4271741842021Google Pay
53695Manhattan MidtownUnited StatesEmma Jones5460521592024NULL
537020Rio CentroBrazilHelena Oliveira5338453092021NULL
53716Boston Back BayUnited StatesMason Taylor4440600632022NULL
537235Montréal Ville-MarieCanadaLiam Martin4112245852021Google Pay
53736San Francisco Market StUnited StatesHarper Taylor3701730562025NULL
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;