MySQL Create Table SQL
Table Structure: okayapi_72crm_oa_examine:/tablelist/okayapi_72crm_oa_examine.html
-- MySQL Table okayapi_72crm_oa_examine
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_oa_examine` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`examine_id` int(11) NULL COMMENT '',
`category_id` int(11) NULL DEFAULT '1' COMMENT '审批类型',
`content` varchar(500) NULL COMMENT '内容',
`remark` varchar(500) NULL COMMENT '备注',
`type_id` varchar(32) NULL COMMENT '请假类型',
`money` decimal(18,2) NULL COMMENT '差旅、报销总金额',
`start_time` datetime NULL COMMENT '开始时间',
`end_time` datetime NULL COMMENT '结束时间',
`duration` decimal(4,1) NULL COMMENT '时长',
`create_user_id` bigint(20) NULL COMMENT '创建人ID',
`create_time` datetime NULL COMMENT '创建时间',
`batch_id` varchar(32) NULL COMMENT '附件批次id',
KEY `examine_id` (`examine_id`),
KEY `category_id` (`category_id`),
KEY `content` (`content`),
KEY `remark` (`remark`),
KEY `type_id` (`type_id`),
KEY `money` (`money`),
KEY `start_time` (`start_time`),
KEY `end_time` (`end_time`),
KEY `duration` (`duration`),
KEY `create_user_id` (`create_user_id`),
KEY `create_time` (`create_time`),
KEY `batch_id` (`batch_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-审批表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
examine_id | int(11) | 否 | ||||
category_id | int(11) | 1 | 否 | 审批类型 | 1 | |
content | varchar(500) | 是 | 内容 | |||
remark | varchar(500) | 是 | 备注 | |||
type_id | varchar(32) | 是 | 请假类型 | |||
money | decimal(18,2) | 是 | 差旅、报销总金额 | |||
start_time | datetime | 是 | 开始时间 | |||
end_time | datetime | 是 | 结束时间 | |||
duration | decimal(4,1) | 是 | 时长 | |||
create_user_id | bigint(20) | 否 | 创建人ID | |||
create_time | datetime | 否 | 创建时间 | |||
batch_id | varchar(32) | 是 | 附件批次id |