Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
organization_id	int	NO	MUL	NULL
label	varchar(120)	NO		Organization card on file
cardholder_name	varchar(150)	YES		NULL
card_brand	varchar(30)	YES		NULL
card_last4	char(4)	NO		NULL
exp_month	tinyint unsigned	NO		NULL
exp_year	smallint unsigned	NO		NULL
encrypted_payload	mediumtext	NO		NULL
nonce_b64	varchar(255)	NO		NULL
cipher_meta	varchar(40)	NO		sodium_xchacha20poly1305
key_version	varchar(30)	NO		v1
billing_name	varchar(150)	YES		NULL
billing_address	varchar(255)	YES		NULL
billing_phone	varchar(60)	YES		NULL
billing_email	varchar(320)	YES		NULL
authorization_text	text	YES		NULL
authorized_by_name	varchar(150)	YES		NULL
authorized_by_email	varchar(320)	YES		NULL
authorized_ip	varchar(64)	YES		NULL
authorized_user_agent	varchar(500)	YES		NULL
is_active	tinyint(1)	NO		1
revoked_at	datetime	YES		NULL
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Sample Data (First 20 rows)

id	organization_id	label	cardholder_name	card_brand	card_last4	exp_month	exp_year	encrypted_payload	nonce_b64	cipher_meta	key_version	billing_name	billing_address	billing_phone	billing_email	authorization_text	authorized_by_name	authorized_by_email	authorized_ip	authorized_user_agent	is_active	revoked_at	created_at	updated_at
1	2	Organization card on file	Jason Johnson	visa	7533	9	2028	HNZsNKpQZf35f5vLhZiLD7RZlSVu1/OHGEtzKNyIxUGM6aMpPV7g14fJdlvr4MlVkpLGkyhPxfFuG5NDgcSCPKZwq8yjYgRSC6RWG3P9xffDbNjUD4s+WYNuS6/i59moqnqduSnh4u0NFQ==	6V8stKgS4U7gM8St2upuWbsNlvxQ45Es	sodium_xchacha20poly1305	v1	NULL	NULL	NULL	NULL	I authorize Canaccom Travel Group to securely store this card and provide it to hotels as payment authorization for room charges, taxes, and security deposit only for teams within this organization. No additional charges are permitted, including incidentals, pay-per-view charges, room service charges, or long-distance charges, unless separately authorized.	Merle Johnson	[email protected]	162.158.146.239	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36	1	NULL	2026-06-25 06:03:32	2026-06-25 06:03:32
2	3	Organization card on file	Tom Smith	visa	7533	9	2028	UW69PeZEaGe7/NPzsbSg40O//JcoV3C1ZuTA6Nrp9tZW5Tp7hGSE8iFw9kOlWnT6lG62vGvlm3NDS3k/v7k+tZu8IdCMBqvhGYJf9WFFEHCwFwJYnoYBi2QmcWmTF6LzRa36OYtL	OYN+qHlH+3kTLMUqCk946/1M1vY5I3I0	sodium_xchacha20poly1305	v1	NULL	NULL	NULL	NULL	I authorize Canaccom Travel Group to securely store this card and provide it to hotels as payment authorization for room charges, taxes, and security deposit only for teams within this organization. No additional charges are permitted, including incidentals, pay-per-view charges, room service charges, or long-distance charges, unless separately authorized.	Tom Smith	[email protected]	162.158.146.239	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36	1	NULL	2026-06-25 09:40:27	2026-06-25 09:40:27