MySQL Create Table SQL
Table Structure: okayapi_bi_crm_contacts:/tablelist/okayapi_bi_crm_contacts.html
-- MySQL Table okayapi_bi_crm_contacts
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_crm_contacts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`customer` varchar(255) NULL COMMENT '',
`title` varchar(255) NULL COMMENT '',
`dept` varchar(255) NULL COMMENT '',
`birt` varchar(255) NULL COMMENT '',
`deptpr` varchar(255) NULL COMMENT '',
`qian` varchar(255) NULL COMMENT '',
`email` varchar(255) NULL COMMENT '',
`phone` varchar(255) NULL COMMENT '',
`mobile` varchar(255) NULL COMMENT '',
`fphone` varchar(255) NULL COMMENT '',
`ophone` varchar(255) NULL COMMENT '',
`fax` varchar(255) NULL COMMENT '',
`zhuli` varchar(255) NULL COMMENT '',
`zhuliphone` varchar(255) NULL COMMENT '',
`zhulimobile` varchar(255) NULL COMMENT '',
`otheraddress` varchar(255) NULL COMMENT '',
`level` varchar(255) NULL COMMENT '',
`share` varchar(255) NULL COMMENT '',
KEY `name` (`name`),
KEY `customer` (`customer`),
KEY `title` (`title`),
KEY `dept` (`dept`),
KEY `birt` (`birt`),
KEY `deptpr` (`deptpr`),
KEY `qian` (`qian`),
KEY `email` (`email`),
KEY `phone` (`phone`),
KEY `mobile` (`mobile`),
KEY `fphone` (`fphone`),
KEY `ophone` (`ophone`),
KEY `fax` (`fax`),
KEY `zhuli` (`zhuli`),
KEY `zhuliphone` (`zhuliphone`),
KEY `zhulimobile` (`zhulimobile`),
KEY `otheraddress` (`otheraddress`),
KEY `level` (`level`),
KEY `share` (`share`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '企业报表-联系人';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-19 of 19 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
customer | varchar(255) | 是 | ||||
title | varchar(255) | 是 | ||||
dept | varchar(255) | 是 | ||||
birt | varchar(255) | 是 | ||||
deptpr | varchar(255) | 是 | ||||
qian | varchar(255) | 是 | ||||
varchar(255) | 是 | |||||
phone | varchar(255) | 是 | ||||
mobile | varchar(255) | 是 | ||||
fphone | varchar(255) | 是 | ||||
ophone | varchar(255) | 是 | ||||
fax | varchar(255) | 是 | ||||
zhuli | varchar(255) | 是 | ||||
zhuliphone | varchar(255) | 是 | ||||
zhulimobile | varchar(255) | 是 | ||||
otheraddress | varchar(255) | 是 | ||||
level | varchar(255) | 是 | ||||
share | varchar(255) | 是 |