+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(255)
customervarchar(255)
titlevarchar(255)
deptvarchar(255)
birtvarchar(255)
deptprvarchar(255)
qianvarchar(255)
emailvarchar(255)
phonevarchar(255)
mobilevarchar(255)
fphonevarchar(255)
ophonevarchar(255)
faxvarchar(255)
zhulivarchar(255)
zhuliphonevarchar(255)
zhulimobilevarchar(255)
otheraddressvarchar(255)
levelvarchar(255)
sharevarchar(255)

Guess You Like

MySQL Table Design okayapi_bi_account

MySQL Table Design okayapi_bi_analyzereport

MySQL Table Design okayapi_bi_auth

MySQL Table Design okayapi_bi_blacklist

MySQL Table Design okayapi_bi_category

MySQL Table Design okayapi_bi_datasource

MySQL Table Design okayapi_bi_datatable

MySQL Table Design okayapi_bi_log_report

MySQL Table Design okayapi_bi_log_request

MySQL Table Design okayapi_bi_metadata

MySQL Table Design okayapi_bi_project

MySQL Table Design okayapi_bi_role

MySQL Table Design okayapi_bi_role_group

MySQL Table Design okayapi_pinot_generic_json_entity

MySQL Table Design okayapi_pinot_anomaly_function_index

MySQL Table Design okayapi_pinot_job_index

MySQL Table Design okayapi_pinot_task_index

MySQL Table Design okayapi_pinot_raw_anomaly_result_index

MySQL Table Design okayapi_pinot_merged_anomaly_result_index

MySQL Table Design okayapi_pinot_dataset_config_index

TOP ↑