Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,026–1,050 of 4,762

card_payment, page 42 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
1235	3	Rennes République	France	Camille Petit	5205	1020	11	2019	NULL
1236	26	Adelaide Rundle Mall	Australia	Amelia Taylor	5369	5701	12	2019	NULL
1237	30	Saint Petersburg Nevsky	Russia	Maria Ivanov	5341	7319	2	2017	NULL
1238	31	Kraków Rynek	Poland	Jakub Wiśniewski	4408	3642	12	2017	NULL
1239	31	Warszawa Śródmieście	Poland	Szymon Kamiński	5548	6552	1	2020	Apple Pay
1240	6	Atlanta Midtown	United States	Emma Anderson	4315	2146	5	2020	NULL
1241	5	Austin Downtown	United States	Emma Anderson	4777	8684	12	2018	NULL
1242	10	Hangzhou Xihu	China	Yang Yang	4630	4795	1	2019	NULL
1244	22	Tokyo Marunouchi	Japan	Sota Suzuki	5446	1648	6	2017	NULL
1245	9	Shenzhen Futian	China	Jun Xu	4123	1061	12	2021	NULL
1246	2	Marseille Canebière	France	Inès Laurent	5406	6527	3	2018	NULL
1247	25	Incheon Songdo	South Korea	Min-jun Lee	5543	6775	2	2019	NULL
1249	25	Incheon Songdo	South Korea	Min-jun Lee	4300	5531	8	2017	NULL
1250	18	Berlin Unter den Linden	Germany	Finn Fischer	5270	8817	11	2019	NULL
1251	6	San Francisco Market St	United States	James Anderson	5366	5312	3	2017	NULL
1252	17	Bilbao Abando	Spain	Hugo Gómez	5199	5310	6	2020	NULL
1253	18	Berlin Unter den Linden	Germany	Finn Wagner	5115	8270	7	2020	NULL
1254	8	Beijing Xidan	China	Wei Wang	6244	9417	11	2020	NULL
1255	10	Chengdu Jinjiang	China	Xin Chen	6257	4554	5	2018	NULL
1258	5	Chicago Loop	United States	Mia Jones	4857	9012	5	2018	NULL
1259	7	Seattle Pike Place	United States	Olivia Moore	4993	0597	10	2018	NULL
1262	24	Seoul Yeouido	South Korea	Do-yun Park	4430	5772	12	2021	NULL
1263	2	Marseille Canebière	France	Gabriel Durand	5448	6120	10	2020	NULL
1264	3	Rennes République	France	Léa Moreau	5452	0742	11	2017	NULL
1265	2	Lille Grand Place	France	Jules Simon	5203	5654	5	2017	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;