CREATE TABLE $`$census$`($

$`$usid$`$ int NOT NULL,

$`$age$`$ int NOT NULL,

$`$workclass$`$ varchar$(64)$ DEFAULT NULL,

$`$fnlwgt$`$ int NOT NULL,

$`$education$`$ varchar$(64)$ NOT NULL,

$`$education$\_$num$`$ int NOT NULL,

$`$marital$\_$status$`$ varchar$(64)$ NOT NULL,

$`$occupation$`$ varchar$(64)$ NOT NULL,

$`$relationship$`$ varchar$(64)$ NOT NULL,

$`$race$`$ varchar$(64)$ NOT NULL,

$`$sex$`$ varchar$(16)$ NOT NULL,

$`$capital$\_$gain$`$ int NOT NULL,

$`$capital$\_$loss$`$ int NOT NULL,

$`$hours$\_$per$\_$week$`$ int NOT NULL,

$`$native$\_$country$`$ varchar$(64)$ NOT NULL,

$`$label$`$ char$(5)$ NOT NULL,

PRIMARY KEY $(`$usid$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_0900\_$ai$\_$ci;