Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Rows 826–850 of 4,762

card_payment, page 34 of 191
payment_id→ payment.payment_id	institution_id→ financial_institution.institution_id	issuing_branchTEXT	issued_countryTEXT	account_nameTEXT	card_first4TEXT	card_last4TEXT	expiry_monthINTEGER	expiry_yearINTEGER	walletTEXT
1006	26	Melbourne Collins St	Australia	Jack Brown	4351	9253	2	2020	NULL
1007	3	Bordeaux Chartrons	France	Chloé Petit	4444	4990	4	2017	NULL
1010	21	Brasília Asa Sul	Brazil	Valentina Oliveira	4499	6599	10	2020	NULL
1012	16	Sevilla Triana	Spain	Pablo Pérez	4783	4681	1	2017	NULL
1013	4	Strasbourg Kléber	France	Inès Robert	4532	5725	9	2018	NULL
1014	2	Paris La Défense	France	Zoé Leroy	4321	2549	4	2019	Apple Pay
1015	12	Leeds Briggate	United Kingdom	Isla Evans	4103	2461	10	2018	NULL
1016	3	Rennes République	France	Camille Moreau	4406	8924	6	2021	NULL
1017	5	Manhattan Midtown	United States	Harper Johnson	5321	4388	2	2017	NULL
1018	4	Paris Louvre	France	Lucas Leroy	4137	5155	11	2019	NULL
1020	6	Boston Back Bay	United States	Noah Moore	5466	1524	4	2017	NULL
1021	1	Paris Opéra	France	Arthur Dubois	5333	2251	1	2020	NULL
1022	2	Paris La Défense	France	Arthur Dubois	5144	8555	2	2019	NULL
1023	25	Seoul Gangnam	South Korea	Min-jun Kim	5322	8921	2	2018	NULL
1024	3	Bordeaux Chartrons	France	Lucas Dubois	5270	6676	5	2021	NULL
1025	7	Seattle Pike Place	United States	Mason Anderson	4669	6915	12	2017	NULL
1026	29	Eindhoven Stratumseind	Netherlands	Julia de Jong	5329	4005	3	2018	NULL
1027	4	Strasbourg Kléber	France	Gabriel Laurent	4319	0710	10	2018	NULL
1028	1	Paris Opéra	France	Arthur Dubois	4918	7270	12	2021	NULL
1029	4	Paris Louvre	France	Lucas Dubois	4419	1405	10	2021	NULL
1030	23	Kyoto Shijo	Japan	Ren Sato	5200	3229	9	2020	NULL
1031	28	Rotterdam Coolsingel	Netherlands	Daan de Vries	5259	5243	6	2020	NULL
1032	10	Hangzhou Xihu	China	Hao Xu	5459	4720	6	2019	NULL
1033	7	Denver Union Station	United States	Noah Wilson	5331	7617	9	2021	NULL
1034	8	Shanghai Pudong	China	Fang Chen	4601	4880	11	2020	NULL

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;