| | |
|---|
| | | USE [zhengcaioa] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | /****** Object: Table [dbo].[ADM_Customer_withdrawal] Script Date: 2021/8/9 13:43:29 ******/ |
|---|
| | | SET ANSI_NULLS ON |
|---|
| | | GO |
|---|
| | | |
|---|
| | | SET QUOTED_IDENTIFIER ON |
|---|
| | | GO |
|---|
| | | |
|---|
| | | CREATE TABLE [dbo].[ADM_Customer_withdrawal]( |
|---|
| | | [Id] [nvarchar](50) NOT NULL, |
|---|
| | | [OrderNo] [nvarchar](50) NULL, |
|---|
| | | [Jine] [money] NULL, |
|---|
| | | [HuiyuanName] [nvarchar](100) NULL, |
|---|
| | | [HuiyuanId] [nvarchar](50) NULL, |
|---|
| | | [HuiyuanPhone] [nvarchar](50) NULL, |
|---|
| | | |
|---|
| | | [BankAcount] [nvarchar](50) NULL, |
|---|
| | | [BankName] [nvarchar](50) NULL, |
|---|
| | | [Username] [nvarchar](50) NULL, |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | [Shenqingtime] [datetime] NOT NULL, |
|---|
| | | [Remark] [nvarchar](500) NULL, |
|---|
| | | [shenpi_status] [nvarchar](1) NULL, |
|---|
| | | [rec_status] [nvarchar](1) NOT NULL, |
|---|
| | | [creater] [nvarchar](50) NOT NULL, |
|---|
| | | [createtime] [datetime] NOT NULL, |
|---|
| | | [modifier] [nvarchar](50) NOT NULL, |
|---|
| | | [modifytime] [datetime] NOT NULL, |
|---|
| | | [createrName] [nvarchar](50) NULL, |
|---|
| | | [tittle] [nvarchar](50) NULL, |
|---|
| | | CONSTRAINT [PK__Customer_withdrawal__3214EC077AC5FA48] PRIMARY KEY CLUSTERED |
|---|
| | | ( |
|---|
| | | [Id] ASC |
|---|
| | | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY] |
|---|
| | | ) ON [PRIMARY] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ((0)) FOR [Jine] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [Shenqingtime] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('D') FOR [shenpi_status] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('A') FOR [rec_status] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [creater] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [createtime] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [modifier] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [modifytime] |
|---|
| | | GO |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | USE [zhengcaioa] |
|---|
| | | GO |
|---|
