huasheng-erp-order-system/script/sql/sqlserver/v1/HS_ERP_Order-create.sql

EXEC sys.sp_addextendedproperty 'MS_Description', N'投诉建议表', 'SCHEMA', N'dbo', 'TABLE', N'sys_complaint'
GO

-- ----------------------------
-- 联系电话管理表（单例表）
-- ----------------------------
create table sys_phone
(
    id              bigint            NOT NULL,
    expert_phone    nvarchar(20)      DEFAULT ('') NULL,
    service_phone   nvarchar(20)      DEFAULT ('') NULL,
    sales_phone     nvarchar(20)      DEFAULT ('') NULL,
    create_dept     bigint,
    create_by       bigint,
    create_time     datetime2(7),
    update_by       bigint,
    update_time     datetime2(7),
    CONSTRAINT PK__sys_phone__id PRIMARY KEY CLUSTERED (id)
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
    ON [PRIMARY]
)
ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty 'MS_Description', N'联系电话ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_phone', 'COLUMN', N'id'
GO
EXEC sys.sp_addextendedproperty 'MS_Description', N'华晟型材专家电话', 'SCHEMA', N'dbo', 'TABLE', N'sys_phone', 'COLUMN', N'expert_phone'
GO
EXEC sys.sp_addextendedproperty 'MS_Description', N'客服电话', 'SCHEMA', N'dbo', 'TABLE', N'sys_phone', 'COLUMN', N'service_phone'
GO
EXEC sys.sp_addextendedproperty 'MS_Description', N'业务员电话', 'SCHEMA', N'dbo', 'TABLE', N'sys_phone', 'COLUMN', N'sales_phone'
GO
EXEC sys.sp_addextendedproperty 'MS_Description', N'联系电话管理表', 'SCHEMA', N'dbo', 'TABLE', N'sys_phone'
GO