Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 476–500 of 4,762

card_payment, page 20 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
577	9	Guangzhou Tianhe	China	Yang Wu	4013	9362	2	2019	NULL
579	10	Chengdu Jinjiang	China	Xin Yang	5264	0423	11	2017	NULL
580	18	Frankfurt Taunusanlage	Germany	Elias Fischer	5320	6907	6	2018	NULL
581	11	Manchester Market St	United Kingdom	Sophie Wilson	5573	1921	2	2018	NULL
582	2	Marseille Canebière	France	Manon Durand	5308	9392	12	2018	Apple Pay
583	4	Strasbourg Kléber	France	Gabriel Laurent	4872	4517	6	2019	NULL
584	10	Chengdu Jinjiang	China	Yang Wang	5580	1705	8	2017	NULL
589	5	Manhattan Midtown	United States	James Williams	4645	6467	12	2018	NULL
590	4	Paris Louvre	France	Hugo Petit	4329	8206	4	2020	NULL
591	22	Tokyo Marunouchi	Japan	Sakura Takahashi	3500	0253	8	2017	NULL
593	23	Yokohama Minatomirai	Japan	Sakura Takahashi	3582	2406	12	2018	NULL
594	4	Paris Louvre	France	Camille Leroy	4446	0875	5	2019	NULL
596	31	Warszawa Śródmieście	Poland	Jan Nowak	4785	8293	9	2020	NULL
598	1	Paris Opéra	France	Lucas Thomas	4446	3341	8	2016	NULL
599	14	Milano Duomo	Italy	Francesco Ricci	4651	1114	1	2017	Apple Pay
600	3	Toulouse Capitole	France	Manon Durand	4685	2339	7	2016	NULL
601	27	Sydney Martin Place	Australia	Charlotte Ryan	4531	2103	5	2018	Apple Pay
603	5	Austin Downtown	United States	Emma Williams	4155	7784	11	2018	NULL
605	31	Warszawa Śródmieście	Poland	Jan Nowak	5217	1683	4	2020	NULL
607	6	San Francisco Market St	United States	Mason Jones	5404	2267	5	2018	NULL
608	18	Berlin Unter den Linden	Germany	Leon Meyer	5437	7002	12	2016	NULL
609	8	Beijing Xidan	China	Yan Yang	6289	1537	2	2019	NULL
611	26	Melbourne Collins St	Australia	Ruby Smith	5254	1391	6	2017	NULL
613	1	Nantes Commerce	France	Zoé Lefebvre	4914	1706	9	2017	NULL
614	5	Manhattan Midtown	United States	Ethan Williams	3747	3334	12	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;