SQL¶

CREATE TABLE [dbo].[hyx_guarantee_account_amount] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [account_id] bigint,
  [create_time] datetime  NULL,
  [update_time] datetime  NULL,
  [deleted] bigint  NULL,
  [company_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [total_amount] float DEFAULT 0 NULL
)
GO

ALTER TABLE [dbo].[hyx_guarantee_account_amount] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'企业名称',
'SCHEMA', N'dbo',
'TABLE', N'hyx_guarantee_account_amount',
'COLUMN', N'company_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'账户总金额',
'SCHEMA', N'dbo',
'TABLE', N'hyx_guarantee_account_amount',
'COLUMN', N'total_amount'
GO