create table T_CHARACTER (ID bigint generated by default as identity (start with 1), FIRSTNAME varchar(255) not null, LASTNAME varchar(255) not null, RACE varchar(255) not null, primary key (ID));
create table T_JOB (ID bigint generated by default as identity (start with 1), LEVEL integer not null, NAME varchar(255) not null, CHARACTER_FK bigint, primary key (id));
alter table T_JOB add constraint FK_e354j4p43ss8t33rq070fahfy foreign key (CHARACTER_FK) references T_CHARACTER;