thmz/src/main/resources/otherSource/thyy_mz_system_sqlServer.sql

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_button]') AND type IN ('U'))
    DROP TABLE [dbo].[t_button];

create table t_button
(
    id          bigint identity (1, 1)
        primary key,
    name        varchar(510),
    parent_id   bigint,
    button_code varchar(510),
    sort_value  int,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '按钮表', 'SCHEMA', 'dbo', 'TABLE', 't_button'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '按钮名称', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'name'
go

exec sp_addextendedproperty 'MS_Description', '父菜单id', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'parent_id'
go

exec sp_addextendedproperty 'MS_Description', '按钮编码', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'button_code'
go

exec sp_addextendedproperty 'MS_Description', '排序字段 ，越小越优先', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN',
     'sort_value'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人id', 'SCHEMA', 'dbo', 'TABLE', 't_button', 'COLUMN', 'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_clinic]') AND type IN ('U'))
    DROP TABLE [dbo].[t_clinic];

create table t_clinic
(
    id            bigint identity (1, 1)
        primary key,
    patient_id    varchar(510),
    patient_name  varchar(510),
    times         int,
    receipt_no    int,
    dept_code     varchar(510),
    doctor_code   varchar(510),
    icd_code      varchar(510),
    icd_text      varchar(510),
    op_id         varchar(510),
    op_day        datetime,
    first_or_not  varchar(2),
    clinic_status int,
    jz_flag       varchar(510),
    zgmztczf      varchar(2),
    exp_content   varchar(510)
)
go

exec sp_addextendedproperty 'MS_Description', '就诊记录表', 'SCHEMA', 'dbo', 'TABLE', 't_clinic'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '病人id', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'patient_id'
go

exec sp_addextendedproperty 'MS_Description', '病人姓名', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'patient_name'
go

exec sp_addextendedproperty 'MS_Description', '就诊次数', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'times'
go

exec sp_addextendedproperty 'MS_Description', '变更次数', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'receipt_no'
go

exec sp_addextendedproperty 'MS_Description', '就诊科室', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'dept_code'
go

exec sp_addextendedproperty 'MS_Description', '就诊医生', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'doctor_code'
go

exec sp_addextendedproperty 'MS_Description', '诊断编码', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'icd_code'
go

exec sp_addextendedproperty 'MS_Description', '诊断名称', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'icd_text'
go

exec sp_addextendedproperty 'MS_Description', '操作人编码', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'op_id'
go

exec sp_addextendedproperty 'MS_Description', '操作时间', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'op_day'
go

exec sp_addextendedproperty 'MS_Description', '初诊或者复诊 0-初诊  1-复诊', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN',
     'first_or_not'
go

exec sp_addextendedproperty 'MS_Description', '就诊状态  -1 挂号未缴费 0 已挂号 1-挂号已接诊  2 -已退号  3-候诊 4-接诊中 5-已接诊未缴费 6-已缴费 7-已退费',
     'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'clinic_status'
go

exec sp_addextendedproperty 'MS_Description', '急诊标记 1 急诊 0非急诊', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN',
     'jz_flag'
go

exec sp_addextendedproperty 'MS_Description', '是否使用职工统筹支付 1是 0否', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN',
     'zgmztczf'
go

exec sp_addextendedproperty 'MS_Description', '门诊统筹额外内容', 'SCHEMA', 'dbo', 'TABLE', 't_clinic', 'COLUMN', 'exp_content'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_common_params]') AND type IN ('U'))
    DROP TABLE [dbo].[t_common_params];

create table t_common_params
(
    id             bigint identity (1, 1)
        primary key,
    params_name    varchar(510),
    py_code        varchar(510),
    wb_code        varchar(510),
    params_type    int,
    create_id_code varchar(40),
    create_time    datetime,
    params_status  int,
    update_id_code varchar(510),
    update_time    datetime,
    used_times     bigint,
    params_code    varchar(510),
    params_content varchar(800)
)
go

exec sp_addextendedproperty 'MS_Description', '新门诊通用参数表', 'SCHEMA', 'dbo', 'TABLE', 't_common_params'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '参数名称', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'params_name'
go

exec sp_addextendedproperty 'MS_Description', '拼音码', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN', 'py_code'
go

exec sp_addextendedproperty 'MS_Description', '五笔码', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN', 'wb_code'
go

exec sp_addextendedproperty 'MS_Description',
     '参数类型  0-常用症状  1-常用时间  2-常用标点 3-常用词 4- 诊断 5-现病史 6-家族史 7-体重 8-体温 9-脉搏 10-呼吸 11-血压  12-主诉', 'SCHEMA', 'dbo', 'TABLE',
     't_common_params', 'COLUMN', 'params_type'
go

exec sp_addextendedproperty 'MS_Description', '创建人老系统编码', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'create_id_code'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'create_time'
go

exec sp_addextendedproperty 'MS_Description', '状态 0 有效  1 失效', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'params_status'
go

exec sp_addextendedproperty 'MS_Description', '修改人老系统编码', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'update_id_code'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'update_time'
go

exec sp_addextendedproperty 'MS_Description', '使用频率', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'used_times'
go

exec sp_addextendedproperty 'MS_Description', '参数编码   基本是诊断使用', 'SCHEMA', 'dbo', 'TABLE', 't_common_params', 'COLUMN',
     'params_code'
go

exec sp_addextendedproperty 'MS_Description', '大长度参数的正式内容，如病史和主诉等', 'SCHEMA', 'dbo', 'TABLE', 't_common_params',
     'COLUMN', 'params_content'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_config]') AND type IN ('U'))
    DROP TABLE [dbo].[t_config];

create table t_config
(
    id           bigint identity (1, 1)
        primary key,
    config_key   varchar(510),
    config_value varchar(4000),
    create_id    bigint,
    create_date  datetime,
    remark       varchar(510)
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '参数的键', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'config_key'
go

exec sp_addextendedproperty 'MS_Description', '参数的值', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'config_value'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'create_date'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_config', 'COLUMN', 'remark'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_cooperative_enterprise]') AND type IN ('U'))
    DROP TABLE [dbo].[t_cooperative_enterprise];

create table t_cooperative_enterprise
(
    id                          bigint identity (1, 1)
        primary key,
    contract_no                 varchar(510),
    cooperative_enterprise_name varchar(510),
    project_name                varchar(510),
    remark                      varchar(510),
    create_id                   bigint,
    create_date                 datetime,
    update_id                   bigint,
    update_date                 datetime
)
go

exec sp_addextendedproperty 'MS_Description', '临床试验室合作企业与合同号信息表', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '合同编号', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'contract_no'
go

exec sp_addextendedproperty 'MS_Description', '合作企业名称', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'cooperative_enterprise_name'
go

exec sp_addextendedproperty 'MS_Description', '项目名称', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'project_name'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'remark'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'create_date'
go

exec sp_addextendedproperty 'MS_Description', '修改人', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_cooperative_enterprise', 'COLUMN',
     'update_date'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_critical_value]') AND type IN ('U'))
    DROP TABLE [dbo].[t_critical_value];


create table t_critical_value
(
    id             bigint identity (1, 1)
        primary key,
    employee_codes text,
    content        text,
    create_time    datetime
)
go

exec sp_addextendedproperty 'MS_Description', '危急值接收人编码串', 'SCHEMA', 'dbo', 'TABLE', 't_critical_value', 'COLUMN',
     'employee_codes'
go

exec sp_addextendedproperty 'MS_Description', '危急值内容', 'SCHEMA', 'dbo', 'TABLE', 't_critical_value', 'COLUMN', 'content'
go

exec sp_addextendedproperty 'MS_Description', '记录时间', 'SCHEMA', 'dbo', 'TABLE', 't_critical_value', 'COLUMN',
     'create_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_daily_ward_statistics]') AND type IN ('U'))
    DROP TABLE [dbo].[t_daily_ward_statistics];


create table t_daily_ward_statistics
(
    id        bigint identity (1, 1)
        primary key,
    ward_code varchar(24),
    ward_name varchar(64),
    t_date    datetime,
    total_no  int,
    today_in  int,
    today_out int,
    serious   int,
    danger    int,
    surgery   int
)
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_discount]') AND type IN ('U'))
    DROP TABLE [dbo].[t_discount];


create table t_discount
(
    id                  bigint identity (1, 1)
        primary key,
    name                varchar(510),
    dept_type           int,
    dept_no             varchar(4096),
    discount_begin_time datetime,
    discount_end_time   datetime,
    charge_item_codes   varchar(4096),
    discount_type       int,
    discount_rate       decimal(10, 2),
    discount_price      decimal(10, 2),
    delete_flag         int,
    create_id           varchar(40),
    create_time         datetime,
    update_id           varchar(40),
    update_time         datetime,
    template_id         bigint,
    description         text
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '营销计划名称', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'name'
go

exec sp_addextendedproperty 'MS_Description', '0-申请科室  1 -执行科室', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'dept_type'
go

exec sp_addextendedproperty 'MS_Description', '科室编码', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'dept_no'
go

exec sp_addextendedproperty 'MS_Description', '营销开始时间', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'discount_begin_time'
go

exec sp_addextendedproperty 'MS_Description', '营销结束时间', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'discount_end_time'
go

exec sp_addextendedproperty 'MS_Description', '收费项目编码串，用英文逗号分开', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'charge_item_codes'
go

exec sp_addextendedproperty 'MS_Description', '优惠类型  0 -单价优惠 1-折扣率', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'discount_type'
go

exec sp_addextendedproperty 'MS_Description', '折扣率', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'discount_rate'
go

exec sp_addextendedproperty 'MS_Description', '优惠价', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'discount_price'
go

exec sp_addextendedproperty 'MS_Description', '删除标记 0 启用  1 停用 ', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN',
     'delete_flag'
go

exec sp_addextendedproperty 'MS_Description', '创建人ID', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '修改人ID', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '模板表id', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'template_id'
go

exec sp_addextendedproperty 'MS_Description', '套餐描述', 'SCHEMA', 'dbo', 'TABLE', 't_discount', 'COLUMN', 'description'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_dispensing_windows]') AND type IN ('U'))
    DROP TABLE [dbo].[t_dispensing_windows];

create table t_dispensing_windows
(
    id                bigint identity (1, 1)
        primary key,
    group_no          varchar(510),
    windows_no        int,
    mz_cf_print_index int,
    ek_cf_print_index int,
    jz_cf_print_index int,
    zsd_print_index   int,
    bq_print_index    int,
    fsk_print_index   int,
    user_id_code      varchar(40),
    ip_address        varchar(40),
    create_date       datetime,
    update_date       datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '发药药房', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'group_no'
go

exec sp_addextendedproperty 'MS_Description', '窗口号', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'windows_no'
go

exec sp_addextendedproperty 'MS_Description', '默认门诊处方打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'mz_cf_print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认儿科处方打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'ek_cf_print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认急诊处方打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'jz_cf_print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认注射单打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'zsd_print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认标签打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'bq_print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认放射科发药清单打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows',
     'COLUMN', 'fsk_print_index'
go

exec sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', 'ip地址', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'ip_address'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'create_date'
go

exec sp_addextendedproperty 'MS_Description', '当前设置的更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_dispensing_windows', 'COLUMN',
     'update_date'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_evaluate]') AND type IN ('U'))
    DROP TABLE [dbo].[t_evaluate];


create table t_evaluate
(
    id            bigint identity (1, 1)
        primary key,
    patient_id    varchar(20),
    patient_name  varchar(510),
    user_id_code  varchar(510),
    user_name     varchar(510),
    evaluate      int,
    evaluate_time datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '门诊病人id', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'patient_id'
go

exec sp_addextendedproperty 'MS_Description', '患者姓名', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'patient_name'
go

exec sp_addextendedproperty 'MS_Description', '被评价人编码', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '被评价人姓名', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'user_name'
go

exec sp_addextendedproperty 'MS_Description', '评价满意度  0 非常满意  1满意  2 态度不好  3 效率不高  4 业务不熟 5  有待提高', 'SCHEMA', 'dbo',
     'TABLE', 't_evaluate', 'COLUMN', 'evaluate'
go

exec sp_addextendedproperty 'MS_Description', '评价时间', 'SCHEMA', 'dbo', 'TABLE', 't_evaluate', 'COLUMN', 'evaluate_time'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_file_upload]') AND type IN ('U'))
    DROP TABLE [dbo].[t_file_upload];

create table t_file_upload
(
    id          bigint identity (1, 1)
        primary key,
    file_name   varchar(510),
    file_data      varbinary(max),
    file_type   varchar(4),
    mime_type   varchar(510),
    create_time datetime,
    create_user bigint,
    square_file varbinary(max)
)
go

exec sp_addextendedproperty 'MS_Description', '文件表', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '文件名称', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN', 'file_name'
go

exec sp_addextendedproperty 'MS_Description', '原文件内容字节数组', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN', 'file_data'
go

exec sp_addextendedproperty 'MS_Description', '文件类型 0 - 头像  1-身份证正面  2 - 身份证背面 ', 'SCHEMA', 'dbo', 'TABLE',
     't_file_upload', 'COLUMN', 'file_type'
go

exec sp_addextendedproperty 'MS_Description', '文件格式，它将帮助浏览器建议在下载时打开文件的方法', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload',
     'COLUMN', 'mime_type'
go

exec sp_addextendedproperty 'MS_Description', '创建日期', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN', 'create_user'
go

exec sp_addextendedproperty 'MS_Description', '转码成方形的字节数组', 'SCHEMA', 'dbo', 'TABLE', 't_file_upload', 'COLUMN',
     'square_file'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_holidays]') AND type IN ('U'))
    DROP TABLE [dbo].[t_holidays];


create table t_holidays
(
    id          bigint identity (1, 1)
        primary key,
    begin_date  date,
    begin_ampm  varchar(510),
    end_date    date,
    end_ampm    varchar(510),
    create_id   bigint,
    create_date datetime,
    update_id   bigint,
    update_date datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '开始日期', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'begin_date'
go

exec sp_addextendedproperty 'MS_Description', '开始日期的上下午', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'begin_ampm'
go

exec sp_addextendedproperty 'MS_Description', '结束日期', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'end_date'
go

exec sp_addextendedproperty 'MS_Description', '结束日期的上下午', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'end_ampm'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'create_date'
go

exec sp_addextendedproperty 'MS_Description', '修改人', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_holidays', 'COLUMN', 'update_date'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_hybird_test]') AND type IN ('U'))
    DROP TABLE [dbo].[t_hybird_test];


create table t_hybird_test
(
    id                bigint identity (1, 1)
        primary key,
    parent_patient_id varchar(510),
    patient_id        varchar(510),
    times             bigint,
    create_date       datetime
)
go

exec sp_addextendedproperty 'MS_Description', '混检主体id', 'SCHEMA', 'dbo', 'TABLE', 't_hybird_test', 'COLUMN',
     'parent_patient_id'
go

exec sp_addextendedproperty 'MS_Description', '实际被检人id', 'SCHEMA', 'dbo', 'TABLE', 't_hybird_test', 'COLUMN',
     'patient_id'
go

exec sp_addextendedproperty 'MS_Description', '实际被检人缴费次数 ', 'SCHEMA', 'dbo', 'TABLE', 't_hybird_test', 'COLUMN', 'times'
go

exec sp_addextendedproperty 'MS_Description', '记录时间', 'SCHEMA', 'dbo', 'TABLE', 't_hybird_test', 'COLUMN', 'create_date'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_menu]') AND type IN ('U'))
    DROP TABLE [dbo].[t_menu];


create table t_menu
(
    id          bigint identity (1, 1)
        primary key,
    name        varchar(510),
    parent_id   bigint,
    class_code  varchar(510),
    menu_url    varchar(510),
    sort_value  int,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '菜单表', 'SCHEMA', 'dbo', 'TABLE', 't_menu'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '菜单名称', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'name'
go

exec sp_addextendedproperty 'MS_Description', '父菜单id
父菜单id', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'parent_id'
go

exec sp_addextendedproperty 'MS_Description', '菜单图标样式 只有一级主菜单才有该字段', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN',
     'class_code'
go

exec sp_addextendedproperty 'MS_Description', '菜单地址 只有最基础的菜单才有地址', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN',
     'menu_url'
go

exec sp_addextendedproperty 'MS_Description', '排序字段 ，越小越优先', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'sort_value'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人id', 'SCHEMA', 'dbo', 'TABLE', 't_menu', 'COLUMN', 'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_mzmxsr]') AND type IN ('U'))
    DROP TABLE [dbo].[t_mzmxsr];


create table t_mzmxsr
(
    id           bigint identity (1, 1)
        primary key,
    xm           varchar(510),
    patient_id   varchar(510),
    jz_sq_dept   varchar(510),
    jz_sq_doctor varchar(510),
    exec_dept    varchar(510),
    xmm          varchar(510),
    hsm          varchar(510),
    je           decimal(10, 2),
    charge_date  datetime,
    dcount_date  datetime,
    quty         decimal(18, 4),
    price        decimal(10, 2),
    parent_code  varchar(510),
    input_date   datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '姓名', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'xm'
go

exec sp_addextendedproperty 'MS_Description', '病人id', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'patient_id'
go

exec sp_addextendedproperty 'MS_Description', '就诊/申请科室', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'jz_sq_dept'
go

exec sp_addextendedproperty 'MS_Description', '就诊/申请医生', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'jz_sq_doctor'
go

exec sp_addextendedproperty 'MS_Description', '执行科室', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'exec_dept'
go

exec sp_addextendedproperty 'MS_Description', '项目名', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'xmm'
go

exec sp_addextendedproperty 'MS_Description', '核算码', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'hsm'
go

exec sp_addextendedproperty 'MS_Description', '金额', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'je'
go

exec sp_addextendedproperty 'MS_Description', '缴费时间', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'charge_date'
go

exec sp_addextendedproperty 'MS_Description', '日结时间', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'dcount_date'
go

exec sp_addextendedproperty 'MS_Description', '数量', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'quty'
go

exec sp_addextendedproperty 'MS_Description', '单价', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'price'
go

exec sp_addextendedproperty 'MS_Description', '父类码', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'parent_code'
go

exec sp_addextendedproperty 'MS_Description', '同步入库时间', 'SCHEMA', 'dbo', 'TABLE', 't_mzmxsr', 'COLUMN', 'input_date'
go



IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_notice]') AND type IN ('U'))
    DROP TABLE [dbo].[t_notice];


create table t_notice
(
    id             bigint identity (1, 1)
        primary key,
    notice_content text,
    notice_type    int,
    send_user_code varchar(510),
    send_time      datetime,
    notice_status  int,
    update_id      varchar(40),
    update_time    datetime
)
go

exec sp_addextendedproperty 'MS_Description', '通知消息表', 'SCHEMA', 'dbo', 'TABLE', 't_notice'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '通知内容', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN', 'notice_content'
go

exec sp_addextendedproperty 'MS_Description', '通知类型 1 -系统通知 2 -业务消息', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN',
     'notice_type'
go

exec sp_addextendedproperty 'MS_Description', '发送用户编码  系统消息是空', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN',
     'send_user_code'
go

exec sp_addextendedproperty 'MS_Description', '发送时间', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN', 'send_time'
go

exec sp_addextendedproperty 'MS_Description', '消息状态 0 有效  1 失效', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN',
     'notice_status'
go

exec sp_addextendedproperty 'MS_Description', '修改人ID', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN', 'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_notice', 'COLUMN', 'update_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_notice_sink]') AND type IN ('U'))
    DROP TABLE [dbo].[t_notice_sink];


create table t_notice_sink
(
    id                    bigint identity (1, 1)
        primary key,
    notice_id             bigint,
    target_user_id        varchar(40),
    notice_reading_status int,
    read_time             datetime
)
go

exec sp_addextendedproperty 'MS_Description', '消息id', 'SCHEMA', 'dbo', 'TABLE', 't_notice_sink', 'COLUMN', 'notice_id'
go

exec sp_addextendedproperty 'MS_Description', '接收人编码', 'SCHEMA', 'dbo', 'TABLE', 't_notice_sink', 'COLUMN',
     'target_user_id'
go

exec sp_addextendedproperty 'MS_Description', '消息阅读状态 0 未读  1 已读', 'SCHEMA', 'dbo', 'TABLE', 't_notice_sink', 'COLUMN',
     'notice_reading_status'
go

exec sp_addextendedproperty 'MS_Description', '消息读取时间', 'SCHEMA', 'dbo', 'TABLE', 't_notice_sink', 'COLUMN', 'read_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_receipt]') AND type IN ('U'))
    DROP TABLE [dbo].[t_receipt];


create table t_receipt
(
    id                 bigint identity (1, 1)
        primary key,
    user_id_code       varchar(40),
    receipt_begin      varchar(510),
    receipt_end        varchar(510),
    receipt_current    varchar(510),
    zy_receipt_begin   varchar(510),
    zy_receipt_end     varchar(510),
    zy_receipt_current varchar(510),
    update_date        datetime
)
go

exec sp_addextendedproperty 'MS_Description', 'key', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN', 'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '门诊发票开始', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN', 'receipt_begin'
go

exec sp_addextendedproperty 'MS_Description', '门诊发票结尾', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN', 'receipt_end'
go

exec sp_addextendedproperty 'MS_Description', '门诊发票当前发票号', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN',
     'receipt_current'
go

exec sp_addextendedproperty 'MS_Description', '住院发票开始', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN',
     'zy_receipt_begin'
go

exec sp_addextendedproperty 'MS_Description', '住院发票结尾', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN',
     'zy_receipt_end'
go

exec sp_addextendedproperty 'MS_Description', '住院发票当前发票号', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN',
     'zy_receipt_current'
go

exec sp_addextendedproperty 'MS_Description', '当前发票范围维护时间', 'SCHEMA', 'dbo', 'TABLE', 't_receipt', 'COLUMN',
     'update_date'
go

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_reqrec_request_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_reqrec_request_relation];


create table t_reqrec_request_relation
(
    id         bigint identity (1, 1)
        primary key,
    request_id bigint,
    serial_no  int,
    op_date    datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_reqrec_request_relation', 'COLUMN',
     'id'
go

exec sp_addextendedproperty 'MS_Description', '号表主键', 'SCHEMA', 'dbo', 'TABLE', 't_reqrec_request_relation', 'COLUMN',
     'request_id'
go

exec sp_addextendedproperty 'MS_Description', '挂号流水号', 'SCHEMA', 'dbo', 'TABLE', 't_reqrec_request_relation', 'COLUMN',
     'serial_no'
go

exec sp_addextendedproperty 'MS_Description', '操作时间', 'SCHEMA', 'dbo', 'TABLE', 't_reqrec_request_relation', 'COLUMN',
     'op_date'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_role]') AND type IN ('U'))
    DROP TABLE [dbo].[t_role];


create table t_role
(
    id          bigint identity (1, 1)
        primary key,
    role_name   varchar(120),
    remark      varchar(510),
    create_time datetime,
    create_id   bigint,
    update_time datetime,
    update_id   bigint,
    del_flag    bit
)
go

exec sp_addextendedproperty 'MS_Description', '角色表', 'SCHEMA', 'dbo', 'TABLE', 't_role'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '角色名称', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'role_name'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'remark'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN', 'update_id'
go

exec sp_addextendedproperty 'MS_Description', '是否有效（0：有效 1：无效）', 'SCHEMA', 'dbo', 'TABLE', 't_role', 'COLUMN',
     'del_flag'
go



IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_role_button_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_role_button_relation];


create table t_role_button_relation
(
    id          bigint identity (1, 1)
        primary key,
    role_id     bigint,
    button_id   bigint,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '角色和按钮关联表', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '角色ID', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation', 'COLUMN',
     'role_id'
go

exec sp_addextendedproperty 'MS_Description', '按钮ID', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation', 'COLUMN',
     'button_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation', 'COLUMN',
     'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_role_button_relation', 'COLUMN',
     'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_role_menu_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_role_menu_relation];


create table t_role_menu_relation
(
    id          bigint identity (1, 1)
        primary key,
    role_id     bigint,
    menu_id     bigint,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '角色和菜单关联表', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '角色ID', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation', 'COLUMN',
     'role_id'
go

exec sp_addextendedproperty 'MS_Description', '菜单ID', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation', 'COLUMN',
     'menu_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation', 'COLUMN',
     'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_role_menu_relation', 'COLUMN',
     'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_schedule_of_medical]') AND type IN ('U'))
    DROP TABLE [dbo].[t_schedule_of_medical];


create table t_schedule_of_medical
(
    id          bigint identity (1, 1)
        primary key,
    dep_no      varchar(200),
    jcxm        varchar(510),
    room_num    int,
    record_date varchar(20),
    begin_time  varchar(10),
    end_time    varchar(10),
    status      int,
    create_id   bigint,
    create_date datetime,
    update_id   bigint,
    update_date datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '科室编码', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'dep_no'
go

exec sp_addextendedproperty 'MS_Description', '检查项目', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'jcxm'
go

exec sp_addextendedproperty 'MS_Description', '诊室号码', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'room_num'
go

exec sp_addextendedproperty 'MS_Description', '日期', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'record_date'
go

exec sp_addextendedproperty 'MS_Description', '开始时间', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'begin_time'
go

exec sp_addextendedproperty 'MS_Description', '结束时间', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'end_time'
go

exec sp_addextendedproperty 'MS_Description', '状态  0 空闲  1 占用', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical',
     'COLUMN', 'status'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'create_date'
go

exec sp_addextendedproperty 'MS_Description', '修改人', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical', 'COLUMN',
     'update_date'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_schedule_of_medical_apply]') AND type IN ('U'))
    DROP TABLE [dbo].[t_schedule_of_medical_apply];


create table t_schedule_of_medical_apply
(
    id             bigint identity (1, 1)
        primary key,
    schedule_id    bigint,
    xdtjcjg        int,
    act_order_no   varchar(510),
    remark         varchar(510),
    create_dept_no varchar(40),
    create_id      bigint,
    create_time    datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply', 'COLUMN',
     'id'
go

exec sp_addextendedproperty 'MS_Description', '档期id', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply', 'COLUMN',
     'schedule_id'
go

exec sp_addextendedproperty 'MS_Description', '心电图检查结果  0 正常  1 不正常', 'SCHEMA', 'dbo', 'TABLE',
     't_schedule_of_medical_apply', 'COLUMN', 'xdtjcjg'
go

exec sp_addextendedproperty 'MS_Description', '医嘱号码', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply', 'COLUMN',
     'act_order_no'
go

exec sp_addextendedproperty 'MS_Description', '备注说明', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply', 'COLUMN',
     'remark'
go

exec sp_addextendedproperty 'MS_Description', '预约发起科室部门 或者外部合作单位', 'SCHEMA', 'dbo', 'TABLE',
     't_schedule_of_medical_apply', 'COLUMN', 'create_dept_no'
go

exec sp_addextendedproperty 'MS_Description', '预约人id', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply',
     'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '预约时间', 'SCHEMA', 'dbo', 'TABLE', 't_schedule_of_medical_apply', 'COLUMN',
     'create_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_si_failed_sql]') AND type IN ('U'))
    DROP TABLE [dbo].[t_si_failed_sql];

create table t_si_failed_sql
(
    id               bigint identity (1, 1)
        primary key,
    sql_content      varchar(2048),
    create_datetime  datetime,
    executed         int,
    execute_datetime datetime
)
go

exec sp_addextendedproperty 'MS_Description', '由于死锁而执行失败的关键sql', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql'
go

exec sp_addextendedproperty 'MS_Description', '自增ID', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', 'sql内容', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql', 'COLUMN',
     'sql_content'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql', 'COLUMN',
     'create_datetime'
go

exec sp_addextendedproperty 'MS_Description', '是否已执行成功：1-是 0-否', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql', 'COLUMN',
     'executed'
go

exec sp_addextendedproperty 'MS_Description', '成功执行的时间', 'SCHEMA', 'dbo', 'TABLE', 't_si_failed_sql', 'COLUMN',
     'execute_datetime'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_template]') AND type IN ('U'))
    DROP TABLE [dbo].[t_template];


create table t_template
(
    id                 bigint identity (1, 1)
        primary key,
    name               varchar(510),
    icd_text           text,
    template_kind_type int,
    template_type      int,
    template_data      text,
    create_id          varchar(40),
    dept_no            varchar(40),
    template_status    int,
    used_times         int,
    create_time        datetime,
    update_id          varchar(40),
    update_time        datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '医疗范文名称', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'name'
go

exec sp_addextendedproperty 'MS_Description', '诊断名称', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'icd_text'
go

exec sp_addextendedproperty 'MS_Description', '0-西成药  1-中草药 2-诊疗 3-检查 4-检验 5-入院 6-综合', 'SCHEMA', 'dbo', 'TABLE',
     't_template', 'COLUMN', 'template_kind_type'
go

exec sp_addextendedproperty 'MS_Description', '0-个人模板  1-科室模板 2-全院模板', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN',
     'template_type'
go

exec sp_addextendedproperty 'MS_Description', '模板内容', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'template_data'
go

exec sp_addextendedproperty 'MS_Description', '创建人ID', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'create_id'
go

exec sp_addextendedproperty 'MS_Description', '科室编码', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'dept_no'
go

exec sp_addextendedproperty 'MS_Description', '模板状态  0 启用 1 停用', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN',
     'template_status'
go

exec sp_addextendedproperty 'MS_Description', '使用次数', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'used_times'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '修改人ID', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_template', 'COLUMN', 'update_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_token]') AND type IN ('U'))
    DROP TABLE [dbo].[t_token];

create table t_token
(
    id          bigint identity (1, 1)
        primary key,
    token       varchar(1600),
    dead_time   datetime,
    create_time datetime
)
go

exec sp_addextendedproperty 'MS_Description', '注销了以后，还没有到失效时间的token   token黑名单', 'SCHEMA', 'dbo', 'TABLE', 't_token'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_token', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', 'token值', 'SCHEMA', 'dbo', 'TABLE', 't_token', 'COLUMN', 'token'
go

exec sp_addextendedproperty 'MS_Description', '失效时间', 'SCHEMA', 'dbo', 'TABLE', 't_token', 'COLUMN', 'dead_time'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_token', 'COLUMN', 'create_time'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_turn_to_consultation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_turn_to_consultation];


create table t_turn_to_consultation
(
    id               bigint identity (1, 1)
        primary key,
    patient_id       varchar(510),
    source_dept_no   varchar(510),
    source_doctor_no varchar(510),
    target_dept_no   varchar(510),
    target_doctor_no varchar(510),
    serial_no        varchar(510),
    remark           varchar(510),
    op_type          int,
    op_date          datetime
)
go

exec sp_addextendedproperty 'MS_Description', '患者ID', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'patient_id'
go

exec sp_addextendedproperty 'MS_Description', '请求科室', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'source_dept_no'
go

exec sp_addextendedproperty 'MS_Description', '请求医生', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'source_doctor_no'
go

exec sp_addextendedproperty 'MS_Description', '目标科室', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'target_dept_no'
go

exec sp_addextendedproperty 'MS_Description', '目标医生', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'target_doctor_no'
go

exec sp_addextendedproperty 'MS_Description', '分诊流水号', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'serial_no'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'remark'
go

exec sp_addextendedproperty 'MS_Description', '1-转诊 2 会诊', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'op_type'
go

exec sp_addextendedproperty 'MS_Description', '操作日期', 'SCHEMA', 'dbo', 'TABLE', 't_turn_to_consultation', 'COLUMN',
     'op_date'
go



IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_user]') AND type IN ('U'))
    DROP TABLE [dbo].[t_user];

create table t_user
(
    id                   bigint identity (1, 1)
        primary key,
    user_id_code         varchar(40),
    user_code            varchar(40),
    user_name            varchar(120),
    password             varchar(510),
    id_card              varchar(510),
    create_time          datetime,
    create_user          bigint,
    update_time          datetime,
    update_user          bigint,
    status               int,
    profile_image        bigint,
    email                varchar(510),
    phone_number         varchar(22),
    gender               varchar(2),
    lock_screen_password varchar(510),
    client_profile_image bigint
)
go

exec sp_addextendedproperty 'MS_Description', '用户表', 'SCHEMA', 'dbo', 'TABLE', 't_user'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '老系统员工编码', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '工号', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'user_code'
go

exec sp_addextendedproperty 'MS_Description', '姓名', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'user_name'
go

exec sp_addextendedproperty 'MS_Description', '密码', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'password'
go

exec sp_addextendedproperty 'MS_Description', '身份证号码', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'id_card'
go

exec sp_addextendedproperty 'MS_Description', '创建日期', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'create_user'
go

exec sp_addextendedproperty 'MS_Description', '更新时期', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '变更人', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'update_user'
go

exec sp_addextendedproperty 'MS_Description', '状态 0-- 在职  1--停薪留职  2-- 离职  3--退休', 'SCHEMA', 'dbo', 'TABLE', 't_user',
     'COLUMN', 'status'
go

exec sp_addextendedproperty 'MS_Description', '头像地址主键', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'profile_image'
go

exec sp_addextendedproperty 'MS_Description', '邮箱', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'email'
go

exec sp_addextendedproperty 'MS_Description', '电话号码', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'phone_number'
go

exec sp_addextendedproperty 'MS_Description', '性别 0 女 1 男', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN', 'gender'
go

exec sp_addextendedproperty 'MS_Description', '锁屏密码', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN',
     'lock_screen_password'
go

exec sp_addextendedproperty 'MS_Description', '评价器展示头像地址主键', 'SCHEMA', 'dbo', 'TABLE', 't_user', 'COLUMN',
     'client_profile_image'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_user_dept_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_user_dept_relation];


create table t_user_dept_relation
(
    id           bigint identity (1, 1)
        primary key,
    dept_no      varchar(510),
    user_id_code varchar(510),
    op_id        varchar(510),
    op_date      datetime
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_user_dept_relation', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '科室编码', 'SCHEMA', 'dbo', 'TABLE', 't_user_dept_relation', 'COLUMN',
     'dept_no'
go

exec sp_addextendedproperty 'MS_Description', '员工编码', 'SCHEMA', 'dbo', 'TABLE', 't_user_dept_relation', 'COLUMN',
     'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '操作人id', 'SCHEMA', 'dbo', 'TABLE', 't_user_dept_relation', 'COLUMN',
     'op_id'
go

exec sp_addextendedproperty 'MS_Description', '操作时间', 'SCHEMA', 'dbo', 'TABLE', 't_user_dept_relation', 'COLUMN',
     'op_date'
go



IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_user_menu_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_user_menu_relation];


create table t_user_menu_relation
(
    id          bigint identity (1, 1)
        primary key,
    user_id     bigint,
    menu_id     bigint,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '用户与菜单关系表', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation', 'COLUMN',
     'user_id'
go

exec sp_addextendedproperty 'MS_Description', '菜单id', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation', 'COLUMN',
     'menu_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation', 'COLUMN',
     'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人id', 'SCHEMA', 'dbo', 'TABLE', 't_user_menu_relation', 'COLUMN',
     'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_user_role_relation]') AND type IN ('U'))
    DROP TABLE [dbo].[t_user_role_relation];


create table t_user_role_relation
(
    id          bigint identity (1, 1)
        primary key,
    user_id     bigint,
    role_id     bigint,
    create_time datetime,
    create_id   bigint
)
go

exec sp_addextendedproperty 'MS_Description', '用户和角色关联表', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '用户ID', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation', 'COLUMN',
     'user_id'
go

exec sp_addextendedproperty 'MS_Description', '角色ID', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation', 'COLUMN',
     'role_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation', 'COLUMN',
     'create_time'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_user_role_relation', 'COLUMN',
     'create_id'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_white_list]') AND type IN ('U'))
    DROP TABLE [dbo].[t_white_list];


create table t_white_list
(
    id         bigint identity (1, 1)
        primary key,
    ip_address varchar(510),
    op_id      varchar(510),
    remark     varchar(510)
)
go

exec sp_addextendedproperty 'MS_Description', '白名单ip地址', 'SCHEMA', 'dbo', 'TABLE', 't_white_list', 'COLUMN',
     'ip_address'
go

exec sp_addextendedproperty 'MS_Description', '白名单对应的操作人id', 'SCHEMA', 'dbo', 'TABLE', 't_white_list', 'COLUMN', 'op_id'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_white_list', 'COLUMN', 'remark'
go


IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_windows]') AND type IN ('U'))
    DROP TABLE [dbo].[t_windows];


create table t_windows
(
    id                             bigint identity (1, 1)
        primary key,
    dept_no                        varchar(510),
    windows_no                     int,
    print_index                    int,
    cg_print_index                 int,
    user_id_code                   varchar(40),
    create_date                    datetime,
    update_date                    datetime,
    zy_print_index                 int,
    ip_address                     varchar(40),
    client_ip_address              varchar(40),
    mis_pos_router_code            varchar(510),
    normal_wrist_strap_print_index int,
    child_wrist_strap_print_index  int
)
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', '院区  mz_zd_dept_no', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'dept_no'
go

exec sp_addextendedproperty 'MS_Description', '窗口号', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN', 'windows_no'
go

exec sp_addextendedproperty 'MS_Description', '默认发票打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'print_index'
go

exec sp_addextendedproperty 'MS_Description', '默认常规打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'cg_print_index'
go

exec sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN', 'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN', 'create_date'
go

exec sp_addextendedproperty 'MS_Description', '当前设置的更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'update_date'
go

exec sp_addextendedproperty 'MS_Description', '默认住院发票打印机下标', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'zy_print_index'
go

exec sp_addextendedproperty 'MS_Description', 'ip地址', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN', 'ip_address'
go

exec sp_addextendedproperty 'MS_Description', '评价器客户端ip地址', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'client_ip_address'
go

exec sp_addextendedproperty 'MS_Description', 'misPos 终端路由识别码', 'SCHEMA', 'dbo', 'TABLE', 't_windows', 'COLUMN',
     'mis_pos_router_code'
go



IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_workspace_config]') AND type IN ('U'))
    DROP TABLE [dbo].[t_workspace_config];


create table t_workspace_config
(
    id                       bigint identity (1, 1)
        primary key,
    user_id_code             varchar(510),
    symptom_flag             int,
    emr_hpi_flag             int,
    emr_ps_flag              int,
    personal_history_flag    int,
    family_history_flag      int,
    obsterical_history_flag  int,
    pressure_left_flag       int,
    tentative_diagnosis_flag int,
    checkbox_flag            int,
    zl_print_flag            int,
    create_id                bigint,
    create_date              datetime,
    update_id                bigint,
    update_date              datetime,
    fz_zl_flag               int
)
go

exec sp_addextendedproperty 'MS_Description', '医生工作台配置表', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config'
go

exec sp_addextendedproperty 'MS_Description', '医生编码', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config', 'COLUMN',
     'user_id_code'
go

exec sp_addextendedproperty 'MS_Description', '主诉 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'symptom_flag'
go

exec sp_addextendedproperty 'MS_Description', '现病史 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'emr_hpi_flag'
go

exec sp_addextendedproperty 'MS_Description', '既往史 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'emr_ps_flag'
go

exec sp_addextendedproperty 'MS_Description', '个人史 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'personal_history_flag'
go

exec sp_addextendedproperty 'MS_Description', '家族史 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'family_history_flag'
go

exec sp_addextendedproperty 'MS_Description', '婚育史 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'obsterical_history_flag'
go

exec sp_addextendedproperty 'MS_Description', ' 血压（左） 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'pressure_left_flag'
go

exec sp_addextendedproperty 'MS_Description', '初步诊断 是否展示  0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'tentative_diagnosis_flag'
go

exec sp_addextendedproperty 'MS_Description', '历史轨迹和处方模板默认勾选  0 勾选 1 不勾选', 'SCHEMA', 'dbo', 'TABLE',
     't_workspace_config', 'COLUMN', 'checkbox_flag'
go

exec sp_addextendedproperty 'MS_Description', '诊疗处方打印  0 打印 1 不打印', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'zl_print_flag'
go

exec sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config', 'COLUMN',
     'create_id'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config', 'COLUMN',
     'create_date'
go

exec sp_addextendedproperty 'MS_Description', '修改人', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config', 'COLUMN',
     'update_id'
go

exec sp_addextendedproperty 'MS_Description', '修改时间', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config', 'COLUMN',
     'update_date'
go

exec sp_addextendedproperty 'MS_Description', '辅助资料 0 展示 1 不展示', 'SCHEMA', 'dbo', 'TABLE', 't_workspace_config',
     'COLUMN', 'fz_zl_flag'
go