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 876–900 of 4,762

card_payment, page 36 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
106224Busan SeomyeonSouth KoreaMin-jun Park41559828122020NULL
10633Toulouse CapitoleFranceCamille Simon5208426362020NULL
106422Tokyo MarunouchiJapanSota Takahashi4038741542017NULL
106513Edinburgh Princes StUnited KingdomAlfie Brown4451044832019NULL
106629Utrecht CentrumNetherlandsEmma Visser4983447852019NULL
106729Eindhoven StratumseindNetherlandsEmma de Jong4089687942019NULL
106923Yokohama MinatomiraiJapanSota Takahashi4118705952020Apple Pay
10701Paris OpéraFranceGabriel Dubois5476117792018NULL
107228Rotterdam CoolsingelNetherlandsEmma de Jong5143536812021NULL
107424Busan SeomyeonSouth KoreaMin-jun Kim4542028782021NULL
10751Paris OpéraFranceManon Dubois4861742642021NULL
10765Manhattan MidtownUnited StatesNoah Wilson4349415512020NULL
10776Boston Back BayUnited StatesAva Garcia5512371292020NULL
10787Seattle Pike PlaceUnited StatesAva Smith5511064452020NULL
10796Boston Back BayUnited StatesNoah Taylor5587465212017NULL
10807Denver Union StationUnited StatesNoah Taylor44629728122018NULL
10817Denver Union StationUnited StatesAva Garcia4885994472019NULL
10825Manhattan MidtownUnited StatesLiam Moore4113216152017NULL
108334Tampere HämeenkatuFinlandLeo Laine5435732732018NULL
10845Austin DowntownUnited StatesElla Miller5412258692017NULL
108517Barcelona EixampleSpainLucía Martínez4807598992020NULL
108623Kyoto ShijoJapanRen Nakamura3520398532021Apple Pay
10877Seattle Pike PlaceUnited StatesAva Johnson4071829472018NULL
108915Firenze Santa Maria NovellaItalyBeatrice Ferrari48854828122018NULL
10902Lille Grand PlaceFranceInès Durand4760753732021NULL
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;