+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_oa_examine_travel:/tablelist/okayapi_72crm_oa_examine_travel.html


-- MySQL Table okayapi_72crm_oa_examine_travel
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_oa_examine_travel` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `travel_id` int(11) NULL COMMENT '',
    `examine_id` int(11) NULL COMMENT '审批ID',
    `start_address` varchar(100) NULL COMMENT '出发地',
    `start_time` datetime NULL COMMENT '出发时间',
    `end_address` varchar(100) NULL COMMENT '目的地',
    `end_time` datetime NULL COMMENT '到达时间',
    `traffic` decimal(18,2) NULL COMMENT '交通费',
    `stay` decimal(18,2) NULL COMMENT '住宿费',
    `diet` decimal(18,2) NULL COMMENT '餐饮费',
    `other` decimal(18,2) NULL COMMENT '其他费用',
    `money` decimal(18,2) NULL COMMENT '金额',
    `vehicle` varchar(255) NULL COMMENT '交通工具',
    `trip` varchar(50) NULL COMMENT '单程往返(单程、往返)',
    `duration` decimal(4,1) NULL COMMENT '时长',
    `description` varchar(500) NULL COMMENT '备注',
    `batch_id` varchar(32) NULL COMMENT '批次id',
    KEY `travel_id` (`travel_id`),
    KEY `examine_id` (`examine_id`),
    KEY `start_address` (`start_address`),
    KEY `start_time` (`start_time`),
    KEY `end_address` (`end_address`),
    KEY `end_time` (`end_time`),
    KEY `traffic` (`traffic`),
    KEY `stay` (`stay`),
    KEY `diet` (`diet`),
    KEY `other` (`other`),
    KEY `money` (`money`),
    KEY `vehicle` (`vehicle`),
    KEY `trip` (`trip`),
    KEY `duration` (`duration`),
    KEY `description` (`description`),
    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-16 of 16 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
travel_idint(11)
examine_idint(11)审批ID
start_addressvarchar(100)出发地
start_timedatetime出发时间
end_addressvarchar(100)目的地
end_timedatetime到达时间
trafficdecimal(18,2)交通费
staydecimal(18,2)住宿费
dietdecimal(18,2)餐饮费
otherdecimal(18,2)其他费用
moneydecimal(18,2)金额
vehiclevarchar(255)交通工具
tripvarchar(50)单程往返(单程、往返)
durationdecimal(4,1)时长
descriptionvarchar(500)备注
batch_idvarchar(32)批次id

Guess You Like

MySQL Table Design okayapi_72crm_admin_config

MySQL Table Design okayapi_72crm_admin_dept

MySQL Table Design okayapi_72crm_admin_examine

MySQL Table Design okayapi_72crm_admin_examine_log

MySQL Table Design okayapi_72crm_admin_examine_record

MySQL Table Design okayapi_72crm_admin_examine_step

MySQL Table Design okayapi_72crm_admin_field_sort

MySQL Table Design okayapi_72crm_admin_fieldv

MySQL Table Design okayapi_72crm_admin_file

MySQL Table Design okayapi_72crm_admin_menu

MySQL Table Design okayapi_72crm_admin_message

MySQL Table Design okayapi_72crm_admin_record

MySQL Table Design okayapi_72crm_admin_role

MySQL Table Design okayapi_72crm_admin_role_menu

MySQL Table Design okayapi_72crm_admin_scene

MySQL Table Design okayapi_72crm_admin_scene_default

MySQL Table Design okayapi_72crm_admin_user

MySQL Table Design okayapi_72crm_admin_user_role

MySQL Table Design okayapi_72crm_crm_achievement

MySQL Table Design okayapi_72crm_crm_action_record

TOP ↑