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 126–150 of 4,762

card_payment, page 6 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
1452Marseille CanebièreFranceArthur Martin42886267122016NULL
14617Barcelona EixampleSpainPaula Gómez4918860472017NULL
1473Rennes RépubliqueFranceLucas Petit4367232132017NULL
1481Paris OpéraFranceJules Thomas4645690272020NULL
14911London Canary WharfUnited KingdomAlfie Taylor52506868102017NULL
15013Edinburgh Princes StUnited KingdomHarry Johnson49511899112019NULL
1514Strasbourg KléberFranceZoé Dubois5453816712020Apple Pay
1525Austin DowntownUnited StatesJames Brown5401690422017NULL
1533Toulouse CapitoleFranceArthur Martin45901894122018NULL
15411Manchester Market StUnited KingdomJack Williams4798345092016NULL
15533Bergen BryggenNorwayEmma Olsen4948817352018NULL
15619München MarienplatzGermanyLea Wagner4905033042018NULL
15714Torino CentroItalySofia Colombo5163526792018NULL
15810Hangzhou XihuChinaYan Wang4134603772019Google Pay
15918Berlin Unter den LindenGermanyBen Schmidt4400918332016NULL
16010Chengdu JinjiangChinaYan Wang4991465642018Apple Pay
16117Barcelona EixampleSpainHugo Gómez53331674112016NULL
1628Shanghai PudongChinaTao Wu4399535262020NULL
1639Guangzhou TianheChinaWei Wang43455017112020NULL
1642Marseille CanebièreFranceJules Thomas6291858292016NULL
16616Sevilla TrianaSpainPaula Rodríguez4935397682018NULL
16718Frankfurt TaunusanlageGermanyLeon Wagner44967109122019NULL
1689Guangzhou TianheChinaMin Li5273086282018NULL
16923Kyoto ShijoJapanHina Tanaka4090613092019NULL
1706Atlanta MidtownUnited StatesEmma Davis37104731122020NULL
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;