>[info] 公共表结构 ``` CREATE TABLE `ep_order` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', `order_id` bigint(18) unsigned NOT NULL DEFAULT '0' COMMENT '订单id', `server_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家id', `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', `sales_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销售id', `sales_name` varchar(50) NOT NULL DEFAULT '' COMMENT '销售名称', `sales_dept_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销售部门id', `sales_dept_name` varchar(100) NOT NULL DEFAULT '' COMMENT '销售部门名称', `lessee_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '承租id', `lessee_name` varchar(100) NOT NULL DEFAULT '' COMMENT '承租名称', `lessee_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '承租类型（1-个人 2-企业）', `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人', `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新人', `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_order_id` (`order_id`), KEY `idx_lessee_id` (`lessee_id`), KEY `idx_sales_dept_id` (`sales_dept_id`), KEY `idx_sales_id` (`sales_id`), KEY `idx_server_id` (`server_id`) ) ENGINE=InnoDB DEFAULT CHARSET = utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT = '企业订单表'; ```