Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 2,151–2,175 of 4,762

card_payment, page 87 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
2547	2	Lille Grand Place	France	Lucas Leroy	5457	2538	8	2021	NULL
2548	15	Roma Termini	Italy	Matteo Ricci	5451	0822	3	2022	NULL
2550	5	Austin Downtown	United States	Ethan Davis	4764	8660	3	2019	NULL
2551	7	Seattle Pike Place	United States	Ava Brown	5203	5414	6	2018	NULL
2552	4	Strasbourg Kléber	France	Hugo Martin	4200	2631	2	2020	NULL
2553	10	Hangzhou Xihu	China	Yang Huang	5551	0734	2	2022	NULL
2554	22	Tokyo Marunouchi	Japan	Hina Takahashi	5341	1205	6	2021	NULL
2555	3	Rennes République	France	Camille Simon	5183	9364	2	2021	NULL
2556	10	Hangzhou Xihu	China	Jun Wu	5320	4508	12	2020	NULL
2557	23	Kyoto Shijo	Japan	Yuto Tanaka	4286	7307	1	2022	NULL
2558	10	Chengdu Jinjiang	China	Lei Xu	4817	7757	11	2019	NULL
2559	29	Utrecht Centrum	Netherlands	Sophie Meijer	4059	2912	1	2019	NULL
2561	14	Milano Duomo	Italy	Matteo Ricci	5310	7829	1	2021	NULL
2562	14	Milano Duomo	Italy	Matteo Ricci	4315	3439	3	2022	NULL
2563	10	Chengdu Jinjiang	China	Fang Sun	6283	1001	2	2022	NULL
2564	4	Paris Louvre	France	Louis Bernard	5126	6692	2	2021	NULL
2565	3	Rennes République	France	Inès Thomas	5416	2262	2	2019	NULL
2567	17	Bilbao Abando	Spain	Pablo García	4872	7996	7	2019	NULL
2568	2	Marseille Canebière	France	Léa Robert	5491	4255	9	2018	NULL
2569	18	Berlin Unter den Linden	Germany	Hannah Schmidt	5174	4783	4	2021	Google Pay
2570	30	Saint Petersburg Nevsky	Russia	Anastasia Kuznetsov	5378	0801	10	2018	NULL
2571	2	Marseille Canebière	France	Inès Moreau	4082	8800	9	2018	NULL
2572	1	Paris Opéra	France	Léa Lefebvre	4250	5003	8	2021	Apple Pay
2573	2	Paris La Défense	France	Zoé Petit	5326	1208	1	2020	NULL
2574	15	Roma Termini	Italy	Giulia Romano	4315	1773	10	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;