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에서 받으면 되고*/
|
