CREATE TABLE omo.consultant (
	id serial4 NOT NULL,
	agent_no varchar NOT NULL,
	"name" varchar NULL,
	photo_path varchar NULL,
	expertise varchar NULL,
	avg_score float4 NULL,
	title varchar NULL,
	"role" varchar NULL,
	created_date timestamp NULL,
	created_by varchar NULL,
	last_modified_date timestamp NULL,
	last_modified_by varchar NULL,
	serve_area varchar NULL,
	gender varchar NULL,
	phone_number varchar NULL,
	company_address varchar NULL,
	latest_login_time timestamp NULL,
	seniority varchar NULL,
	concept varchar NULL,
	experience varchar NULL,
	award varchar NULL,
	recommend bool NULL,
	CONSTRAINT consultant_pkey PRIMARY KEY (id)
);