| | |
|---|
| | | CREATE TABLE `company`( |
|---|
| | | CREATE TABLE `company_field`( |
|---|
| | | `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, |
|---|
| | | `manager` VARCHAR(50) NULL, |
|---|
| | | `tel` VARCHAR (50) NULL, |
|---|
| | | `email` VARCHAR (255) NULL, |
|---|
| | | `memo` VARCHAR(255) NULL, |
|---|
| | | `register_id` BIGINT(20) NOT NULL, |
|---|
| | | `register_date` TIMESTAMP NULL, |
|---|
| | | `modify_id` BIGINT(20) NOT NULL, |
|---|
| | | `modify_date` TIMESTAMP NULL, |
|---|
