Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 2,251–2,275 of 4,762

card_payment, page 91 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
2666	18	Frankfurt Taunusanlage	Germany	Ben Weber	4170	5851	2	2022	NULL
2667	19	München Marienplatz	Germany	Emma Becker	4136	2401	9	2022	NULL
2668	14	Milano Duomo	Italy	Alessandro Esposito	4089	1055	9	2018	NULL
2669	23	Yokohama Minatomirai	Japan	Sota Nakamura	4084	7643	10	2018	NULL
2670	4	Paris Louvre	France	Lucas Dubois	4815	0902	7	2021	NULL
2671	1	Lyon Bellecour	France	Chloé Petit	5286	7075	8	2021	NULL
2672	15	Firenze Santa Maria Novella	Italy	Ginevra Russo	4439	2996	2	2018	NULL
2673	3	Rennes République	France	Zoé Robert	4464	3210	8	2019	NULL
2674	3	Toulouse Capitole	France	Hugo Bernard	4865	4750	11	2020	NULL
2675	3	Bordeaux Chartrons	France	Inès Moreau	5160	9747	1	2018	Apple Pay
2676	1	Lyon Bellecour	France	Hugo Petit	4796	9847	11	2021	NULL
2677	17	Bilbao Abando	Spain	Hugo Martínez	4725	8301	5	2022	NULL
2678	7	Denver Union Station	United States	Ava Williams	4823	9778	3	2019	NULL
2679	10	Hangzhou Xihu	China	Fang Xu	6255	5209	12	2022	NULL
2680	23	Kyoto Shijo	Japan	Sakura Tanaka	5141	5286	9	2018	NULL
2682	31	Warszawa Śródmieście	Poland	Zuzanna Zieliński	4528	1432	12	2019	NULL
2683	22	Tokyo Marunouchi	Japan	Ren Nakamura	4294	2168	5	2021	NULL
2684	4	Paris Louvre	France	Chloé Martin	5225	7564	8	2018	NULL
2685	4	Paris Louvre	France	Manon Simon	4588	4681	8	2018	NULL
2686	7	Seattle Pike Place	United States	Emma Wilson	3759	2657	9	2022	NULL
2687	2	Marseille Canebière	France	Inès Petit	4979	5224	4	2018	NULL
2688	1	Paris Opéra	France	Lucas Laurent	5233	7738	8	2020	NULL
2689	10	Hangzhou Xihu	China	Min Wu	6254	2992	10	2018	Apple Pay
2690	3	Bordeaux Chartrons	France	Lucas Thomas	4727	6339	9	2018	NULL
2691	14	Torino Centro	Italy	Leonardo Ferrari	4258	3039	10	2019	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;