hyx

Wiki » 历史记录 » 修订 3

修订 2 (星 yan, 2026-09-23 06:44) → 修订 3/9 (星 yan, 2026-09-23 06:45)

# 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 

 ``` 

 ```