Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 4,751–4,762 of 4,762

card_payment, page 191 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
5400	6	Atlanta Midtown	United States	James Brown	4472	4567	10	2022	Apple Pay
5401	16	Sevilla Triana	Spain	Lucía Gómez	4448	2087	8	2023	NULL
5402	30	Saint Petersburg Nevsky	Russia	Mikhail Smirnov	4885	6837	10	2022	NULL
5403	19	Hamburg Jungfernstieg	Germany	Ben Koch	4923	5568	1	2023	NULL
5404	10	Hangzhou Xihu	China	Lei Zhou	5240	8504	2	2021	NULL
5405	4	Paris Louvre	France	Arthur Bernard	4164	4012	1	2025	NULL
5407	17	Bilbao Abando	Spain	Lucía Gómez	4248	6277	6	2021	Apple Pay
5408	28	Rotterdam Coolsingel	Netherlands	Lucas van den Berg	5547	7529	4	2022	NULL
5409	4	Strasbourg Kléber	France	Manon Leroy	4372	8436	9	2023	Apple Pay
5410	3	Rennes République	France	Léa Moreau	5295	5385	1	2022	Apple Pay
5411	2	Paris La Défense	France	Zoé Robert	4456	5523	5	2021	NULL
5412	17	Barcelona Eixample	Spain	Daniel López	5218	8781	3	2025	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;