Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1–25 of 4,762

card_payment, page 1 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
1	7	Seattle Pike Place	United States	Mason Williams	5216	1178	5	2017	NULL
2	21	Brasília Asa Sul	Brazil	Alice Ferreira	4336	9081	1	2019	NULL
3	1	Nantes Commerce	France	Manon Durand	5185	4571	1	2017	NULL
4	4	Paris Louvre	France	Chloé Laurent	4755	8417	7	2020	NULL
5	3	Rennes République	France	Hugo Robert	5502	8702	10	2017	NULL
6	4	Strasbourg Kléber	France	Jules Laurent	5396	0783	6	2020	NULL
7	5	Chicago Loop	United States	Noah Johnson	5338	3077	12	2017	Apple Pay
8	5	Chicago Loop	United States	Noah Johnson	5279	8593	3	2018	NULL
9	14	Torino Centro	Italy	Sofia Rossi	4461	9361	7	2020	NULL
10	30	Moscow Tverskaya	Russia	Alexander Kuznetsov	5313	9887	8	2017	NULL
11	9	Shenzhen Futian	China	Tao Zhou	6283	8632	6	2017	NULL
12	6	San Francisco Market St	United States	Emma Garcia	5431	4869	5	2017	NULL
13	5	Manhattan Midtown	United States	James Taylor	5324	5256	6	2017	NULL
14	26	Melbourne Collins St	Australia	Oliver Ryan	4037	6501	5	2017	NULL
15	10	Chengdu Jinjiang	China	Yan Li	6297	4811	4	2018	NULL
16	2	Paris La Défense	France	Zoé Petit	5255	5696	3	2017	NULL
18	9	Shenzhen Futian	China	Hao Zhou	4873	2471	11	2016	NULL
19	35	Montréal Ville-Marie	Canada	Emma Smith	4972	5965	12	2019	NULL
20	1	Lyon Bellecour	France	Louis Dubois	4891	2736	7	2017	NULL
22	1	Lyon Bellecour	France	Jules Laurent	4208	0156	7	2020	NULL
23	12	Leeds Briggate	United Kingdom	Grace Wilson	4171	2222	8	2016	NULL
24	11	London Canary Wharf	United Kingdom	Grace Wilson	4232	9362	1	2016	NULL
27	29	Utrecht Centrum	Netherlands	Lucas Jansen	4553	6103	5	2018	NULL
28	3	Toulouse Capitole	France	Chloé Laurent	4693	1078	5	2017	NULL
29	26	Woolloomooloo	Australia	Oliver Ryan	5277	3353	10	2020	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;