Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 76–100 of 4,762

card_payment, page 4 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
88	24	Seoul Yeouido	South Korea	Seo-jun Kang	5153	3900	5	2019	NULL
89	13	Edinburgh Princes St	United Kingdom	Ava Wilson	4535	7322	1	2018	NULL
90	25	Seoul Gangnam	South Korea	Ha-eun Lee	4330	7665	3	2019	NULL
91	8	Beijing Xidan	China	Wei Sun	6232	3939	10	2017	NULL
92	14	Milano Duomo	Italy	Matteo Marino	5398	1542	11	2019	NULL
93	18	Frankfurt Taunusanlage	Germany	Lina Schmidt	4458	8841	11	2020	NULL
94	6	San Francisco Market St	United States	James Wilson	4206	1326	1	2017	NULL
95	35	Montréal Ville-Marie	Canada	William Lee	4667	3957	5	2016	NULL
97	22	Osaka Umeda	Japan	Hina Suzuki	4700	9804	3	2018	NULL
98	14	Torino Centro	Italy	Sofia Esposito	5435	2055	12	2020	NULL
99	5	Chicago Loop	United States	Ella Jones	4783	4773	5	2017	NULL
100	28	Amsterdam Zuidas	Netherlands	Lucas Smit	4555	5240	8	2017	NULL
101	28	Amsterdam Zuidas	Netherlands	Sem Smit	5595	8367	6	2017	NULL
102	26	Woolloomooloo	Australia	Isla Williams	4930	9398	3	2018	NULL
103	5	Austin Downtown	United States	Liam Smith	5330	3901	5	2016	NULL
104	11	London Canary Wharf	United Kingdom	Alfie Walker	5195	7488	4	2020	Apple Pay
106	18	Berlin Unter den Linden	Germany	Ben Schneider	4594	5054	11	2016	NULL
107	3	Bordeaux Chartrons	France	Zoé Petit	5357	7034	1	2020	NULL
108	13	Bristol Corn St	United Kingdom	Jack Jones	4768	3299	3	2018	NULL
109	22	Osaka Umeda	Japan	Haruto Ito	3531	4564	10	2016	NULL
110	12	Birmingham New St	United Kingdom	Sophie Jones	4204	9841	6	2020	Apple Pay
111	22	Osaka Umeda	Japan	Haruto Ito	3564	1657	3	2016	NULL
112	11	London Canary Wharf	United Kingdom	Ava Walker	4944	1902	2	2017	NULL
113	30	Moscow Tverskaya	Russia	Mikhail Morozov	4031	3830	11	2020	NULL
114	2	Lille Grand Place	France	Zoé Simon	4631	1355	9	2018	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;