CREATE TABLE `company`( `id` BIGINT(11) AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `company_type` VARCHAR(50) NOT NULL, `profit_yn` VARCHAR(50) NOT NULL, `industry` VARCHAR(50) NOT NULL, `domain` VARCHAR(255) NOT NULL, `email` VARCHAR (255) NOT NULL, `tel` VARCHAR (50) NOT NULL, `desc` VARCHAR(255) NOT NULL, `register_date` TIMESTAMP NULL, `modify_id` BIGINT(20) NOT NULL, `modify_date` TIMESTAMP NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /* 이메일은 ID 값으로 받고 연락처도 user에 phone에서 받으면 되고*/