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,926–3,950 of 4,762

card_payment, page 158 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
450017Barcelona EixampleSpainPaula Pérez4213615612020NULL
450223Kyoto ShijoJapanRen Sato3576061642020NULL
450310Chengdu JinjiangChinaJun Zhou6209229942023NULL
45041Paris OpéraFranceLouis Martin4424465962024Apple Pay
45065Austin DowntownUnited StatesMia Johnson5100127172021NULL
45077Seattle Pike PlaceUnited StatesJames Davis3745638082020Apple Pay
45084Strasbourg KléberFranceZoé Laurent5120755452021NULL
45095Chicago LoopUnited StatesLogan Miller5102855672023Google Pay
451025Seoul GangnamSouth KoreaJi-woo Cho4058824812021NULL
451112Birmingham New StUnited KingdomAmelia Johnson4862811652020NULL
451214Milano DuomoItalyAurora Ferrari4632876182020NULL
45135Chicago LoopUnited StatesEthan Brown41359966102023NULL
45147Seattle Pike PlaceUnited StatesEthan Brown5279605792024NULL
451528Rotterdam CoolsingelNetherlandsJulia Visser4361795682023NULL
45166Boston Back BayUnited StatesJames Garcia53257732122022NULL
451711London Canary WharfUnited KingdomLily Jones54101865102021NULL
45182Paris La DéfenseFranceHugo Robert4333110152020NULL
451931Kraków RynekPolandJakub Kowalski4312054632024NULL
452114Milano DuomoItalyBeatrice Marino4957016982023NULL
452218Berlin Unter den LindenGermanyHannah Müller4111028192023NULL
452315Roma TerminiItalyFrancesco Bianchi4521232752020NULL
45242Lille Grand PlaceFranceCamille Thomas4939689952024NULL
452511Manchester Market StUnited KingdomLily Jones5142101562021NULL
45266Atlanta MidtownUnited StatesMia Brown40802049112023NULL
452720São Paulo PaulistaBrazilLaura Silva5305308812024NULL
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;