表名：ZL_Accountinfo












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否 主键
2BankOfDepositnvarchar500   是 开户行及支行全称
3NameOfDepositnvarchar500   是 开户人真实姓名
4Accountnvarchar500   是 开户帐号
5Namenvarchar500   是 会员真实姓名
6CardIDnvarchar500   是 会员身份证号码
7Lockint40   是 是否绑定用户真实姓名
8UserIdint40   是 所属用户ID
9PayIdint40   是 支付ID

简要说明：

帐户表


CREATE TABLE [dbo].[ZL_Accountinfo](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [BankOfDeposit] [nvarchar](50) NULL,
 [NameOfDeposit] [nvarchar](50) NULL,
 [Account] [nvarchar](50) NULL,
 [Name] [nvarchar](50) NULL,
 [CardID] [nvarchar](50) NULL,
 [Lock] [int] NULL,
 [UserId] [int] NULL,
 [PayId] [int] NULL
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行及支行全称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'BankOfDeposit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户人真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'NameOfDeposit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户帐号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'Account'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'CardID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否绑定用户真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'Lock'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'UserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Accountinfo', @level2type=N'COLUMN',@level2name=N'PayId'
GO

--注意：将清空全表数据

detele from ZL_Accountinfo

--注意：将删除整个表

drop table ZL_Accountinfo

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Accountinfo