Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 501–525 of 4,762

card_payment, page 21 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
615	5	Chicago Loop	United States	Ethan Williams	5147	3467	4	2019	NULL
616	5	Manhattan Midtown	United States	Ava Smith	3735	0415	10	2019	NULL
617	32	Göteborg Avenyn	Sweden	Astrid Karlsson	4764	1712	4	2020	NULL
618	32	Stockholm Sergels Torg	Sweden	Astrid Karlsson	5495	9608	10	2016	NULL
619	31	Kraków Rynek	Poland	Antoni Wójcik	4409	6913	5	2018	NULL
621	19	München Marienplatz	Germany	Finn Becker	5242	4102	6	2017	NULL
622	30	Saint Petersburg Nevsky	Russia	Anastasia Petrov	4705	9070	7	2016	NULL
624	5	Manhattan Midtown	United States	Harper Wilson	4931	2394	8	2019	NULL
625	10	Chengdu Jinjiang	China	Jun Li	4644	8180	4	2018	NULL
626	10	Chengdu Jinjiang	China	Jun Li	6247	1652	1	2020	NULL
627	9	Guangzhou Tianhe	China	Jun Li	4956	1768	2	2019	NULL
628	9	Guangzhou Tianhe	China	Hao Wang	6285	8793	12	2017	NULL
629	2	Marseille Canebière	France	Zoé Martin	4537	9170	8	2016	NULL
630	2	Paris La Défense	France	Lucas Thomas	4710	9724	2	2018	NULL
631	5	Manhattan Midtown	United States	Harper Garcia	5493	0413	1	2020	NULL
633	10	Hangzhou Xihu	China	Tao Wang	6286	7251	5	2018	Google Pay
634	1	Nantes Commerce	France	Jules Simon	5292	5323	10	2019	NULL
635	15	Roma Termini	Italy	Francesco Rossi	4830	6128	7	2020	NULL
636	35	Montréal Ville-Marie	Canada	Olivia Brown	5189	5547	6	2017	NULL
637	1	Lyon Bellecour	France	Manon Petit	4817	8415	4	2020	NULL
638	12	Birmingham New St	United Kingdom	Ava Williams	4516	0191	10	2017	NULL
639	24	Seoul Yeouido	South Korea	Ye-jun Yoon	4413	3733	7	2018	NULL
640	24	Seoul Yeouido	South Korea	Ye-jun Yoon	5167	3795	6	2019	NULL
641	1	Paris Opéra	France	Léa Bernard	4641	7680	11	2016	NULL
642	2	Paris La Défense	France	Zoé Petit	4943	2245	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;