Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,926–1,950 of 4,762

card_payment, page 78 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
2285	31	Warszawa Śródmieście	Poland	Hanna Wójcik	4967	8632	3	2019	NULL
2286	8	Beijing Xidan	China	Jun Li	6201	2716	2	2021	NULL
2287	1	Nantes Commerce	France	Manon Simon	4863	0527	11	2020	NULL
2288	4	Paris Louvre	France	Lucas Martin	5518	4570	6	2020	NULL
2289	3	Rennes République	France	Léa Dubois	5117	2852	10	2018	NULL
2292	16	Madrid Gran Vía	Spain	Sofía Sánchez	4232	7370	2	2019	NULL
2293	19	München Marienplatz	Germany	Lea Koch	5120	5108	12	2021	NULL
2294	9	Shenzhen Futian	China	Lei Zhang	6201	4171	1	2019	NULL
2295	28	Rotterdam Coolsingel	Netherlands	Tess Jansen	5117	5577	6	2021	NULL
2296	9	Shenzhen Futian	China	Tao Huang	6220	6995	9	2022	NULL
2297	26	Woolloomooloo	Australia	William Jones	4441	3779	12	2019	NULL
2298	24	Seoul Yeouido	South Korea	Ha-eun Cho	5247	4116	6	2021	NULL
2299	6	San Francisco Market St	United States	Emma Moore	4582	1805	5	2020	NULL
2300	4	Paris Louvre	France	Gabriel Thomas	5193	1062	11	2022	NULL
2301	8	Shanghai Pudong	China	Lei Zhang	4969	0790	6	2019	NULL
2302	1	Nantes Commerce	France	Inès Dubois	4382	9764	4	2018	NULL
2303	16	Sevilla Triana	Spain	Pablo Pérez	4160	4454	1	2021	NULL
2304	4	Paris Louvre	France	Léa Petit	4740	2761	9	2020	NULL
2305	9	Shenzhen Futian	China	Hao Chen	6261	5707	6	2022	NULL
2306	4	Paris Louvre	France	Camille Durand	5201	2994	4	2018	Google Pay
2307	22	Osaka Umeda	Japan	Yuto Sato	4039	6285	12	2018	NULL
2309	6	Boston Back Bay	United States	Emma Garcia	5402	8961	5	2022	NULL
2312	27	Sydney Martin Place	Australia	Ruby Jones	5406	5363	10	2020	NULL
2313	1	Lyon Bellecour	France	Louis Martin	4559	5398	4	2021	NULL
2314	16	Madrid Gran Vía	Spain	Hugo García	4782	8755	1	2021	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;