Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 626–650 of 4,762

card_payment, page 26 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
764	12	Birmingham New St	United Kingdom	Harry Williams	3724	5104	10	2018	NULL
765	8	Beijing Xidan	China	Lei Huang	4833	9713	11	2016	NULL
766	26	Woolloomooloo	Australia	Jack Williams	3729	3220	2	2018	NULL
767	18	Frankfurt Taunusanlage	Germany	Leon Hoffmann	4935	7599	3	2017	Apple Pay
768	4	Strasbourg Kléber	France	Chloé Petit	4170	9274	6	2020	NULL
769	5	Austin Downtown	United States	Mason Taylor	4477	4943	8	2016	NULL
770	3	Bordeaux Chartrons	France	Hugo Simon	4767	7489	11	2018	NULL
771	27	Brisbane Queen St	Australia	Jack Williams	4487	6015	2	2016	NULL
772	7	Seattle Pike Place	United States	Ella Jones	4630	2973	3	2016	NULL
773	10	Hangzhou Xihu	China	Hao Chen	4872	0193	10	2018	Apple Pay
774	6	San Francisco Market St	United States	Noah Williams	4341	8357	6	2020	NULL
775	4	Paris Louvre	France	Hugo Lefebvre	4243	8311	12	2018	NULL
776	1	Lyon Bellecour	France	Manon Robert	4301	3638	3	2018	NULL
777	2	Paris La Défense	France	Léa Thomas	5231	2001	8	2016	NULL
778	5	Austin Downtown	United States	Ethan Taylor	5535	9269	4	2017	NULL
779	19	Hamburg Jungfernstieg	Germany	Emma Wagner	4573	6455	11	2017	NULL
780	19	München Marienplatz	Germany	Emma Wagner	4594	7789	1	2017	NULL
781	1	Nantes Commerce	France	Camille Durand	5339	0063	12	2016	NULL
783	1	Paris Opéra	France	Léa Petit	4793	5287	12	2020	NULL
784	8	Beijing Xidan	China	Hao Zhao	5307	8515	4	2017	NULL
785	18	Berlin Unter den Linden	Germany	Finn Müller	5547	8267	3	2020	NULL
786	31	Kraków Rynek	Poland	Antoni Kowalczyk	5497	7671	10	2016	NULL
787	26	Melbourne Collins St	Australia	Oliver Brown	4660	4249	1	2020	NULL
789	24	Seoul Yeouido	South Korea	Ha-eun Lee	5525	1920	6	2018	NULL
790	2	Paris La Défense	France	Chloé Laurent	5216	2627	9	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;