Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,326–1,350 of 4,762

card_payment, page 54 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
1591	30	Saint Petersburg Nevsky	Russia	Ivan Petrov	4655	0590	9	2017	NULL
1592	22	Tokyo Marunouchi	Japan	Ren Yamamoto	3507	6528	9	2018	NULL
1593	6	Boston Back Bay	United States	Ava Moore	4503	2072	8	2019	NULL
1594	2	Paris La Défense	France	Léa Petit	4195	7788	11	2018	NULL
1595	2	Marseille Canebière	France	Gabriel Laurent	4291	6062	4	2019	NULL
1596	19	Hamburg Jungfernstieg	Germany	Mia Weber	4933	9928	1	2017	NULL
1597	34	Tampere Hämeenkatu	Finland	Sofia Mäkelä	4959	9025	9	2017	NULL
1598	15	Roma Termini	Italy	Francesco Bianchi	4575	0880	3	2021	NULL
1599	18	Berlin Unter den Linden	Germany	Mia Weber	4538	0855	8	2021	NULL
1600	1	Nantes Commerce	France	Manon Simon	5412	7815	9	2021	NULL
1601	16	Sevilla Triana	Spain	Daniel Martínez	4784	6372	6	2020	NULL
1602	30	Moscow Tverskaya	Russia	Anna Smirnov	5318	9391	5	2017	NULL
1604	7	Seattle Pike Place	United States	Ella Johnson	4336	8098	10	2019	NULL
1605	8	Beijing Xidan	China	Lin Xu	6205	0163	8	2020	NULL
1606	6	Boston Back Bay	United States	Mia Johnson	3791	6780	6	2018	Google Pay
1607	7	Seattle Pike Place	United States	Mia Johnson	3744	2661	2	2018	NULL
1608	4	Paris Louvre	France	Camille Thomas	4190	6567	6	2017	NULL
1610	2	Marseille Canebière	France	Camille Bernard	5593	3819	11	2017	Apple Pay
1611	11	London Canary Wharf	United Kingdom	Grace Smith	5154	0466	3	2017	NULL
1612	13	Bristol Corn St	United Kingdom	Grace Smith	4778	6278	1	2017	NULL
1613	12	Leeds Briggate	United Kingdom	Grace Smith	4879	0928	12	2020	NULL
1614	15	Firenze Santa Maria Novella	Italy	Ginevra Colombo	4400	1163	4	2017	NULL
1615	10	Chengdu Jinjiang	China	Jing Liu	4145	9410	4	2019	NULL
1616	9	Shenzhen Futian	China	Lin Wang	6278	5209	9	2017	NULL
1617	9	Guangzhou Tianhe	China	Lin Wang	6283	7688	3	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;