jnpf-database/SQLServer/jnpf_tenant_init.sql

-- ----------------------------
-- 表名：base_tenant
-- ----------------------------
CREATE TABLE base_tenant(
	f_id nvarchar(50) NOT NULL PRIMARY KEY,
	f_en_code nvarchar(50),
	f_full_name nvarchar(50),
	f_db_name nvarchar(50),
	f_description nvarchar(500),
	f_sort_code bigint,
	f_enabled_mark int,
	f_creator_time datetime,
	f_creator_user_id nvarchar(50),
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_mark int,
	f_delete_time datetime,
	f_delete_user_id nvarchar(50),
	f_tenant_id nvarchar(50),
	f_start_time datetime,
	f_end_time datetime,
	f_account_num bigint,
	f_type int,
	f_db_type nvarchar(50),
	f_unit_info_json nvarchar(max),
	f_user_info_json nvarchar(max)
);
EXEC sp_addextendedproperty 'MS_Description',N'租户表','SCHEMA',N'dbo','TABLE',N'base_tenant';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'编号','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_en_code';
EXEC sp_addextendedproperty 'MS_Description',N'名称','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_full_name';
EXEC sp_addextendedproperty 'MS_Description',N'服务名称','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_db_name';
EXEC sp_addextendedproperty 'MS_Description',N'描述','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_description';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'有效标志','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_enabled_mark';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标志','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_delete_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'租户主键','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'起始时间','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_start_time';
EXEC sp_addextendedproperty 'MS_Description',N'过期时间','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_end_time';
EXEC sp_addextendedproperty 'MS_Description',N'账号额度','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_account_num';
EXEC sp_addextendedproperty 'MS_Description',N'类型(0-库隔离 1-id隔离 2-连接隔离)','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_type';
EXEC sp_addextendedproperty 'MS_Description',N'数据库类型','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_db_type';
EXEC sp_addextendedproperty 'MS_Description',N'单位信息','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_unit_info_json';
EXEC sp_addextendedproperty 'MS_Description',N'联系人信息','SCHEMA',N'dbo','TABLE',N'base_tenant','COLUMN',N'f_user_info_json';
-- ----------------------------
-- 表名：base_tenant_account
-- ----------------------------
CREATE TABLE base_tenant_account(
	f_id nvarchar(50) NOT NULL PRIMARY KEY,
	f_account nvarchar(50),
	f_password nvarchar(50),
	f_real_name nvarchar(50),
	f_gender int,
	f_is_administrator int,
	f_description nvarchar(500),
	f_sort_code bigint,
	f_enabled_mark int,
	f_creator_time datetime,
	f_creator_user_id nvarchar(50),
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_time datetime,
	f_delete_user_id nvarchar(50),
	f_delete_mark int,
	f_tenant_id nvarchar(50),
	f_mobile_phone nvarchar(50)
);
EXEC sp_addextendedproperty 'MS_Description',N'用户信息','SCHEMA',N'dbo','TABLE',N'base_tenant_account';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'账户','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_account';
EXEC sp_addextendedproperty 'MS_Description',N'密码','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_password';
EXEC sp_addextendedproperty 'MS_Description',N'姓名','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_real_name';
EXEC sp_addextendedproperty 'MS_Description',N'性别','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_gender';
EXEC sp_addextendedproperty 'MS_Description',N'是否管理员','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_is_administrator';
EXEC sp_addextendedproperty 'MS_Description',N'描述','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_description';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'有效标志','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_enabled_mark';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_delete_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标志','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'租户主键','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'手机号码','SCHEMA',N'dbo','TABLE',N'base_tenant_account','COLUMN',N'f_mobile_phone';
DELETE FROM base_tenant_account;
INSERT INTO base_tenant_account (f_enabled_mark,f_password,f_tenant_id,f_creator_user_id,f_last_modify_user_id,f_delete_mark,f_delete_user_id,f_is_administrator,f_delete_time,f_mobile_phone,f_account,f_real_name,f_description,f_gender,f_sort_code,f_id,f_last_modify_time,f_creator_time) VALUES (1,'14e1b600b1fd579f47433b88e8d85291',Null,'1',Null,Null,Null,1,Null,Null,'admin','管理员','admin',1,1,'47ff0279-aa26a4fbeb59f630c8776f759',Null,'2021-09-18 18:01:08');
-- ----------------------------
-- 表名：base_tenant_authorize
-- ----------------------------
CREATE TABLE base_tenant_authorize(
	f_id nvarchar(50) NOT NULL PRIMARY KEY,
	f_module_id nvarchar(50),
	f_tenant_id nvarchar(50),
	f_url_address nvarchar(500),
	f_sort_code bigint,
	f_creator_time datetime,
	f_creator_user_id nvarchar(50),
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_mark int,
	f_delete_time datetime,
	f_delete_user_id nvarchar(50)
);
EXEC sp_addextendedproperty 'MS_Description',N'租户权限','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'未授权菜单id','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_module_id';
EXEC sp_addextendedproperty 'MS_Description',N'功能地址','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_url_address';
EXEC sp_addextendedproperty 'MS_Description',N'租户主键','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标志','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant_authorize','COLUMN',N'f_delete_user_id';
-- ----------------------------
-- 表名：base_tenant_link
-- ----------------------------
CREATE TABLE base_tenant_link(
	f_id nvarchar(50) NOT NULL PRIMARY KEY,
	f_full_name nvarchar(50),
	f_config_type int,
	f_host nvarchar(50),
	f_port int,
	f_user_name nvarchar(50),
	f_password nvarchar(50),
	f_service_name nvarchar(50),
	f_description nvarchar(max),
	f_sort_code bigint,
	f_enabled_mark int,
	f_creator_time datetime,
	f_creator_user_id nvarchar(50),
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_mark int,
	f_delete_time datetime,
	f_delete_user_id nvarchar(50),
	f_db_schema nvarchar(50),
	f_table_space nvarchar(50),
	f_oracle_param nvarchar(max),
	f_connection_str nvarchar(max),
	f_tenant_id nvarchar(50),
	f_db_type nvarchar(50)
);
EXEC sp_addextendedproperty 'MS_Description',N'租户数据连接','SCHEMA',N'dbo','TABLE',N'base_tenant_link';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'连接名称','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_full_name';
EXEC sp_addextendedproperty 'MS_Description',N'配置类型（0：主，1：从）','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_config_type';
EXEC sp_addextendedproperty 'MS_Description',N'主机地址','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_host';
EXEC sp_addextendedproperty 'MS_Description',N'端口','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_port';
EXEC sp_addextendedproperty 'MS_Description',N'用户','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_user_name';
EXEC sp_addextendedproperty 'MS_Description',N'密码','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_password';
EXEC sp_addextendedproperty 'MS_Description',N'服务名称','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_service_name';
EXEC sp_addextendedproperty 'MS_Description',N'描述','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_description';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'有效标志','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_enabled_mark';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标志','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_delete_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'表模式','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_db_schema';
EXEC sp_addextendedproperty 'MS_Description',N'表空间','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_table_space';
EXEC sp_addextendedproperty 'MS_Description',N'oracle参数','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_oracle_param';
EXEC sp_addextendedproperty 'MS_Description',N'自定义连接语句','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_connection_str';
EXEC sp_addextendedproperty 'MS_Description',N'租户id','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'数据库类型','SCHEMA',N'dbo','TABLE',N'base_tenant_link','COLUMN',N'f_db_type';
-- ----------------------------
-- 表名：base_tenant_log
-- ----------------------------
CREATE TABLE base_tenant_log(
	f_id nvarchar(255) NOT NULL PRIMARY KEY,
	f_tenant_id nvarchar(50),
	f_login_account nvarchar(50),
	f_login_ip_address nvarchar(50),
	f_login_ip_address_name nvarchar(50),
	f_login_source_website nvarchar(255),
	f_login_time datetime,
	f_description nvarchar(500),
	f_sort_code bigint,
	f_creator_time datetime,
	f_creator_user_id nvarchar(50),
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_mark int,
	f_delete_time datetime,
	f_delete_user_id nvarchar(50)
);
EXEC sp_addextendedproperty 'MS_Description',N'租户日志表','SCHEMA',N'dbo','TABLE',N'base_tenant_log';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'租户主键','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'登录账户','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_login_account';
EXEC sp_addextendedproperty 'MS_Description',N'IP地址','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_login_ip_address';
EXEC sp_addextendedproperty 'MS_Description',N'IP所在城市','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_login_ip_address_name';
EXEC sp_addextendedproperty 'MS_Description',N'来源网站','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_login_source_website';
EXEC sp_addextendedproperty 'MS_Description',N'登录时间','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_login_time';
EXEC sp_addextendedproperty 'MS_Description',N'描述','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_description';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标志','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant_log','COLUMN',N'f_delete_user_id';
-- ----------------------------
-- 表名：base_tenant_socials
-- ----------------------------
CREATE TABLE base_tenant_socials(
	f_id nvarchar(50) NOT NULL PRIMARY KEY,
	f_user_id nvarchar(50),
	f_account nvarchar(50),
	f_account_name nvarchar(255),
	f_social_type nvarchar(50),
	f_social_id nvarchar(100),
	f_social_name nvarchar(100),
	f_tenant_id nvarchar(100),
	f_description nvarchar(100),
	f_sort_code bigint,
	f_creator_user_id nvarchar(50),
	f_creator_time datetime,
	f_last_modify_time datetime,
	f_last_modify_user_id nvarchar(50),
	f_delete_mark int,
	f_delete_time datetime,
	f_delete_user_id nvarchar(50)
);
EXEC sp_addextendedproperty 'MS_Description',N'多租户第三方绑定表','SCHEMA',N'dbo','TABLE',N'base_tenant_socials';
EXEC sp_addextendedproperty 'MS_Description',N'自然主键','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_id';
EXEC sp_addextendedproperty 'MS_Description',N'用户id','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'用户账号','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_account';
EXEC sp_addextendedproperty 'MS_Description',N'用户账号名称','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_account_name';
EXEC sp_addextendedproperty 'MS_Description',N'第三方类型','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_social_type';
EXEC sp_addextendedproperty 'MS_Description',N'第三方账号id','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_social_id';
EXEC sp_addextendedproperty 'MS_Description',N'第三方账号','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_social_name';
EXEC sp_addextendedproperty 'MS_Description',N'租户id','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_tenant_id';
EXEC sp_addextendedproperty 'MS_Description',N'备注','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_description';
EXEC sp_addextendedproperty 'MS_Description',N'排序','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_sort_code';
EXEC sp_addextendedproperty 'MS_Description',N'创建用户','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_creator_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'创建时间','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_creator_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改时间','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_last_modify_time';
EXEC sp_addextendedproperty 'MS_Description',N'修改用户','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_last_modify_user_id';
EXEC sp_addextendedproperty 'MS_Description',N'删除标记','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_delete_mark';
EXEC sp_addextendedproperty 'MS_Description',N'删除时间','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_delete_time';
EXEC sp_addextendedproperty 'MS_Description',N'删除用户','SCHEMA',N'dbo','TABLE',N'base_tenant_socials','COLUMN',N'f_delete_user_id';