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 451–475 of 4,762

card_payment, page 19 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
5487Seattle Pike PlaceUnited StatesLiam Moore44314449102016Apple Pay
5495Manhattan MidtownUnited StatesLiam Moore41345038102016NULL
55027Sydney Martin PlaceAustraliaMia Ryan4531696442020NULL
5517Denver Union StationUnited StatesNoah Anderson5533243712017NULL
55226WoolloomoolooAustraliaMia Ryan5223571142020NULL
55316Madrid Gran VíaSpainLucía García45950852122020NULL
55422Osaka UmedaJapanRen Yamamoto4714579742016NULL
5551Paris OpéraFranceInès Dubois5235714182019NULL
5563Rennes RépubliqueFranceInès Dubois4555965742018NULL
5585Chicago LoopUnited StatesAva Smith5511131452019NULL
55911London Canary WharfUnited KingdomAmelia Evans51292156122018Apple Pay
5601Paris OpéraFranceArthur Dubois4148083952017NULL
56231Kraków RynekPolandJulia Wiśniewski4667083152019NULL
5635Chicago LoopUnited StatesEthan Garcia54034370122019NULL
56429Utrecht CentrumNetherlandsSem Smit46255259122018NULL
56514Milano DuomoItalyFrancesco Bianchi4579945972017NULL
56631Warszawa ŚródmieściePolandAntoni Wójcik4494973012017Google Pay
56711Manchester Market StUnited KingdomSophie Johnson5474344792019NULL
5687Seattle Pike PlaceUnited StatesEthan Williams40988986112016NULL
5691Paris OpéraFranceLouis Petit54328049102017NULL
57030Saint Petersburg NevskyRussiaAnastasia Morozov4675470792018NULL
57124Seoul YeouidoSouth KoreaJi-woo Lee5260775372019NULL
5733Bordeaux ChartronsFranceCamille Leroy5494559262019NULL
57425Seoul GangnamSouth KoreaDo-yun Yoon5506357932018NULL
5767Seattle Pike PlaceUnited StatesLiam Williams4972823172018NULL
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;