Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 426–450 of 4,762

card_payment, page 18 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
514	17	Bilbao Abando	Spain	Mateo Gómez	4185	9085	6	2016	NULL
515	4	Paris Louvre	France	Hugo Leroy	5531	2292	11	2020	NULL
516	15	Firenze Santa Maria Novella	Italy	Beatrice Ricci	5470	8009	7	2018	NULL
517	16	Sevilla Triana	Spain	Daniel Gómez	5369	1694	8	2020	NULL
520	3	Bordeaux Chartrons	France	Jules Laurent	5433	0441	7	2018	NULL
521	1	Paris Opéra	France	Gabriel Simon	5541	1937	12	2018	NULL
522	6	San Francisco Market St	United States	Ava Moore	4409	2814	1	2020	NULL
523	10	Chengdu Jinjiang	China	Yang Liu	4453	4889	7	2016	NULL
524	33	Bergen Bryggen	Norway	Nora Andersen	4167	0714	6	2016	NULL
525	10	Chengdu Jinjiang	China	Wei Zhou	4739	0827	9	2016	NULL
526	1	Paris Opéra	France	Hugo Dubois	4296	1343	4	2020	NULL
527	24	Busan Seomyeon	South Korea	Do-yun Park	4480	3119	2	2020	NULL
530	5	Manhattan Midtown	United States	Ethan Moore	5414	4002	3	2017	NULL
531	1	Lyon Bellecour	France	Camille Leroy	4544	3929	7	2017	NULL
532	22	Osaka Umeda	Japan	Sota Sato	4545	6576	1	2017	NULL
534	5	Austin Downtown	United States	Logan Johnson	5569	4821	4	2019	NULL
535	24	Busan Seomyeon	South Korea	Do-yun Park	4280	9486	6	2019	NULL
536	1	Lyon Bellecour	France	Camille Petit	4700	4841	1	2018	NULL
537	2	Marseille Canebière	France	Manon Robert	5551	9606	10	2016	NULL
538	3	Bordeaux Chartrons	France	Zoé Leroy	4559	6030	11	2020	NULL
543	27	Sydney Martin Place	Australia	William Ryan	4399	6700	3	2020	NULL
544	7	Denver Union Station	United States	Olivia Taylor	4146	8598	10	2017	NULL
545	7	Seattle Pike Place	United States	Noah Williams	4289	4660	10	2017	NULL
546	22	Tokyo Marunouchi	Japan	Sakura Sato	4642	0728	10	2017	NULL
547	4	Paris Louvre	France	Chloé Robert	4822	7524	10	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;