[Dúvida] Field 'especialidade' doesn't have a default value

{ "timestamp": "2024-04-29T23:03:26.188+00:00", "status": 500, "error": "Internal Server Error", "trace": "org.springframework.orm.jpa.JpaSystemException: could not execute statement [Field 'especialidade' doesn't have a default value] [insert into medicos (crm,email,bairro,cep,cidade,complemento,logradouro,numero,uf,nome) values (?,?,?,?,?,?,?,?,?,?)]\r\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:341)\r\n\tat

create table medicos(

id bigint not null auto_increment,
nome varchar(100) not null,
email varchar(100) not null unique,
crm varchar(6) not null unique,
especialidade varchar(100) not null,
logradouro varchar(100) not null,
bairro varchar(100) not null,
cep varchar(9) not null,
complemento varchar(100),
numero varchar(20),
uf char(2) not null,
cidade varchar(100) not null,

primary key(id)

);