建库语句

每张表基本字段

https://doc.rg1008.com/docs/rg_pass_struct/rg_pass_struct-1d2qr0q59fcac

-- bt_bs_booking.bs_booking_info definition

CREATE TABLE `{table_name}` (
  `BOOKING_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '预约ID',
  `BOOKING_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '预约名称',
  `START_DATE` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
  `END_DATE` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '结束时间',
  `MAX_NUM` int DEFAULT '0' COMMENT '最大预约数',
  `RESERVED_NUM` int DEFAULT '0' COMMENT '已经预约数',
  `CHECK_NUM` int DEFAULT NULL COMMENT '核验数量',
  `RETAIL_PRICE` decimal(9,2) DEFAULT NULL COMMENT '原始价格',
  `SALE_PRICE` decimal(9,2) DEFAULT NULL COMMENT '销售价格',
  `TYPE_TAG` varchar(1800) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '类型标记',
  `IMG_URL` varchar(200) DEFAULT '' COMMENT '图片地址',
  `LINK_URL` varchar(400) DEFAULT '' COMMENT '链接地址',
  `VIDEO_URL` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '视频地址',
  `TAGS` varchar(1800) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '预约标记',
  `GEOGRAPHY` geometry DEFAULT NULL COMMENT '地图坐标',
  `AREA_CODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区码',
  `ADDRESS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '地址',
  `IS_ENABLED` int DEFAULT '1' COMMENT '启用',
  `SORT_ID` int DEFAULT '0' COMMENT '排序',
  `SHOW_NUM` int DEFAULT '0' COMMENT '点击数/浏览数',
  `REMARK` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '预约规则',
  `SYS_ID` varchar(1800) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '系统ID，关联  BO_SYSTEM',
  `CREATE_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `MODIFY_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建用户',
  `MODIFY_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`BOOKING_ID`) USING BTREE,
  UNIQUE KEY `idx_uq_bs_news_type` (`BOOKING_ID`),
  KEY `idx_no_{table_name}_name` (`BOOKING_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE bt_bs_oa.oa_day_report ADD TENANT_ID varchar(100) NULL COMMENT '所属租户';
ALTER TABLE bt_bs_oa.oa_day_report CHANGE TENANT_ID TENANT_ID varchar(100) NULL COMMENT '所属租户' AFTER REMARK;
ALTER TABLE bt_bs_oa.oa_day_report ADD APP_ID varchar(100) NULL COMMENT '所属应用';
ALTER TABLE bt_bs_oa.oa_day_report CHANGE APP_ID APP_ID varchar(100) NULL COMMENT '所属应用' AFTER TENANT_ID;

ALTER TABLE bt_bs_oa.oa_kq_attendance_record ADD AUDIT_TIME datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '审核时间';
ALTER TABLE bt_bs_oa.oa_kq_attendance_record ADD AUDIT_STATUS int DEFAULT 0 NULL COMMENT '审核状态  0=停用，1=正常（审核通过） 2=待审核 3=驳回';
ALTER TABLE bt_bs_oa.oa_kq_attendance_record ADD AUDIT_USER_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核用户';
ALTER TABLE bt_bs_oa.oa_kq_attendance_record ADD AUDIT_OPINION varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NULL COMMENT '审核意见';