hyx

# SQL

```

``` 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

```

```