boyue2025/boyue_jnpf
3
0
Fork 0
mirror of https://gitee.com/myxzgzs/boyue_jnpf.git synced 2025-08-08 07:12:42 +08:00
Code Issues Packages Projects Releases Wiki Activity
boyue_jnpf/sql_init/SQLServer/jnpf_tenant_init.sql
luoyu a565d464e0 Initial commit
2025-06-30 09:38:03 +08:00

257 lines
19 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- ----------------------------
-- 表名：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';
Reference in New Issue View Git Blame Copy Permalink