20220405_update.sql

create or replace table lookup
(
	lookup_id bigint auto_increment
		primary key,
	tenant_id bigint not null,
	name varchar(255) not null,
	description longtext null,
	created_at timestamp default current_timestamp() not null,
	updated_at timestamp default '0000-00-00 00:00:00' not null,
	constraint lookup_tenant_id_name_uindex
		unique (tenant_id, name),
	constraint lookup_tenant_tenant_id_fk
		foreign key (tenant_id) references tenant (tenant_id)
			on delete cascade
);

create or replace index lookup_name_index
	on lookup (name);