if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TK伝票F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TK伝票F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TK伝票明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TK伝票明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TM名刺デザインM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TM名刺デザインM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TM名刺データF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TM名刺データF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TS会社M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TS会社M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TS勘定科目M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TS勘定科目M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TS学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TS学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TS演習M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TS演習M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctaAuctionM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctaAuctionM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctaAuctionTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctaAuctionTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctaBannerRoboT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctaBannerRoboT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctaSearchRoboT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctaSearchRoboT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctbBankAccountM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctbBankAccountM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctcCreditAccountM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctcCreditAccountM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctcCreditMemberM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctcCreditMemberM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctdItemM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctdItemM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cteMailTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cteMailTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctgTradeParamT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctgTradeParamT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cthPCompanyM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cthPCompanyM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cthPTenantM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cthPTenantM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cthPTenantTItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cthPTenantTItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cthPVoteDtl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cthPVoteDtl] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctnBuletF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctnBuletF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctnNewsHdr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctnNewsHdr] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctnQandAM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctnQandAM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctnQandATrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctnQandATrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpGroupT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpGroupT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpLoginT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpLoginT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpPracticeM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpPracticeM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpTReport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpTReport] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpTownT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpTownT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctpTradeTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctpTradeTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsCodeTS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsCodeTS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsCodeTSgif]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsCodeTSgif] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsCodeTSgifSeq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsCodeTSgifSeq] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsCodeTU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsCodeTU] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsCodeTUprcItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsCodeTUprcItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctsSystemF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctsSystemF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cttStockM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cttStockM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cttTradeMemberM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@cttTradeMemberM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctxGroupM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctxGroupM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctxLoginF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[W@ctxLoginF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctaAuctionM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctaAuctionM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctaAuctionTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctaAuctionTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctaBannerRoboT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctaBannerRoboT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctaSearchRoboT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctaSearchRoboT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctbBankAccountM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctbBankAccountM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctcCreditAccountM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctcCreditAccountM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctcCreditMemberM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctcCreditMemberM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctdItemM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctdItemM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cteMailTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cteMailTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctgTradeParamT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctgTradeParamT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cthPCompanyM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cthPCompanyM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cthPTenantM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cthPTenantM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cthPTenantTItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cthPTenantTItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cthPVoteDtl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cthPVoteDtl] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctnBuletF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctnBuletF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctnNewsHdr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctnNewsHdr] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctnQandAM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctnQandAM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctnQandATrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctnQandATrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpGroupT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpGroupT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpLoginT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpLoginT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpPracticeM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpPracticeM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpTReport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpTReport] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpTownT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpTownT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctpTradeTrn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctpTradeTrn] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTC] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTS] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTSgif]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTSgif] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTSgifSeq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTSgifSeq] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTU] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsCodeTUprcItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsCodeTUprcItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctsSystemF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctsSystemF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cttStockC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cttStockC] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cttStockM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cttStockM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cttTradeMemberM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cttTradeMemberM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctxGroupM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctxGroupM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctxLoginF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ctxLoginF] GO CREATE TABLE [dbo].[TK伝票F] ( [演習CD] [varchar] (12) NOT NULL , [会社CD] [varchar] (20) NOT NULL , [伝票区分] [smallint] NOT NULL , [伝票番号] [varchar] (12) NOT NULL , [取引日] [datetime] NULL , [伝票処理区分] [smallint] NULL , [伝票摘要] [varchar] (40) NULL , [作成日] [datetime] NULL , [作成AP] [varchar] (30) NULL , [取引先CD] [varchar] (20) NULL , [通常返品区分] [varchar] (1) NULL , [学生番号] [varchar] (12) NULL , [削除フラグ] [smallint] NOT NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TK伝票明細F] ( [演習CD] [varchar] (12) NOT NULL , [会社CD] [varchar] (20) NOT NULL , [伝票区分] [smallint] NOT NULL , [伝票番号] [varchar] (12) NOT NULL , [伝票SEQ] [smallint] NOT NULL , [貸借区分] [varchar] (1) NULL , [勘定CD] [varchar] (4) NULL , [借方金額] [money] NULL , [貸方金額] [money] NULL , [相手勘定] [varchar] (4) NULL , [摘要CD] [varchar] (20) NULL , [摘要] [varchar] (40) NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TM名刺デザインM] ( [名刺デザインCD] [varchar] (12) NOT NULL , [縦横区分] [varchar] (2) NULL , [デザイン] [varchar] (8000) NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TM名刺データF] ( [演習CD] [varchar] (12) NULL , [会社CD] [varchar] (20) NULL , [学生番号] [varchar] (50) NULL , [名刺デザインCD] [varchar] (12) NULL , [会社名称] [varchar] (50) NULL , [肩書] [varchar] (50) NULL , [氏名] [varchar] (50) NULL , [郵便番号] [varchar] (50) NULL , [住所1] [varchar] (50) NULL , [住所2] [varchar] (50) NULL , [電話番号] [varchar] (50) NULL , [メールアドレス] [varchar] (50) NULL , [画像ファイル] [varchar] (250) NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TS会社M] ( [演習CD] [varchar] (12) NOT NULL , [会社CD] [varchar] (20) NOT NULL , [学生番号] [varchar] (12) NULL , [会社名称] [varchar] (40) NULL , [会社略名称] [varchar] (10) NULL , [会社カナ名称] [varchar] (40) NULL , [郵便番号] [varchar] (8) NULL , [住所1] [varchar] (50) NULL , [住所2] [varchar] (50) NULL , [TEL] [varchar] (14) NULL , [FAX] [varchar] (14) NULL , [業種CD] [varchar] (1) NULL , [自社フラグ] [smallint] NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TS勘定科目M] ( [演習CD] [varchar] (12) NOT NULL , [勘定CD] [varchar] (4) NOT NULL , [業種CD] [varchar] (1) NULL , [勘定名称] [varchar] (40) NULL , [勘定略名称] [varchar] (20) NULL , [勘定区分] [varchar] (1) NULL , [勘定細目] [varchar] (1) NULL , [貸借区分] [varchar] (1) NULL , [データ区分] [varchar] (1) NULL , [費用区分] [varchar] (1) NULL , [分析用区分] [varchar] (2) NULL , [集計先勘定] [varchar] (4) NULL , [集計区分] [varchar] (1) NULL , [諸表集計CD] [varchar] (4) NULL , [作成区分] [smallint] NULL , [更新日時] [datetime] NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TS学生M] ( [学生番号] [varchar] (12) NOT NULL , [氏名] [varchar] (30) NULL , [パスワード] [varchar] (12) NULL , [演習CD] [varchar] (12) NULL , [学生グループCD] [varchar] (12) NULL , [最新ログイン日] [datetime] NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TS演習M] ( [演習CD] [varchar] (12) NOT NULL , [演習名称] [varchar] (40) NULL , [演習区分] [varchar] (1) NULL , [演習区分名] [varchar] (20) NULL , [会計開始日] [datetime] NULL , [会計終了日] [datetime] NULL , [消費税] [float] NULL , [利用伝票数区分] [varchar] (1) NULL , [転記区分] [varchar] (1) NULL , [仕入売上進行区分] [varchar] (1) NULL , [銀行処理区分] [varchar] (1) NULL , [手動補助簿表示] [varchar] (2) NULL , [手動仕訳帳表示] [varchar] (2) NULL , [手動仕訳集計表表示] [varchar] (2) NULL , [手動合計残高試算表表示] [varchar] (2) NULL , [手動総勘定元帳表示] [varchar] (2) NULL , [手動貸借対照表表示] [varchar] (2) NULL , [手動損益計算書表示] [varchar] (2) NULL , [手動8桁精算表表示] [varchar] (2) NULL , [自動転記仕訳帳表示] [varchar] (2) NULL , [自動転記仕訳集計表表示] [varchar] (2) NULL , [自動転記合計残高試算表表示] [varchar] (2) NULL , [自動転記総勘定元帳表示] [varchar] (2) NULL , [自動転記貸借対照表表示] [varchar] (2) NULL , [自動転記損益計算書表示] [varchar] (2) NULL , [自動転記8桁精算表表示] [varchar] (2) NULL , [演習管理者パスワード] [varchar] (12) NULL , [予備あ] [varchar] (200) NULL , [予備い] [varchar] (200) NULL , [予備う] [varchar] (200) NULL , [予備1] [int] NULL , [予備2] [int] NULL , [予備3] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctaAuctionM] ( [PracticeCode] [varchar] (8) NOT NULL , [AuctionNo] [int] NOT NULL , [APrivateCode] [varchar] (12) NULL , [ACompanyCode] [varchar] (12) NULL , [ATenantCode] [varchar] (12) NULL , [ALoginId] [varchar] (12) NULL , [ActionName] [varchar] (50) NULL , [ItemCode] [varchar] (12) NULL , [ItemName] [varchar] (40) NULL , [ItemImage] [varchar] (100) NULL , [Remarks] [varchar] (200) NULL , [Qty] [int] NULL , [LimitPrice] [money] NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [AuctionStatus] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctaAuctionTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [AuctionNo] [int] NOT NULL , [BidSeq] [int] NOT NULL , [BPrivateCode] [varchar] (50) NULL , [BCompanyCode] [varchar] (12) NULL , [BTenantCode] [varchar] (12) NULL , [BLoginId] [varchar] (12) NULL , [BidderName] [varchar] (50) NULL , [Comment] [varchar] (200) NULL , [BidQty] [int] NULL , [BidPrice] [money] NULL , [BidDate] [datetime] NULL , [BidFlag] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctaBannerRoboT] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [RoboSeq] [int] NOT NULL , [Title] [varchar] (40) NULL , [Description] [varchar] (7000) NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [LinkUrl] [varchar] (50) NULL , [SCount] [int] NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctaSearchRoboT] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [RoboSeq] [int] NOT NULL , [Title] [varchar] (40) NULL , [Description] [varchar] (7000) NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [LinkUrl] [varchar] (50) NULL , [SCount] [int] NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctbBankAccountM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [AccountName] [varchar] (40) NULL , [Password] [varchar] (8) NULL , [BankLoanLimit] [money] NULL , [StopFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [LoginAction] [smallint] NULL , [CompanyCode] [varchar] (12) NULL , [Comment] [varchar] (200) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctcCreditAccountM] ( [PracticeCode] [varchar] (8) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [CompanyName] [varchar] (40) NULL , [Expirationdate] [datetime] NULL , [CreditRate] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctcCreditMemberM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [MemberCode] [varchar] (20) NULL , [MemberName] [varchar] (40) NULL , [Sign] [varchar] (20) NULL , [Expirationdate] [datetime] NULL , [TrustLimit] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctdItemM] ( [PracticeCode] [varchar] (8) NOT NULL , [ItemCode] [varchar] (4) NOT NULL , [ItemName] [varchar] (40) NULL , [ItemType] [varchar] (20) NULL , [ItemImage] [varchar] (100) NULL , [StandardPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [Remarks] [varchar] (40) NULL , [RegistrationType] [smallint] NULL , [SGroupCode] [varchar] (12) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cteMailTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [MailNo] [int] NOT NULL , [同報MailNo] [int] NULL , [宛先To] [varchar] (8000) NULL , [宛先Cc] [varchar] (8000) NULL , [宛先Bcc] [varchar] (8000) NULL , [SPrivateCode] [varchar] (12) NULL , [SCompanyCode] [varchar] (12) NULL , [STenantCode] [varchar] (12) NULL , [TPrivateCode] [varchar] (12) NULL , [TCompanyCode] [varchar] (12) NULL , [TTenantCode] [varchar] (12) NULL , [ALoginId] [varchar] (12) NULL , [ActNo] [int] NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [ReadFlag] [smallint] NULL , [ReplyFlag] [smallint] NULL , [SndDelFlag] [smallint] NULL , [RecDelFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [添付ファイル] [varchar] (255) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctgTradeParamT] ( [PracticeCode] [varchar] (12) NOT NULL , [Std1] [smallint] NULL , [Std2] [smallint] NULL , [Std3] [smallint] NULL , [Std1_1] [smallint] NULL , [Std1_2] [smallint] NULL , [Std1_3] [smallint] NULL , [Std2_1] [smallint] NULL , [Std2_2] [smallint] NULL , [Std2_3] [smallint] NULL , [Std3_1] [smallint] NULL , [Std3_2] [smallint] NULL , [Std3_3] [smallint] NULL , [ExecFlag] [smallint] NULL , [ExecDate] [datetime] NULL , [ExecAmount] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cthPCompanyM] ( [PracticeCode] [varchar] (8) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [CompanyName] [varchar] (40) NULL , [CompanyKanaName] [varchar] (40) NULL , [CompanyKey] [varchar] (8) NULL , [ZipCode] [varchar] (8) NULL , [Address1] [varchar] (40) NULL , [Address2] [varchar] (40) NULL , [PhoneNo] [varchar] (14) NULL , [FaxNo] [varchar] (14) NULL , [DomainName] [varchar] (50) NULL , [RegistType] [smallint] NULL , [MainBank] [varchar] (12) NULL , [LoginId] [varchar] (12) NULL , [EstablishDate] [datetime] NULL , [CapitalAmount] [money] NULL , [ManagerSalary] [money] NULL , [ManagerMax] [smallint] NULL , [CompanyGuidance] [varchar] (255) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cthPTenantM] ( [PracticeCode] [varchar] (8) NOT NULL , [TownNo] [int] NOT NULL , [TownSeq] [int] NOT NULL , [TenantType] [varchar] (20) NULL , [PrivateCode] [varchar] (12) NULL , [CompanyCode] [varchar] (12) NULL , [TenantCode] [varchar] (12) NULL , [HPMode] [varchar] (2) NULL , [DefaultDoc] [varchar] (1000) NULL , [ExtURL] [varchar] (1000) NULL , [DomainName] [varchar] (255) NULL , [DomainTLD] [varchar] (16) NULL , [TenantName] [varchar] (40) NULL , [TenantNameFont] [varchar] (40) NULL , [TenantNameSize] [varchar] (1) NULL , [TenantCopy] [varchar] (100) NULL , [TenantGuide] [varchar] (255) NULL , [TenantGuideFont] [varchar] (40) NULL , [TenantGuideSize] [varchar] (1) NULL , [CountVTitle1] [varchar] (100) NULL , [CountVTitle2] [varchar] (100) NULL , [CountSTitle1] [varchar] (100) NULL , [CountSTitle2] [varchar] (100) NULL , [CountVisit] [money] NULL , [CountSells] [money] NULL , [CurCode] [varchar] (10) NULL , [ConsumptionTax] [money] NULL , [TransportFlag] [int] NULL , [ShopDiscAmnt] [money] NULL , [ShopDiscRate] [real] NULL , [BackGroundImage] [varchar] (255) NULL , [ShopImage] [varchar] (100) NULL , [ForeImage] [varchar] (100) NULL , [BackImage] [varchar] (100) NULL , [GuideImage] [varchar] (100) NULL , [CountImage] [varchar] (100) NULL , [TenantCopyColor] [varchar] (10) NULL , [TenantForeColor] [varchar] (10) NULL , [TenantBackColor] [varchar] (10) NULL , [GuideForeColor] [varchar] (10) NULL , [GuideBackColor] [varchar] (10) NULL , [ItemPageForeColor] [varchar] (10) NULL , [ItemPageBackColor] [varchar] (10) NULL , [ItemNameForeColor] [varchar] (10) NULL , [ItemNameBackColor] [varchar] (10) NULL , [ShelfForeFont1] [varchar] (40) NULL , [ShelfForeSize1] [varchar] (1) NULL , [ShelfForeColor1] [varchar] (10) NULL , [ShelfBackColor1] [varchar] (10) NULL , [ShelfForeFont2] [varchar] (40) NULL , [ShelfForeSize2] [varchar] (1) NULL , [ShelfForeColor2] [varchar] (10) NULL , [ShelfBackColor2] [varchar] (10) NULL , [ShelfForeFont3] [varchar] (40) NULL , [ShelfForeSize3] [varchar] (1) NULL , [ShelfForeColor3] [varchar] (10) NULL , [ShelfBackColor3] [varchar] (10) NULL , [ShelfForeFont4] [varchar] (40) NULL , [ShelfForeSize4] [varchar] (1) NULL , [ShelfForeColor4] [varchar] (10) NULL , [ShelfBackColor4] [varchar] (10) NULL , [ShelfFrameColor] [varchar] (10) NULL , [ShelfFrameType] [varchar] (1) NULL , [MyHPTitle] [varchar] (40) NULL , [MyHPLink] [varchar] (100) NULL , [MyFileTitle] [varchar] (40) NULL , [MyFileLink] [varchar] (255) NULL , [MyCharLink] [varchar] (255) NULL , [LoginId] [varchar] (12) NULL , [EstablishDate] [datetime] NULL , [CloseDate] [datetime] NULL , [CloseFlag] [int] NULL , [ActionFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cthPTenantTItem] ( [PracticeCode] [varchar] (8) NOT NULL , [TenantCode] [varchar] (12) NOT NULL , [ItemCode] [varchar] (4) NOT NULL , [ItemName] [varchar] (40) NULL , [StockPrice] [money] NULL , [StandardPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [Remarks] [varchar] (40) NULL , [RegistrationType] [smallint] NULL , [F] [varchar] (1) NULL , [DisplayFlag] [smallint] NULL , [DisplaySeq] [smallint] NULL , [Remarks2] [varchar] (200) NULL , [Remarks3] [varchar] (200) NULL , [Remarks4] [varchar] (200) NULL , [ItemImage] [varchar] (100) NULL , [SalesImage1] [varchar] (100) NULL , [SalesImage2] [varchar] (100) NULL , [SalesImage3] [varchar] (100) NULL , [SalesImage4] [varchar] (100) NULL , [SalesImage5] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cthPVoteDtl] ( [PracticeCode] [varchar] (8) NOT NULL , [PrivateCode] [varchar] (12) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [TenantCode] [varchar] (12) NOT NULL , [LoginId] [varchar] (12) NOT NULL , [Point1] [int] NULL , [Point2] [int] NULL , [Point3] [int] NULL , [Point4] [int] NULL , [Point5] [int] NULL , [TotalPoint] [int] NULL , [Comment] [varchar] (250) NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NOT NULL , [AddProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctnBuletF] ( [PracticeCode] [varchar] (12) NOT NULL , [OriginalNo] [int] NOT NULL , [BuletNo] [int] NOT NULL , [LastNo] [int] NOT NULL , [SendUserId] [varchar] (20) NULL , [Name] [varchar] (50) NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [PrivateCode] [varchar] (12) NULL , [CompanyCode] [varchar] (12) NULL , [TenantCode] [varchar] (12) NULL , [DeleteFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctnNewsHdr] ( [PracticeCode] [varchar] (12) NOT NULL , [NewsNo] [int] NOT NULL , [SendUserId] [varchar] (20) NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [TargetGroup] [varchar] (12) NOT NULL , [TargetGroupName] [varchar] (40) NULL , [DeleteFlag] [smallint] NULL , [LastNo] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctnQandAM] ( [PracticeCode] [varchar] (8) NOT NULL , [Seq] [int] NOT NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [Question] [varchar] (255) NULL , [Comment] [varchar] (200) NULL , [Answer01] [varchar] (200) NULL , [Answer02] [varchar] (200) NULL , [Answer03] [varchar] (200) NULL , [Answer04] [varchar] (200) NULL , [Answer05] [varchar] (200) NULL , [Answer06] [varchar] (200) NULL , [Answer07] [varchar] (200) NULL , [Answer08] [varchar] (200) NULL , [Answer09] [varchar] (200) NULL , [Answer10] [varchar] (200) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctnQandATrn] ( [PracticeCode] [varchar] (8) NOT NULL , [Seq] [int] NOT NULL , [LoginId] [varchar] (12) NOT NULL , [Remarks] [varchar] (200) NULL , [Answer] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpGroupT] ( [PracticeCode] [varchar] (8) NOT NULL , [GroupCode] [varchar] (12) NOT NULL , [ActionFlag] [smallint] NULL , [ShoppingFlag] [smallint] NULL , [ShoppingLimit] [money] NULL , [DataLinkFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [会社経営可否] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpLoginT] ( [PracticeCode] [varchar] (8) NOT NULL , [LoginId] [varchar] (12) NOT NULL , [ActionFlag] [smallint] NULL , [ShoppingFlag] [smallint] NULL , [ShoppingLimit] [money] NULL , [DataLinkFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [会社経営可否] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpPracticeM] ( [PracticeType] [varchar] (8) NULL , [PracticeCode] [varchar] (8) NOT NULL , [PracticeSeq] [int] NULL , [PackageMode] [varchar] (2) NULL , [PracticeName] [varchar] (40) NULL , [UnusedFlag] [tinyint] NULL , [TCloseFlag] [tinyint] NULL , [DefaultFlag] [smallint] NULL , [ManageFlag] [smallint] NULL , [MasterPwd] [varchar] (8) NULL , [Remarks] [varchar] (250) NULL , [BgImage] [varchar] (100) NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [NowDate] [datetime] NULL , [Settlement] [smallint] NULL , [ExCode] [varchar] (3) NULL , [ExRate] [real] NULL , [ExConsumptionTax] [money] NULL , [ConsumptionTax] [money] NULL , [ComputeFlag] [smallint] NULL , [PCapitalAmount] [money] NULL , [CCapitalAmount] [money] NULL , [PCapitalAmountLock] [varchar] (2) NULL , [CCapitalAmountLock] [varchar] (2) NULL , [COfficeGuarantee] [money] NULL , [COfficeRentalFee] [money] NULL , [COfficeAssetsPrice] [money] NULL , [HpOpeningCostH] [money] NULL , [HpOpeningCostL] [money] NULL , [HpRentalFeeH] [money] NULL , [HpRentalFeeL] [money] NULL , [HpManagerSalary] [money] NULL , [HpClerkSalary] [money] NULL , [HpIMaxSell] [smallint] NULL , [HpIMaxBuy] [smallint] NULL , [HpStockCheck] [smallint] NULL , [HpStockAutoFlag] [smallint] NULL , [HpVoteCheck] [smallint] NULL , [HpVoteTitle1] [varchar] (50) NULL , [HpVoteTitle2] [varchar] (50) NULL , [HpVoteTitle3] [varchar] (50) NULL , [HpVoteTitle4] [varchar] (50) NULL , [HpVoteTitle5] [varchar] (50) NULL , [HpNewItem] [varchar] (2) NULL , [HpCompanyShopping] [varchar] (2) NULL , [PBankLoanLimit] [money] NULL , [CBankLoanLimit] [money] NULL , [CCreditFee] [money] NULL , [CCreditRate] [money] NULL , [CCreditLimit] [money] NULL , [PCreditLimit] [money] NULL , [XCreditActFee] [money] NULL , [XSecActFee] [money] NULL , [XSecRate] [real] NULL , [XSecTax] [money] NULL , [PDealerDiscAmnt] [money] NULL , [PDealerDiscRate] [real] NULL , [CDealerDiscAmnt] [money] NULL , [CDealerDiscRate] [real] NULL , [PMakerDiscAmnt] [money] NULL , [PMakerDiscRate] [real] NULL , [PMakerMakeRate] [real] NULL , [PMakerCostRate] [real] NULL , [PMakerSellRate] [real] NULL , [CMakerDiscAmnt] [money] NULL , [CMakerDiscRate] [real] NULL , [CMakerMakeRate] [real] NULL , [CMakerCostRate] [real] NULL , [CMakerSellRate] [real] NULL , [CMakerMakeRateAdd] [real] NULL , [CMakerCostRateAdd] [real] NULL , [XAdFee] [money] NULL , [XAdFee2] [money] NULL , [SearchNGFlag] [smallint] NULL , [POption01] [money] NULL , [POption02] [money] NULL , [POption03] [money] NULL , [POption04] [money] NULL , [POption05] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [MasterID] [varchar] (12) NULL , [MallCount] [int] NULL , [CircularNotice] [varchar] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpTReport] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ReportDate] [datetime] NOT NULL , [Comment] [varchar] (250) NULL , [BS] [money] NULL , [BGenkin] [money] NULL , [BUrikakekin] [money] NULL , [BKaribaraiZei] [money] NULL , [BYukasyoken] [money] NULL , [BTanaoroshi] [money] NULL , [BSonota] [money] NULL , [BKurinobe] [money] NULL , [BDTa1] [money] NULL , [BDTa2] [money] NULL , [BKaikakekin] [money] NULL , [BMibarai1] [money] NULL , [BMibarai2] [money] NULL , [BKariukeZei] [money] NULL , [BShihonkin] [money] NULL , [BCTa1] [money] NULL , [BCTa2] [money] NULL , [PL] [money] NULL , [PUriage] [money] NULL , [PGenka] [money] NULL , [PUrisoRieki] [money] NULL , [PHankanhi] [money] NULL , [PEigyoSonEki] [money] NULL , [PGaiEkiKabu] [money] NULL , [PGaiEkiTa] [money] NULL , [PGaiSonHiyo] [money] NULL , [PGaiSonKabu] [money] NULL , [PGaiSonTa] [money] NULL , [PKeijoSonEki] [money] NULL , [PToukiSonEki] [money] NULL , [PH] [money] NULL , [PHKaihatuhi] [money] NULL , [PHUnchin] [money] NULL , [PHSendenhi] [money] NULL , [PHJinkenhi] [money] NULL , [PHHpkanrihi] [money] NULL , [PHYachin] [money] NULL , [PHTesuryo] [money] NULL , [PHSonota] [money] NULL , [PHTa1] [money] NULL , [PHTa2] [money] NULL , [OldFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpTownT] ( [PracticeCode] [varchar] (8) NOT NULL , [TownNo] [int] NOT NULL , [TownName] [varchar] (40) NULL , [NumberOfShop] [tinyint] NULL , [BgImage] [varchar] (100) NULL , [TramImage] [varchar] (100) NULL , [RoadImage] [varchar] (100) NULL , [ShopImage0] [varchar] (100) NULL , [ShopImage1] [varchar] (100) NULL , [ShopImage2] [varchar] (100) NULL , [ShopImage3] [varchar] (100) NULL , [ShopImage4] [varchar] (100) NULL , [ShopImage5] [varchar] (100) NULL , [HpVoteTitle1] [varchar] (50) NULL , [HpVoteTitle2] [varchar] (50) NULL , [HpVoteTitle3] [varchar] (50) NULL , [HpVoteTitle4] [varchar] (50) NULL , [HpVoteTitle5] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctpTradeTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [ActNo] [int] NULL , [TradeCode] [varchar] (4) NOT NULL , [OrderNo] [int] NOT NULL , [OrderSeq] [smallint] NOT NULL , [BPrivateCode] [varchar] (12) NULL , [BCompanyCode] [varchar] (12) NULL , [BTenantCode] [varchar] (12) NULL , [ItemType] [varchar] (1) NULL , [ItemCode] [varchar] (4) NULL , [ItemName] [varchar] (40) NULL , [ItemImage] [varchar] (100) NULL , [PaymentTerm] [smallint] NULL , [ProcessStatus] [varchar] (1) NULL , [BusinessDateA] [datetime] NULL , [BusinessDateB] [datetime] NULL , [BusinessDateE] [datetime] NULL , [BusinessDateT] [datetime] NULL , [TransportFlag] [int] NULL , [SellsDiscFlag] [int] NULL , [COfficeAssetsFlag] [int] NULL , [Qty] [int] NULL , [StandardPrice] [money] NULL , [MakesPrice] [money] NULL , [StockPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [ConsumptionTax] [money] NULL , [CCreditRate] [real] NULL , [MakesAmnt] [money] NULL , [StockAmnt] [money] NULL , [SellsAmnt] [money] NULL , [TaxAmnt] [money] NULL , [TransportAmnt] [money] NULL , [TransportTax] [money] NULL , [CreditAmnt] [money] NULL , [AAmnt] [money] NULL , [BAmnt] [money] NULL , [RemarksA] [varchar] (250) NULL , [RemarksB] [varchar] (250) NULL , [RemarksE] [varchar] (250) NULL , [AddDate] [datetime] NOT NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsCodeTS] ( [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [UnusedFlag] [tinyint] NULL , [gifSizeW] [int] NULL , [gifSizeH] [int] NULL , [directory] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsCodeTSgif] ( [IdentKey] [varchar] (20) NOT NULL , [IdentName] [varchar] (100) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [SallFlag] [tinyint] NULL , [SPracticeCode] [varchar] (8) NOT NULL , [SPrivateCode] [varchar] (12) NOT NULL , [SCompanyCode] [varchar] (12) NOT NULL , [LoginId] [varchar] (12) NULL , [DefaultFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsCodeTSgifSeq] ( [PracticeCode] [varchar] (8) NOT NULL , [GifSeq] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsCodeTU] ( [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsCodeTUprcItem] ( [PracticeCode] [varchar] (8) NOT NULL , [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctsSystemF] ( [UserCode] [varchar] (4) NOT NULL , [UserName] [varchar] (50) NULL , [ZipCode] [varchar] (10) NULL , [Address1] [varchar] (50) NULL , [Address2] [varchar] (50) NULL , [PhoneNo] [varchar] (20) NULL , [FaxNo] [varchar] (20) NULL , [Remarks] [varchar] (40) NULL , [DomainName] [varchar] (50) NULL , [ServerName] [varchar] (50) NULL , [DNSName] [varchar] (50) NULL , [DNSAddress] [varchar] (50) NULL , [FTPUserId] [varchar] (50) NULL , [FTPPassword] [varchar] (50) NULL , [MailServer] [varchar] (50) NULL , [MailAccount] [varchar] (50) NULL , [AdminPwd] [varchar] (8) NULL , [NewLogin] [varchar] (1) NULL , [Userinf01] [varchar] (50) NULL , [Userinf02] [varchar] (50) NULL , [Userinf03] [varchar] (50) NULL , [Userinf04] [varchar] (50) NULL , [Userinf05] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cttStockM] ( [PracticeCode] [varchar] (8) NOT NULL , [StockCode] [varchar] (10) NOT NULL , [StockName] [varchar] (50) NULL , [Market] [varchar] (20) NULL , [IndustryType] [varchar] (20) NULL , [DealingUnit] [int] NULL , [FaceValue] [money] NULL , [TradeDate] [datetime] NULL , [StartPrice] [money] NULL , [HighPrice] [money] NULL , [LowPrice] [money] NULL , [EndPrice] [money] NULL , [MoveValue] [money] NULL , [TradeQty] [int] NULL , [UpperLimitRate] [int] NULL , [LowerLimitRate] [int] NULL , [Remarks] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@cttTradeMemberM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [MemberCode] [varchar] (20) NULL , [MemberName] [varchar] (40) NULL , [Sign] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctxGroupM] ( [GroupSeq] [int] NULL , [GroupCode] [varchar] (12) NOT NULL , [GroupName] [varchar] (40) NULL , [Password] [varchar] (8) NULL , [DefaultFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[W@ctxLoginF] ( [LoginId] [varchar] (12) NOT NULL , [Name] [varchar] (20) NULL , [Password] [varchar] (8) NULL , [KeyWordQ] [varchar] (30) NULL , [KeyWord] [varchar] (30) NULL , [GroupCode] [varchar] (12) NULL , [LastPracticeCode] [varchar] (8) NULL , [LoginFlag] [smallint] NULL , [LoginError] [smallint] NULL , [LastLoginDate] [datetime] NULL , [LastLogofDate] [datetime] NULL , [DefaultFlag] [smallint] NULL , [Image] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctaAuctionM] ( [PracticeCode] [varchar] (8) NOT NULL , [AuctionNo] [int] NOT NULL , [APrivateCode] [varchar] (12) NULL , [ACompanyCode] [varchar] (12) NULL , [ATenantCode] [varchar] (12) NULL , [ALoginId] [varchar] (12) NULL , [ActionName] [varchar] (50) NULL , [ItemCode] [varchar] (12) NULL , [ItemName] [varchar] (40) NULL , [ItemImage] [varchar] (100) NULL , [Remarks] [varchar] (200) NULL , [Qty] [int] NULL , [LimitPrice] [money] NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [AuctionStatus] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctaAuctionTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [AuctionNo] [int] NOT NULL , [BidSeq] [int] NOT NULL , [BPrivateCode] [varchar] (50) NULL , [BCompanyCode] [varchar] (12) NULL , [BTenantCode] [varchar] (12) NULL , [BLoginId] [varchar] (12) NULL , [BidderName] [varchar] (50) NULL , [Comment] [varchar] (200) NULL , [BidQty] [int] NULL , [BidPrice] [money] NULL , [BidDate] [datetime] NULL , [BidFlag] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctaBannerRoboT] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [RoboSeq] [int] NOT NULL , [Title] [varchar] (40) NULL , [Description] [varchar] (7000) NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [LinkUrl] [varchar] (50) NULL , [SCount] [int] NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctaSearchRoboT] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [RoboSeq] [int] NOT NULL , [Title] [varchar] (40) NULL , [Description] [varchar] (7000) NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [LinkUrl] [varchar] (50) NULL , [SCount] [int] NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctbBankAccountM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [AccountName] [varchar] (40) NULL , [Password] [varchar] (8) NULL , [BankLoanLimit] [money] NULL , [StopFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [LoginAction] [smallint] NULL , [CompanyCode] [varchar] (12) NULL , [Comment] [varchar] (200) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctcCreditAccountM] ( [PracticeCode] [varchar] (8) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [CompanyName] [varchar] (40) NULL , [Expirationdate] [datetime] NULL , [CreditRate] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctcCreditMemberM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [MemberCode] [varchar] (20) NULL , [MemberName] [varchar] (40) NULL , [Sign] [varchar] (20) NULL , [Expirationdate] [datetime] NULL , [TrustLimit] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctdItemM] ( [PracticeCode] [varchar] (8) NOT NULL , [ItemCode] [varchar] (4) NOT NULL , [ItemName] [varchar] (40) NULL , [ItemType] [varchar] (20) NULL , [ItemImage] [varchar] (100) NULL , [StandardPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [Remarks] [varchar] (40) NULL , [RegistrationType] [smallint] NULL , [SGroupCode] [varchar] (12) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cteMailTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [MailNo] [int] NOT NULL , [同報MailNo] [int] NULL , [宛先To] [varchar] (8000) NULL , [宛先Cc] [varchar] (8000) NULL , [宛先Bcc] [varchar] (8000) NULL , [SPrivateCode] [varchar] (12) NULL , [SCompanyCode] [varchar] (12) NULL , [STenantCode] [varchar] (12) NULL , [TPrivateCode] [varchar] (12) NULL , [TCompanyCode] [varchar] (12) NULL , [TTenantCode] [varchar] (12) NULL , [ALoginId] [varchar] (12) NULL , [ActNo] [int] NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [ReadFlag] [smallint] NULL , [ReplyFlag] [smallint] NULL , [SndDelFlag] [smallint] NULL , [RecDelFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [添付ファイル] [varchar] (255) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctgTradeParamT] ( [PracticeCode] [varchar] (12) NOT NULL , [Std1] [smallint] NULL , [Std2] [smallint] NULL , [Std3] [smallint] NULL , [Std1_1] [smallint] NULL , [Std1_2] [smallint] NULL , [Std1_3] [smallint] NULL , [Std2_1] [smallint] NULL , [Std2_2] [smallint] NULL , [Std2_3] [smallint] NULL , [Std3_1] [smallint] NULL , [Std3_2] [smallint] NULL , [Std3_3] [smallint] NULL , [ExecFlag] [smallint] NULL , [ExecDate] [datetime] NULL , [ExecAmount] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cthPCompanyM] ( [PracticeCode] [varchar] (8) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [CompanyName] [varchar] (40) NULL , [CompanyKanaName] [varchar] (40) NULL , [CompanyKey] [varchar] (8) NULL , [ZipCode] [varchar] (8) NULL , [Address1] [varchar] (40) NULL , [Address2] [varchar] (40) NULL , [PhoneNo] [varchar] (14) NULL , [FaxNo] [varchar] (14) NULL , [DomainName] [varchar] (50) NULL , [RegistType] [smallint] NULL , [MainBank] [varchar] (12) NULL , [LoginId] [varchar] (12) NULL , [EstablishDate] [datetime] NULL , [CapitalAmount] [money] NULL , [ManagerSalary] [money] NULL , [ManagerMax] [smallint] NULL , [CompanyGuidance] [varchar] (255) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cthPTenantM] ( [PracticeCode] [varchar] (8) NOT NULL , [TownNo] [int] NOT NULL , [TownSeq] [int] NOT NULL , [TenantType] [varchar] (20) NULL , [PrivateCode] [varchar] (12) NULL , [CompanyCode] [varchar] (12) NULL , [TenantCode] [varchar] (12) NULL , [HPMode] [varchar] (2) NULL , [DefaultDoc] [varchar] (1000) NULL , [ExtURL] [varchar] (1000) NULL , [DomainName] [varchar] (255) NULL , [DomainTLD] [varchar] (16) NULL , [TenantName] [varchar] (40) NULL , [TenantNameFont] [varchar] (40) NULL , [TenantNameSize] [varchar] (1) NULL , [TenantCopy] [varchar] (100) NULL , [TenantGuide] [varchar] (255) NULL , [TenantGuideFont] [varchar] (40) NULL , [TenantGuideSize] [varchar] (1) NULL , [CountVTitle1] [varchar] (100) NULL , [CountVTitle2] [varchar] (100) NULL , [CountSTitle1] [varchar] (100) NULL , [CountSTitle2] [varchar] (100) NULL , [CountVisit] [money] NULL , [CountSells] [money] NULL , [CurCode] [varchar] (10) NULL , [ConsumptionTax] [money] NULL , [TransportFlag] [int] NULL , [ShopDiscAmnt] [money] NULL , [ShopDiscRate] [real] NULL , [BackGroundImage] [varchar] (255) NULL , [ShopImage] [varchar] (100) NULL , [ForeImage] [varchar] (100) NULL , [BackImage] [varchar] (100) NULL , [GuideImage] [varchar] (100) NULL , [CountImage] [varchar] (100) NULL , [TenantCopyColor] [varchar] (10) NULL , [TenantForeColor] [varchar] (10) NULL , [TenantBackColor] [varchar] (10) NULL , [GuideForeColor] [varchar] (10) NULL , [GuideBackColor] [varchar] (10) NULL , [ItemPageForeColor] [varchar] (10) NULL , [ItemPageBackColor] [varchar] (10) NULL , [ItemNameForeColor] [varchar] (10) NULL , [ItemNameBackColor] [varchar] (10) NULL , [ShelfForeFont1] [varchar] (40) NULL , [ShelfForeSize1] [varchar] (1) NULL , [ShelfForeColor1] [varchar] (10) NULL , [ShelfBackColor1] [varchar] (10) NULL , [ShelfForeFont2] [varchar] (40) NULL , [ShelfForeSize2] [varchar] (1) NULL , [ShelfForeColor2] [varchar] (10) NULL , [ShelfBackColor2] [varchar] (10) NULL , [ShelfForeFont3] [varchar] (40) NULL , [ShelfForeSize3] [varchar] (1) NULL , [ShelfForeColor3] [varchar] (10) NULL , [ShelfBackColor3] [varchar] (10) NULL , [ShelfForeFont4] [varchar] (40) NULL , [ShelfForeSize4] [varchar] (1) NULL , [ShelfForeColor4] [varchar] (10) NULL , [ShelfBackColor4] [varchar] (10) NULL , [ShelfFrameColor] [varchar] (10) NULL , [ShelfFrameType] [varchar] (1) NULL , [MyHPTitle] [varchar] (40) NULL , [MyHPLink] [varchar] (100) NULL , [MyFileTitle] [varchar] (40) NULL , [MyFileLink] [varchar] (255) NULL , [MyCharLink] [varchar] (255) NULL , [LoginId] [varchar] (12) NULL , [EstablishDate] [datetime] NULL , [CloseDate] [datetime] NULL , [CloseFlag] [int] NULL , [ActionFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cthPTenantTItem] ( [PracticeCode] [varchar] (8) NOT NULL , [TenantCode] [varchar] (12) NOT NULL , [ItemCode] [varchar] (4) NOT NULL , [ItemName] [varchar] (40) NULL , [StockPrice] [money] NULL , [StandardPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [Remarks] [varchar] (40) NULL , [RegistrationType] [smallint] NULL , [F] [varchar] (1) NULL , [DisplayFlag] [smallint] NULL , [DisplaySeq] [smallint] NULL , [Remarks2] [varchar] (200) NULL , [Remarks3] [varchar] (200) NULL , [Remarks4] [varchar] (200) NULL , [ItemImage] [varchar] (100) NULL , [SalesImage1] [varchar] (100) NULL , [SalesImage2] [varchar] (100) NULL , [SalesImage3] [varchar] (100) NULL , [SalesImage4] [varchar] (100) NULL , [SalesImage5] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cthPVoteDtl] ( [PracticeCode] [varchar] (8) NOT NULL , [PrivateCode] [varchar] (12) NOT NULL , [CompanyCode] [varchar] (12) NOT NULL , [TenantCode] [varchar] (12) NOT NULL , [LoginId] [varchar] (12) NOT NULL , [Point1] [int] NULL , [Point2] [int] NULL , [Point3] [int] NULL , [Point4] [int] NULL , [Point5] [int] NULL , [TotalPoint] [int] NULL , [Comment] [varchar] (250) NULL , [EntryDate] [datetime] NULL , [AddDate] [datetime] NOT NULL , [AddProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctnBuletF] ( [PracticeCode] [varchar] (12) NOT NULL , [OriginalNo] [int] NOT NULL , [BuletNo] [int] NOT NULL , [LastNo] [int] NOT NULL , [SendUserId] [varchar] (20) NULL , [Name] [varchar] (50) NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [PrivateCode] [varchar] (12) NULL , [CompanyCode] [varchar] (12) NULL , [TenantCode] [varchar] (12) NULL , [DeleteFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctnNewsHdr] ( [PracticeCode] [varchar] (12) NOT NULL , [NewsNo] [int] NOT NULL , [SendUserId] [varchar] (20) NULL , [Title] [varchar] (40) NULL , [Message] [varchar] (7000) NULL , [TargetGroup] [varchar] (12) NOT NULL , [TargetGroupName] [varchar] (40) NULL , [DeleteFlag] [smallint] NULL , [LastNo] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctnQandAM] ( [PracticeCode] [varchar] (8) NOT NULL , [Seq] [int] NOT NULL , [Category] [varchar] (20) NULL , [TypeCode] [varchar] (20) NULL , [Question] [varchar] (255) NULL , [Comment] [varchar] (200) NULL , [Answer01] [varchar] (200) NULL , [Answer02] [varchar] (200) NULL , [Answer03] [varchar] (200) NULL , [Answer04] [varchar] (200) NULL , [Answer05] [varchar] (200) NULL , [Answer06] [varchar] (200) NULL , [Answer07] [varchar] (200) NULL , [Answer08] [varchar] (200) NULL , [Answer09] [varchar] (200) NULL , [Answer10] [varchar] (200) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctnQandATrn] ( [PracticeCode] [varchar] (8) NOT NULL , [Seq] [int] NOT NULL , [LoginId] [varchar] (12) NOT NULL , [Remarks] [varchar] (200) NULL , [Answer] [int] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpGroupT] ( [PracticeCode] [varchar] (8) NOT NULL , [GroupCode] [varchar] (12) NOT NULL , [ActionFlag] [smallint] NULL , [ShoppingFlag] [smallint] NULL , [ShoppingLimit] [money] NULL , [DataLinkFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [会社経営可否] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpLoginT] ( [PracticeCode] [varchar] (8) NOT NULL , [LoginId] [varchar] (12) NOT NULL , [ActionFlag] [smallint] NULL , [ShoppingFlag] [smallint] NULL , [ShoppingLimit] [money] NULL , [DataLinkFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [会社経営可否] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpPracticeM] ( [PracticeType] [varchar] (8) NULL , [PracticeCode] [varchar] (8) NOT NULL , [PracticeSeq] [int] NULL , [PackageMode] [varchar] (2) NULL , [PracticeName] [varchar] (40) NULL , [UnusedFlag] [tinyint] NULL , [TCloseFlag] [tinyint] NULL , [DefaultFlag] [smallint] NULL , [ManageFlag] [smallint] NULL , [MasterPwd] [varchar] (8) NULL , [Remarks] [varchar] (250) NULL , [BgImage] [varchar] (100) NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [NowDate] [datetime] NULL , [Settlement] [smallint] NULL , [ExCode] [varchar] (3) NULL , [ExRate] [real] NULL , [ExConsumptionTax] [money] NULL , [ConsumptionTax] [money] NULL , [ComputeFlag] [smallint] NULL , [PCapitalAmount] [money] NULL , [CCapitalAmount] [money] NULL , [PCapitalAmountLock] [varchar] (2) NULL , [CCapitalAmountLock] [varchar] (2) NULL , [COfficeGuarantee] [money] NULL , [COfficeRentalFee] [money] NULL , [COfficeAssetsPrice] [money] NULL , [HpOpeningCostH] [money] NULL , [HpOpeningCostL] [money] NULL , [HpRentalFeeH] [money] NULL , [HpRentalFeeL] [money] NULL , [HpManagerSalary] [money] NULL , [HpClerkSalary] [money] NULL , [HpIMaxSell] [smallint] NULL , [HpIMaxBuy] [smallint] NULL , [HpStockCheck] [smallint] NULL , [HpStockAutoFlag] [smallint] NULL , [HpVoteCheck] [smallint] NULL , [HpVoteTitle1] [varchar] (50) NULL , [HpVoteTitle2] [varchar] (50) NULL , [HpVoteTitle3] [varchar] (50) NULL , [HpVoteTitle4] [varchar] (50) NULL , [HpVoteTitle5] [varchar] (50) NULL , [HpNewItem] [varchar] (2) NULL , [HpCompanyShopping] [varchar] (2) NULL , [PBankLoanLimit] [money] NULL , [CBankLoanLimit] [money] NULL , [CCreditFee] [money] NULL , [CCreditRate] [money] NULL , [CCreditLimit] [money] NULL , [PCreditLimit] [money] NULL , [XCreditActFee] [money] NULL , [XSecActFee] [money] NULL , [XSecRate] [real] NULL , [XSecTax] [money] NULL , [PDealerDiscAmnt] [money] NULL , [PDealerDiscRate] [real] NULL , [CDealerDiscAmnt] [money] NULL , [CDealerDiscRate] [real] NULL , [PMakerDiscAmnt] [money] NULL , [PMakerDiscRate] [real] NULL , [PMakerMakeRate] [real] NULL , [PMakerCostRate] [real] NULL , [PMakerSellRate] [real] NULL , [CMakerDiscAmnt] [money] NULL , [CMakerDiscRate] [real] NULL , [CMakerMakeRate] [real] NULL , [CMakerCostRate] [real] NULL , [CMakerSellRate] [real] NULL , [CMakerMakeRateAdd] [real] NULL , [CMakerCostRateAdd] [real] NULL , [XAdFee] [money] NULL , [XAdFee2] [money] NULL , [SearchNGFlag] [smallint] NULL , [POption01] [money] NULL , [POption02] [money] NULL , [POption03] [money] NULL , [POption04] [money] NULL , [POption05] [money] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL , [MasterID] [varchar] (12) NULL , [MallCount] [int] NULL , [CircularNotice] [varchar] (2) NULL , [Ranking] [varchar] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpTReport] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ReportDate] [datetime] NOT NULL , [Comment] [varchar] (250) NULL , [BS] [money] NULL , [BGenkin] [money] NULL , [BUrikakekin] [money] NULL , [BKaribaraiZei] [money] NULL , [BYukasyoken] [money] NULL , [BTanaoroshi] [money] NULL , [BSonota] [money] NULL , [BKurinobe] [money] NULL , [BDTa1] [money] NULL , [BDTa2] [money] NULL , [BKaikakekin] [money] NULL , [BMibarai1] [money] NULL , [BMibarai2] [money] NULL , [BKariukeZei] [money] NULL , [BShihonkin] [money] NULL , [BCTa1] [money] NULL , [BCTa2] [money] NULL , [PL] [money] NULL , [PUriage] [money] NULL , [PGenka] [money] NULL , [PUrisoRieki] [money] NULL , [PHankanhi] [money] NULL , [PEigyoSonEki] [money] NULL , [PGaiEkiKabu] [money] NULL , [PGaiEkiTa] [money] NULL , [PGaiSonHiyo] [money] NULL , [PGaiSonKabu] [money] NULL , [PGaiSonTa] [money] NULL , [PKeijoSonEki] [money] NULL , [PToukiSonEki] [money] NULL , [PH] [money] NULL , [PHKaihatuhi] [money] NULL , [PHUnchin] [money] NULL , [PHSendenhi] [money] NULL , [PHJinkenhi] [money] NULL , [PHHpkanrihi] [money] NULL , [PHYachin] [money] NULL , [PHTesuryo] [money] NULL , [PHSonota] [money] NULL , [PHTa1] [money] NULL , [PHTa2] [money] NULL , [OldFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpTownT] ( [PracticeCode] [varchar] (8) NOT NULL , [TownNo] [int] NOT NULL , [TownName] [varchar] (40) NULL , [NumberOfShop] [tinyint] NULL , [BgImage] [varchar] (100) NULL , [TramImage] [varchar] (100) NULL , [RoadImage] [varchar] (100) NULL , [ShopImage0] [varchar] (100) NULL , [ShopImage1] [varchar] (100) NULL , [ShopImage2] [varchar] (100) NULL , [ShopImage3] [varchar] (100) NULL , [ShopImage4] [varchar] (100) NULL , [ShopImage5] [varchar] (100) NULL , [HpVoteTitle1] [varchar] (50) NULL , [HpVoteTitle2] [varchar] (50) NULL , [HpVoteTitle3] [varchar] (50) NULL , [HpVoteTitle4] [varchar] (50) NULL , [HpVoteTitle5] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctpTradeTrn] ( [PracticeCode] [varchar] (8) NOT NULL , [APrivateCode] [varchar] (12) NOT NULL , [ACompanyCode] [varchar] (12) NOT NULL , [ATenantCode] [varchar] (12) NOT NULL , [ALoginId] [varchar] (12) NULL , [ActNo] [int] NULL , [TradeCode] [varchar] (4) NOT NULL , [OrderNo] [int] NOT NULL , [OrderSeq] [smallint] NOT NULL , [BPrivateCode] [varchar] (12) NULL , [BCompanyCode] [varchar] (12) NULL , [BTenantCode] [varchar] (12) NULL , [ItemType] [varchar] (1) NULL , [ItemCode] [varchar] (4) NULL , [ItemName] [varchar] (40) NULL , [ItemImage] [varchar] (100) NULL , [PaymentTerm] [smallint] NULL , [ProcessStatus] [varchar] (1) NULL , [BusinessDateA] [datetime] NULL , [BusinessDateB] [datetime] NULL , [BusinessDateE] [datetime] NULL , [BusinessDateT] [datetime] NULL , [TransportFlag] [int] NULL , [SellsDiscFlag] [int] NULL , [COfficeAssetsFlag] [int] NULL , [Qty] [int] NULL , [StandardPrice] [money] NULL , [MakesPrice] [money] NULL , [StockPrice] [money] NULL , [SellsPrice] [money] NULL , [TransportPrice] [money] NULL , [ConsumptionTax] [money] NULL , [CCreditRate] [real] NULL , [MakesAmnt] [money] NULL , [StockAmnt] [money] NULL , [SellsAmnt] [money] NULL , [TaxAmnt] [money] NULL , [TransportAmnt] [money] NULL , [TransportTax] [money] NULL , [CreditAmnt] [money] NULL , [AAmnt] [money] NULL , [BAmnt] [money] NULL , [RemarksA] [varchar] (250) NULL , [RemarksB] [varchar] (250) NULL , [RemarksE] [varchar] (250) NULL , [AddDate] [datetime] NOT NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTC] ( [DataIdent] [varchar] (10) NULL , [TradeCode] [varchar] (4) NULL , [JName] [varchar] (50) NULL , [EName] [varchar] (50) NULL , [AMF] [varchar] (1) NULL , [BMF] [varchar] (1) NULL , [AAD1] [varchar] (4) NULL , [AAD2] [varchar] (4) NULL , [AAD3] [varchar] (4) NULL , [AAD4] [varchar] (4) NULL , [AAD5] [varchar] (4) NULL , [AAC1] [varchar] (4) NULL , [AAC2] [varchar] (4) NULL , [AAC3] [varchar] (4) NULL , [AAC4] [varchar] (4) NULL , [AAC5] [varchar] (4) NULL , [BAD1] [varchar] (4) NULL , [BAD2] [varchar] (4) NULL , [BAD3] [varchar] (4) NULL , [BAD4] [varchar] (4) NULL , [BAD5] [varchar] (4) NULL , [BAC1] [varchar] (4) NULL , [BAC2] [varchar] (4) NULL , [BAC3] [varchar] (4) NULL , [BAC4] [varchar] (4) NULL , [BAC5] [varchar] (4) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTS] ( [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [UnusedFlag] [tinyint] NULL , [gifSizeW] [int] NULL , [gifSizeH] [int] NULL , [directory] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTSgif] ( [IdentKey] [varchar] (20) NOT NULL , [IdentName] [varchar] (100) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [SallFlag] [tinyint] NULL , [SPracticeCode] [varchar] (8) NOT NULL , [SPrivateCode] [varchar] (12) NOT NULL , [SCompanyCode] [varchar] (12) NOT NULL , [LoginId] [varchar] (12) NULL , [DefaultFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTSgifSeq] ( [PracticeCode] [varchar] (8) NOT NULL , [GifSeq] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTU] ( [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsCodeTUprcItem] ( [PracticeCode] [varchar] (8) NOT NULL , [DataIdent] [varchar] (10) NOT NULL , [IdentKey] [varchar] (20) NOT NULL , [JName] [varchar] (20) NULL , [EName] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctsSystemF] ( [UserCode] [varchar] (4) NOT NULL , [UserName] [varchar] (50) NULL , [ZipCode] [varchar] (10) NULL , [Address1] [varchar] (50) NULL , [Address2] [varchar] (50) NULL , [PhoneNo] [varchar] (20) NULL , [FaxNo] [varchar] (20) NULL , [Remarks] [varchar] (40) NULL , [DomainName] [varchar] (50) NULL , [ServerName] [varchar] (50) NULL , [DNSName] [varchar] (50) NULL , [DNSAddress] [varchar] (50) NULL , [FTPUserId] [varchar] (50) NULL , [FTPPassword] [varchar] (50) NULL , [MailServer] [varchar] (50) NULL , [MailAccount] [varchar] (50) NULL , [AdminPwd] [varchar] (8) NULL , [NewLogin] [varchar] (1) NULL , [Userinf01] [varchar] (50) NULL , [Userinf02] [varchar] (50) NULL , [Userinf03] [varchar] (50) NULL , [Userinf04] [varchar] (50) NULL , [Userinf05] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cttStockC] ( [StockCode] [varchar] (255) NULL , [StockName] [varchar] (255) NULL , [Market] [varchar] (255) NULL , [IndustryType] [varchar] (255) NULL , [DealingUnit] [varchar] (255) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cttStockM] ( [PracticeCode] [varchar] (8) NOT NULL , [StockCode] [varchar] (10) NOT NULL , [StockName] [varchar] (50) NULL , [Market] [varchar] (20) NULL , [IndustryType] [varchar] (20) NULL , [DealingUnit] [int] NULL , [FaceValue] [money] NULL , [TradeDate] [datetime] NULL , [StartPrice] [money] NULL , [HighPrice] [money] NULL , [LowPrice] [money] NULL , [EndPrice] [money] NULL , [MoveValue] [money] NULL , [TradeQty] [int] NULL , [UpperLimitRate] [int] NULL , [LowerLimitRate] [int] NULL , [Remarks] [varchar] (50) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[cttTradeMemberM] ( [PracticeCode] [varchar] (8) NOT NULL , [UserType] [smallint] NOT NULL , [AccountNo] [varchar] (12) NOT NULL , [MemberCode] [varchar] (20) NULL , [MemberName] [varchar] (40) NULL , [Sign] [varchar] (20) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctxGroupM] ( [GroupSeq] [int] NULL , [GroupCode] [varchar] (12) NOT NULL , [GroupName] [varchar] (40) NULL , [Password] [varchar] (8) NULL , [DefaultFlag] [smallint] NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ctxLoginF] ( [LoginId] [varchar] (12) NOT NULL , [Name] [varchar] (20) NULL , [Password] [varchar] (8) NULL , [KeyWordQ] [varchar] (30) NULL , [KeyWord] [varchar] (30) NULL , [GroupCode] [varchar] (12) NULL , [LastPracticeCode] [varchar] (8) NULL , [LoginFlag] [smallint] NULL , [LoginError] [smallint] NULL , [LastLoginDate] [datetime] NULL , [LastLogofDate] [datetime] NULL , [DefaultFlag] [smallint] NULL , [Image] [varchar] (100) NULL , [AddDate] [datetime] NULL , [UpdDate] [datetime] NULL , [AddProc] [varchar] (20) NULL , [UpdProc] [varchar] (20) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TK伝票F] ADD CONSTRAINT [DF_TK伝票F_削除フラグ] DEFAULT (0) FOR [削除フラグ], CONSTRAINT [PK_TK伝票F] PRIMARY KEY CLUSTERED ( [演習CD], [会社CD], [伝票区分], [伝票番号] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TK伝票明細F] ADD CONSTRAINT [PK_TK伝票明細F] PRIMARY KEY CLUSTERED ( [演習CD], [会社CD], [伝票区分], [伝票番号], [伝票SEQ] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TM名刺デザインM] ADD CONSTRAINT [PK_TM名刺デザインM] PRIMARY KEY CLUSTERED ( [名刺デザインCD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TS会社M] ADD CONSTRAINT [PK_TS会社M] PRIMARY KEY CLUSTERED ( [演習CD], [会社CD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TS勘定科目M] ADD CONSTRAINT [PK_TS勘定科目M] PRIMARY KEY CLUSTERED ( [演習CD], [勘定CD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TS学生M] ADD CONSTRAINT [PK_TS学生M] PRIMARY KEY CLUSTERED ( [学生番号] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TS演習M] ADD CONSTRAINT [PK_TS演習M] PRIMARY KEY CLUSTERED ( [演習CD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctaAuctionM] ADD CONSTRAINT [DF_W@ctaAuctionM_AuctionNo] DEFAULT (0) FOR [AuctionNo], CONSTRAINT [DF_W@ctaAuctionM_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_W@ctaAuctionM_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_W@ctaAuctionM_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_W@ctaAuctionM_Qty] DEFAULT (0) FOR [Qty], CONSTRAINT [DF_W@ctaAuctionM_LimitPrice] DEFAULT (0) FOR [LimitPrice], CONSTRAINT [DF_W@ctaAuctionM_AuctionStatus] DEFAULT (0) FOR [AuctionStatus], CONSTRAINT [PK_W@ctaAuctionM] PRIMARY KEY CLUSTERED ( [PracticeCode], [AuctionNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctaAuctionTrn] ADD CONSTRAINT [DF_W@ctaAuctionTrn_AuctionNo] DEFAULT (0) FOR [AuctionNo], CONSTRAINT [DF_W@ctaAuctionTrn_BPrivateCode] DEFAULT ('') FOR [BPrivateCode], CONSTRAINT [DF_W@ctaAuctionTrn_BCompanyCode] DEFAULT ('') FOR [BCompanyCode], CONSTRAINT [DF_W@ctaAuctionTrn_BTenantCode] DEFAULT ('') FOR [BTenantCode], CONSTRAINT [DF_W@ctaAuctionTrn_BidQty] DEFAULT (0) FOR [BidQty], CONSTRAINT [DF_W@ctaAuctionTrn_BidPrice] DEFAULT (0) FOR [BidPrice], CONSTRAINT [DF_W@ctaAuctionTrn_BidFlag] DEFAULT (0) FOR [BidFlag], CONSTRAINT [PK_W@ctaAuctionTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [AuctionNo], [BidSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctaBannerRoboT] ADD CONSTRAINT [DF_W@ctaBannerRoboT_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_W@ctaBannerRoboT_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_W@ctaBannerRoboT_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_W@ctaBannerRoboT_RoboSeq] DEFAULT (0) FOR [RoboSeq], CONSTRAINT [DF_W@ctaBannerRoboT_SCount] DEFAULT (0) FOR [SCount], CONSTRAINT [PK_W@ctaBannerRoboT] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [RoboSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctaSearchRoboT] ADD CONSTRAINT [DF_W@ctaSearchRoboT_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_W@ctaSearchRoboT_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_W@ctaSearchRoboT_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_W@ctaSearchRoboT_RoboSeq] DEFAULT (0) FOR [RoboSeq], CONSTRAINT [DF_W@ctaSearchRoboT_SCount] DEFAULT (0) FOR [SCount], CONSTRAINT [PK_W@ctaSearchRoboT] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [RoboSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctbBankAccountM] ADD CONSTRAINT [DF_W@ctbBankAccountM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [DF_W@ctbBankAccountM_BankLoanLimit] DEFAULT (0) FOR [BankLoanLimit], CONSTRAINT [DF_W@ctbBankAccountM_StopFlag] DEFAULT (0) FOR [StopFlag], CONSTRAINT [DF_W@ctbBankAccountM_LoginAction] DEFAULT (0) FOR [LoginAction], CONSTRAINT [PK_W@ctbBankAccountM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctcCreditAccountM] ADD CONSTRAINT [DF_W@ctcCreditAccountM_CreditRate] DEFAULT (0) FOR [CreditRate], CONSTRAINT [PK_W@ctcCreditAccountM] PRIMARY KEY CLUSTERED ( [PracticeCode], [CompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctcCreditMemberM] ADD CONSTRAINT [DF_W@ctcCreditMemberM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [DF_W@ctcCreditMemberM_TrustLimit] DEFAULT (0) FOR [TrustLimit], CONSTRAINT [PK_W@ctcCreditMemberM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctdItemM] ADD CONSTRAINT [DF_W@ctdItemM_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_W@ctdItemM_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_W@ctdItemM_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_W@ctdItemM_RegistrationType] DEFAULT (0) FOR [RegistrationType], CONSTRAINT [DF_W@ctdItemM_SGroupCode] DEFAULT ('') FOR [SGroupCode], CONSTRAINT [PK_W@ctdItemM] PRIMARY KEY CLUSTERED ( [PracticeCode], [ItemCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cteMailTrn] ADD CONSTRAINT [DF_W@cteMailTrn_SPrivateCode] DEFAULT ('') FOR [SPrivateCode], CONSTRAINT [DF_W@cteMailTrn_SCompanyCode] DEFAULT ('') FOR [SCompanyCode], CONSTRAINT [DF_W@cteMailTrn_STenantCode] DEFAULT ('') FOR [STenantCode], CONSTRAINT [DF_W@cteMailTrn_TPrivateCode] DEFAULT ('') FOR [TPrivateCode], CONSTRAINT [DF_W@cteMailTrn_TCompanyCode] DEFAULT ('') FOR [TCompanyCode], CONSTRAINT [DF_W@cteMailTrn_TTenantCode] DEFAULT ('') FOR [TTenantCode], CONSTRAINT [DF_W@cteMailTrn_ActNo] DEFAULT (0) FOR [ActNo], CONSTRAINT [DF_W@cteMailTrn_ReadFlag] DEFAULT (0) FOR [ReadFlag], CONSTRAINT [DF_W@cteMailTrn_SndDelFlag] DEFAULT (0) FOR [SndDelFlag], CONSTRAINT [DF_W@cteMailTrn_RecDelFlag] DEFAULT (0) FOR [RecDelFlag], CONSTRAINT [PK_W@cteMailTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [MailNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctgTradeParamT] ADD CONSTRAINT [DF_W@ctgTradeParamT_Std1] DEFAULT (0) FOR [Std1], CONSTRAINT [DF_W@ctgTradeParamT_Std2] DEFAULT (0) FOR [Std2], CONSTRAINT [DF_W@ctgTradeParamT_Std3] DEFAULT (0) FOR [Std3], CONSTRAINT [DF_W@ctgTradeParamT_Std1_1] DEFAULT (0) FOR [Std1_1], CONSTRAINT [DF_W@ctgTradeParamT_Std1_2] DEFAULT (0) FOR [Std1_2], CONSTRAINT [DF_W@ctgTradeParamT_Std1_3] DEFAULT (0) FOR [Std1_3], CONSTRAINT [DF_W@ctgTradeParamT_Std2_1] DEFAULT (0) FOR [Std2_1], CONSTRAINT [DF_W@ctgTradeParamT_Std2_2] DEFAULT (0) FOR [Std2_2], CONSTRAINT [DF_W@ctgTradeParamT_Std2_3] DEFAULT (0) FOR [Std2_3], CONSTRAINT [DF_W@ctgTradeParamT_Std3_1] DEFAULT (0) FOR [Std3_1], CONSTRAINT [DF_W@ctgTradeParamT_Std3_2] DEFAULT (0) FOR [Std3_2], CONSTRAINT [DF_W@ctgTradeParamT_Std3_3] DEFAULT (0) FOR [Std3_3], CONSTRAINT [DF_W@ctgTradeParamT_ExecFlag] DEFAULT (0) FOR [ExecFlag], CONSTRAINT [DF_W@ctgTradeParamT_ExecAmount] DEFAULT (0) FOR [ExecAmount], CONSTRAINT [PK_W@ctgTradeParamT] PRIMARY KEY CLUSTERED ( [PracticeCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cthPCompanyM] ADD CONSTRAINT [DF_W@cthPCompanyM_RegistType] DEFAULT (0) FOR [RegistType], CONSTRAINT [DF_W@cthPCompanyM_CapitalAmount] DEFAULT (0) FOR [CapitalAmount], CONSTRAINT [DF_W@cthPCompanyM_ManagerSalary] DEFAULT (0) FOR [ManagerSalary], CONSTRAINT [DF_W@cthPCompanyM_ManagerMax] DEFAULT (0) FOR [ManagerMax], CONSTRAINT [PK_W@cthPCompanyM] PRIMARY KEY CLUSTERED ( [PracticeCode], [CompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cthPTenantM] ADD CONSTRAINT [DF_W@cthPTenantM_TownNo] DEFAULT (0) FOR [TownNo], CONSTRAINT [DF_W@cthPTenantM_TownSeq] DEFAULT (0) FOR [TownSeq], CONSTRAINT [DF_W@cthPTenantM_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_W@cthPTenantM_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_W@cthPTenantM_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_W@cthPTenantM_CountVisit] DEFAULT (0) FOR [CountVisit], CONSTRAINT [DF_W@cthPTenantM_CountSells] DEFAULT (0) FOR [CountSells], CONSTRAINT [DF_W@cthPTenantM_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_W@cthPTenantM_TransportFlag] DEFAULT (0) FOR [TransportFlag], CONSTRAINT [DF_W@cthPTenantM_ShopDiscAmnt] DEFAULT (0) FOR [ShopDiscAmnt], CONSTRAINT [DF_W@cthPTenantM_ShopDiscRate] DEFAULT (0) FOR [ShopDiscRate], CONSTRAINT [DF_W@cthPTenantM_CloseFlag] DEFAULT (0) FOR [CloseFlag], CONSTRAINT [DF_W@cthPTenantM_ActionFlag] DEFAULT (1) FOR [ActionFlag], CONSTRAINT [PK_W@cthPTenantM] PRIMARY KEY CLUSTERED ( [PracticeCode], [TownNo], [TownSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cthPTenantTItem] ADD CONSTRAINT [DF_W@cthPTenantTItem_StockPrice] DEFAULT (0) FOR [StockPrice], CONSTRAINT [DF_W@cthPTenantTItem_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_W@cthPTenantTItem_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_W@cthPTenantTItem_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_W@cthPTenantTItem_RegistrationType] DEFAULT (0) FOR [RegistrationType], CONSTRAINT [DF_W@cthPTenantTItem_DisplayFlag] DEFAULT (0) FOR [DisplayFlag], CONSTRAINT [DF_W@cthPTenantTItem_DisplaySeq] DEFAULT (0) FOR [DisplaySeq], CONSTRAINT [PK_W@cthPTenantTItem] PRIMARY KEY CLUSTERED ( [PracticeCode], [TenantCode], [ItemCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cthPVoteDtl] ADD CONSTRAINT [DF_W@cthPVoteDtl_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_W@cthPVoteDtl_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_W@cthPVoteDtl_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_W@cthPVoteDtl_Point1] DEFAULT (0) FOR [Point1], CONSTRAINT [DF_W@cthPVoteDtl_Point2] DEFAULT (0) FOR [Point2], CONSTRAINT [DF_W@cthPVoteDtl_Point3] DEFAULT (0) FOR [Point3], CONSTRAINT [DF_W@cthPVoteDtl_Point4] DEFAULT (0) FOR [Point4], CONSTRAINT [DF_W@cthPVoteDtl_Point5] DEFAULT (0) FOR [Point5], CONSTRAINT [DF_W@cthPVoteDtl_TotalPoint] DEFAULT (0) FOR [TotalPoint], CONSTRAINT [PK_W@cthPVoteDtl] PRIMARY KEY CLUSTERED ( [PracticeCode], [PrivateCode], [CompanyCode], [TenantCode], [LoginId], [AddDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctnBuletF] ADD CONSTRAINT [DF_W@ctnBuletF_OriginalNo] DEFAULT (0) FOR [OriginalNo], CONSTRAINT [DF_W@ctnBuletF_BuletNo] DEFAULT (0) FOR [BuletNo], CONSTRAINT [DF_W@ctnBuletF_LastNo] DEFAULT (0) FOR [LastNo], CONSTRAINT [DF_W@ctnBuletF_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_W@ctnBuletF_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_W@ctnBuletF_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_W@ctnBuletF_DeleteFlag] DEFAULT (0) FOR [DeleteFlag], CONSTRAINT [PK_W@ctnBuletF] PRIMARY KEY CLUSTERED ( [PracticeCode], [OriginalNo], [BuletNo], [LastNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctnNewsHdr] ADD CONSTRAINT [DF_W@ctnNewsHdr_NewsNo] DEFAULT (0) FOR [NewsNo], CONSTRAINT [DF_W@ctnNewsHdr_DeleteFlag] DEFAULT (0) FOR [DeleteFlag], CONSTRAINT [DF_W@ctnNewsHdr_LastNo] DEFAULT (0) FOR [LastNo], CONSTRAINT [PK_W@ctnNewsHdr] PRIMARY KEY CLUSTERED ( [PracticeCode], [NewsNo], [TargetGroup] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctnQandAM] ADD CONSTRAINT [DF_W@ctnQandAM_Seq] DEFAULT (0) FOR [Seq], CONSTRAINT [PK_W@ctnQandAM] PRIMARY KEY CLUSTERED ( [PracticeCode], [Seq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctnQandATrn] ADD CONSTRAINT [DF_W@ctnQandATrn_Seq] DEFAULT (0) FOR [Seq], CONSTRAINT [DF_W@ctnQandATrn_Answer] DEFAULT (0) FOR [Answer], CONSTRAINT [PK_W@ctnQandATrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [Seq], [LoginId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpGroupT] ADD CONSTRAINT [DF_W@ctpGroupT_ActionFlag] DEFAULT (0) FOR [ActionFlag], CONSTRAINT [DF_W@ctpGroupT_ShoppingFlag] DEFAULT (0) FOR [ShoppingFlag], CONSTRAINT [DF_W@ctpGroupT_ShoppingLimit] DEFAULT (0) FOR [ShoppingLimit], CONSTRAINT [DF_W@ctpGroupT_DataLinkFlag] DEFAULT (0) FOR [DataLinkFlag], CONSTRAINT [PK_W@ctpGroupT] PRIMARY KEY CLUSTERED ( [PracticeCode], [GroupCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpLoginT] ADD CONSTRAINT [DF_W@ctpLoginT_ActionFlag] DEFAULT (0) FOR [ActionFlag], CONSTRAINT [DF_W@ctpLoginT_ShoppingFlag] DEFAULT (0) FOR [ShoppingFlag], CONSTRAINT [DF_W@ctpLoginT_ShoppingLimit] DEFAULT (0) FOR [ShoppingLimit], CONSTRAINT [DF_W@ctpLoginT_DataLinkFlag] DEFAULT (0) FOR [DataLinkFlag], CONSTRAINT [PK_W@ctpLoginT] PRIMARY KEY CLUSTERED ( [PracticeCode], [LoginId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpPracticeM] ADD CONSTRAINT [DF_W@ctpPracticeM_PracticeSeq] DEFAULT (0) FOR [PracticeSeq], CONSTRAINT [DF_W@ctpPracticeM_UnusedFlag] DEFAULT (0) FOR [UnusedFlag], CONSTRAINT [DF_W@ctpPracticeM_TCloseFlag] DEFAULT (0) FOR [TCloseFlag], CONSTRAINT [DF_W@ctpPracticeM_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [DF_W@ctpPracticeM_ManageFlag] DEFAULT (0) FOR [ManageFlag], CONSTRAINT [DF_W@ctpPracticeM_Settlement] DEFAULT (0) FOR [Settlement], CONSTRAINT [DF_W@ctpPracticeM_ExRate] DEFAULT (0) FOR [ExRate], CONSTRAINT [DF_W@ctpPracticeM_ExConsumptionTax] DEFAULT (0) FOR [ExConsumptionTax], CONSTRAINT [DF_W@ctpPracticeM_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_W@ctpPracticeM_ComputeFlag] DEFAULT (0) FOR [ComputeFlag], CONSTRAINT [DF_W@ctpPracticeM_PCapitalAmount] DEFAULT (0) FOR [PCapitalAmount], CONSTRAINT [DF_W@ctpPracticeM_CCapitalAmount] DEFAULT (0) FOR [CCapitalAmount], CONSTRAINT [DF_W@ctpPracticeM_COfficeGuarantee] DEFAULT (0) FOR [COfficeGuarantee], CONSTRAINT [DF_W@ctpPracticeM_COfficeRentalFee] DEFAULT (0) FOR [COfficeRentalFee], CONSTRAINT [DF_W@ctpPracticeM_COfficeAssetsPrice] DEFAULT (0) FOR [COfficeAssetsPrice], CONSTRAINT [DF_W@ctpPracticeM_HpOpeningCostH] DEFAULT (0) FOR [HpOpeningCostH], CONSTRAINT [DF_W@ctpPracticeM_HpOpeningCostL] DEFAULT (0) FOR [HpOpeningCostL], CONSTRAINT [DF_W@ctpPracticeM_HpRentalFeeH] DEFAULT (0) FOR [HpRentalFeeH], CONSTRAINT [DF_W@ctpPracticeM_HpRentalFeeL] DEFAULT (0) FOR [HpRentalFeeL], CONSTRAINT [DF_W@ctpPracticeM_HpManagerSalary] DEFAULT (0) FOR [HpManagerSalary], CONSTRAINT [DF_W@ctpPracticeM_HpClerkSalary] DEFAULT (0) FOR [HpClerkSalary], CONSTRAINT [DF_W@ctpPracticeM_HpIMaxSell] DEFAULT (0) FOR [HpIMaxSell], CONSTRAINT [DF_W@ctpPracticeM_HpIMaxBuy] DEFAULT (0) FOR [HpIMaxBuy], CONSTRAINT [DF_W@ctpPracticeM_HpStockCheck] DEFAULT (0) FOR [HpStockCheck], CONSTRAINT [DF_W@ctpPracticeM_HpStockAutoFlag] DEFAULT (0) FOR [HpStockAutoFlag], CONSTRAINT [DF_W@ctpPracticeM_HpVoteCheck] DEFAULT (0) FOR [HpVoteCheck], CONSTRAINT [DF_W@ctpPracticeM_PBankLoanLimit] DEFAULT (0) FOR [PBankLoanLimit], CONSTRAINT [DF_W@ctpPracticeM_CBankLoanLimit] DEFAULT (0) FOR [CBankLoanLimit], CONSTRAINT [DF_W@ctpPracticeM_CCreditFee] DEFAULT (0) FOR [CCreditFee], CONSTRAINT [DF_W@ctpPracticeM_CCreditRate] DEFAULT (0) FOR [CCreditRate], CONSTRAINT [DF_W@ctpPracticeM_CCreditLimit] DEFAULT (0) FOR [CCreditLimit], CONSTRAINT [DF_W@ctpPracticeM_PCreditLimit] DEFAULT (0) FOR [PCreditLimit], CONSTRAINT [DF_W@ctpPracticeM_XCreditActFee] DEFAULT (0) FOR [XCreditActFee], CONSTRAINT [DF_W@ctpPracticeM_XSecActFee] DEFAULT (0) FOR [XSecActFee], CONSTRAINT [DF_W@ctpPracticeM_XSecRate] DEFAULT (0) FOR [XSecRate], CONSTRAINT [DF_W@ctpPracticeM_XSecTax] DEFAULT (0) FOR [XSecTax], CONSTRAINT [DF_W@ctpPracticeM_PDealerDiscAmnt] DEFAULT (0) FOR [PDealerDiscAmnt], CONSTRAINT [DF_W@ctpPracticeM_PDealerDiscRate] DEFAULT (0) FOR [PDealerDiscRate], CONSTRAINT [DF_W@ctpPracticeM_CDealerDiscAmnt] DEFAULT (0) FOR [CDealerDiscAmnt], CONSTRAINT [DF_W@ctpPracticeM_CDealerDiscRate] DEFAULT (0) FOR [CDealerDiscRate], CONSTRAINT [DF_W@ctpPracticeM_PMakerDiscAmnt] DEFAULT (0) FOR [PMakerDiscAmnt], CONSTRAINT [DF_W@ctpPracticeM_PMakerDiscRate] DEFAULT (0) FOR [PMakerDiscRate], CONSTRAINT [DF_W@ctpPracticeM_PMakerMakeRate] DEFAULT (0) FOR [PMakerMakeRate], CONSTRAINT [DF_W@ctpPracticeM_PMakerCostRate] DEFAULT (0) FOR [PMakerCostRate], CONSTRAINT [DF_W@ctpPracticeM_PMakerSellRate] DEFAULT (0) FOR [PMakerSellRate], CONSTRAINT [DF_W@ctpPracticeM_CMakerDiscAmnt] DEFAULT (0) FOR [CMakerDiscAmnt], CONSTRAINT [DF_W@ctpPracticeM_CMakerDiscRate] DEFAULT (0) FOR [CMakerDiscRate], CONSTRAINT [DF_W@ctpPracticeM_CMakerMakeRate] DEFAULT (0) FOR [CMakerMakeRate], CONSTRAINT [DF_W@ctpPracticeM_CMakerCostRate] DEFAULT (0) FOR [CMakerCostRate], CONSTRAINT [DF_W@ctpPracticeM_CMakerSellRate] DEFAULT (0) FOR [CMakerSellRate], CONSTRAINT [DF_W@ctpPracticeM_XAdFee] DEFAULT (0) FOR [XAdFee], CONSTRAINT [DF_W@ctpPracticeM_XAdFee2] DEFAULT (0) FOR [XAdFee2], CONSTRAINT [DF_W@ctpPracticeM_SearchNGFlag] DEFAULT (0) FOR [SearchNGFlag], CONSTRAINT [DF_W@ctpPracticeM_POption01] DEFAULT (0) FOR [POption01], CONSTRAINT [DF_W@ctpPracticeM_POption02] DEFAULT (0) FOR [POption02], CONSTRAINT [DF_W@ctpPracticeM_POption03] DEFAULT (0) FOR [POption03], CONSTRAINT [DF_W@ctpPracticeM_POption04] DEFAULT (0) FOR [POption04], CONSTRAINT [DF_W@ctpPracticeM_POption05] DEFAULT (0) FOR [POption05], CONSTRAINT [PK_W@ctpPracticeM] PRIMARY KEY CLUSTERED ( [PracticeCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpTReport] ADD CONSTRAINT [DF_W@ctpTReport_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_W@ctpTReport_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_W@ctpTReport_BS] DEFAULT (0) FOR [BS], CONSTRAINT [DF_W@ctpTReport_BGenkin] DEFAULT (0) FOR [BGenkin], CONSTRAINT [DF_W@ctpTReport_BUrikakekin] DEFAULT (0) FOR [BUrikakekin], CONSTRAINT [DF_W@ctpTReport_BKaribaraiZei] DEFAULT (0) FOR [BKaribaraiZei], CONSTRAINT [DF_W@ctpTReport_BYukasyoken] DEFAULT (0) FOR [BYukasyoken], CONSTRAINT [DF_W@ctpTReport_BTanaoroshi] DEFAULT (0) FOR [BTanaoroshi], CONSTRAINT [DF_W@ctpTReport_BSonota] DEFAULT (0) FOR [BSonota], CONSTRAINT [DF_W@ctpTReport_BKurinobe] DEFAULT (0) FOR [BKurinobe], CONSTRAINT [DF_W@ctpTReport_BDTa1] DEFAULT (0) FOR [BDTa1], CONSTRAINT [DF_W@ctpTReport_BDTa2] DEFAULT (0) FOR [BDTa2], CONSTRAINT [DF_W@ctpTReport_BKaikakekin] DEFAULT (0) FOR [BKaikakekin], CONSTRAINT [DF_W@ctpTReport_BMibarai1] DEFAULT (0) FOR [BMibarai1], CONSTRAINT [DF_W@ctpTReport_BMibarai2] DEFAULT (0) FOR [BMibarai2], CONSTRAINT [DF_W@ctpTReport_BKariukeZei] DEFAULT (0) FOR [BKariukeZei], CONSTRAINT [DF_W@ctpTReport_BShihonkin] DEFAULT (0) FOR [BShihonkin], CONSTRAINT [DF_W@ctpTReport_BCTa1] DEFAULT (0) FOR [BCTa1], CONSTRAINT [DF_W@ctpTReport_BCTa2] DEFAULT (0) FOR [BCTa2], CONSTRAINT [DF_W@ctpTReport_PL] DEFAULT (0) FOR [PL], CONSTRAINT [DF_W@ctpTReport_PUriage] DEFAULT (0) FOR [PUriage], CONSTRAINT [DF_W@ctpTReport_PGenka] DEFAULT (0) FOR [PGenka], CONSTRAINT [DF_W@ctpTReport_PUrisoRieki] DEFAULT (0) FOR [PUrisoRieki], CONSTRAINT [DF_W@ctpTReport_PHankanhi] DEFAULT (0) FOR [PHankanhi], CONSTRAINT [DF_W@ctpTReport_PEigyoSonEki] DEFAULT (0) FOR [PEigyoSonEki], CONSTRAINT [DF_W@ctpTReport_PGaiEkiKabu] DEFAULT (0) FOR [PGaiEkiKabu], CONSTRAINT [DF_W@ctpTReport_PGaiEkiTa] DEFAULT (0) FOR [PGaiEkiTa], CONSTRAINT [DF_W@ctpTReport_PGaiSonHiyo] DEFAULT (0) FOR [PGaiSonHiyo], CONSTRAINT [DF_W@ctpTReport_PGaiSonKabu] DEFAULT (0) FOR [PGaiSonKabu], CONSTRAINT [DF_W@ctpTReport_PGaiSonTa] DEFAULT (0) FOR [PGaiSonTa], CONSTRAINT [DF_W@ctpTReport_PKeijoSonEki] DEFAULT (0) FOR [PKeijoSonEki], CONSTRAINT [DF_W@ctpTReport_PToukiSonEki] DEFAULT (0) FOR [PToukiSonEki], CONSTRAINT [DF_W@ctpTReport_PH] DEFAULT (0) FOR [PH], CONSTRAINT [DF_W@ctpTReport_PHKaihatuhi] DEFAULT (0) FOR [PHKaihatuhi], CONSTRAINT [DF_W@ctpTReport_PHUnchin] DEFAULT (0) FOR [PHUnchin], CONSTRAINT [DF_W@ctpTReport_PHSendenhi] DEFAULT (0) FOR [PHSendenhi], CONSTRAINT [DF_W@ctpTReport_PHJinkenhi] DEFAULT (0) FOR [PHJinkenhi], CONSTRAINT [DF_W@ctpTReport_PHHpkanrihi] DEFAULT (0) FOR [PHHpkanrihi], CONSTRAINT [DF_W@ctpTReport_PHYachin] DEFAULT (0) FOR [PHYachin], CONSTRAINT [DF_W@ctpTReport_PHTesuryo] DEFAULT (0) FOR [PHTesuryo], CONSTRAINT [DF_W@ctpTReport_PHSonota] DEFAULT (0) FOR [PHSonota], CONSTRAINT [DF_W@ctpTReport_PHTa1] DEFAULT (0) FOR [PHTa1], CONSTRAINT [DF_W@ctpTReport_PHTa2] DEFAULT (0) FOR [PHTa2], CONSTRAINT [DF_W@ctpTReport_OldFlag] DEFAULT (0) FOR [OldFlag], CONSTRAINT [PK_W@ctpTReport] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ReportDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpTownT] ADD CONSTRAINT [DF_W@ctpTownT_TownNo] DEFAULT (0) FOR [TownNo], CONSTRAINT [DF_W@ctpTownT_NumberOfShop] DEFAULT (0) FOR [NumberOfShop], CONSTRAINT [PK_W@ctpTownT] PRIMARY KEY CLUSTERED ( [PracticeCode], [TownNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctpTradeTrn] ADD CONSTRAINT [DF_W@ctpTradeTrn_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_W@ctpTradeTrn_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_W@ctpTradeTrn_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_W@ctpTradeTrn_ActNo] DEFAULT (0) FOR [ActNo], CONSTRAINT [DF_W@ctpTradeTrn_OrderNo] DEFAULT (0) FOR [OrderNo], CONSTRAINT [DF_W@ctpTradeTrn_OrderSeq] DEFAULT (0) FOR [OrderSeq], CONSTRAINT [DF_W@ctpTradeTrn_BPrivateCode] DEFAULT ('') FOR [BPrivateCode], CONSTRAINT [DF_W@ctpTradeTrn_BCompanyCode] DEFAULT ('') FOR [BCompanyCode], CONSTRAINT [DF_W@ctpTradeTrn_BTenantCode] DEFAULT ('') FOR [BTenantCode], CONSTRAINT [DF_W@ctpTradeTrn_PaymentTerm] DEFAULT (0) FOR [PaymentTerm], CONSTRAINT [DF_W@ctpTradeTrn_TransportFlag] DEFAULT (0) FOR [TransportFlag], CONSTRAINT [DF_W@ctpTradeTrn_SellsDiscFlag] DEFAULT (0) FOR [SellsDiscFlag], CONSTRAINT [DF_W@ctpTradeTrn_COfficeAssetsFlag] DEFAULT (0) FOR [COfficeAssetsFlag], CONSTRAINT [DF_W@ctpTradeTrn_Qty] DEFAULT (0) FOR [Qty], CONSTRAINT [DF_W@ctpTradeTrn_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_W@ctpTradeTrn_MakesPrice] DEFAULT (0) FOR [MakesPrice], CONSTRAINT [DF_W@ctpTradeTrn_StockPrice] DEFAULT (0) FOR [StockPrice], CONSTRAINT [DF_W@ctpTradeTrn_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_W@ctpTradeTrn_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_W@ctpTradeTrn_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_W@ctpTradeTrn_CCreditRate] DEFAULT (0) FOR [CCreditRate], CONSTRAINT [DF_W@ctpTradeTrn_MakesAmnt] DEFAULT (0) FOR [MakesAmnt], CONSTRAINT [DF_W@ctpTradeTrn_StockAmnt] DEFAULT (0) FOR [StockAmnt], CONSTRAINT [DF_W@ctpTradeTrn_SellsAmnt] DEFAULT (0) FOR [SellsAmnt], CONSTRAINT [DF_W@ctpTradeTrn_TaxAmnt] DEFAULT (0) FOR [TaxAmnt], CONSTRAINT [DF_W@ctpTradeTrn_TransportAmnt] DEFAULT (0) FOR [TransportAmnt], CONSTRAINT [DF_W@ctpTradeTrn_TransportTax] DEFAULT (0) FOR [TransportTax], CONSTRAINT [DF_W@ctpTradeTrn_CreditAmnt] DEFAULT (0) FOR [CreditAmnt], CONSTRAINT [DF_W@ctpTradeTrn_AAmnt] DEFAULT (0) FOR [AAmnt], CONSTRAINT [DF_W@ctpTradeTrn_BAmnt] DEFAULT (0) FOR [BAmnt], CONSTRAINT [PK_W@ctpTradeTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [TradeCode], [OrderNo], [OrderSeq], [AddDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctsCodeTS] ADD CONSTRAINT [DF_W@ctsCodeTS_UnusedFlag] DEFAULT (0) FOR [UnusedFlag], CONSTRAINT [DF_W@ctsCodeTS_gifSizeW] DEFAULT (0) FOR [gifSizeW], CONSTRAINT [DF_W@ctsCodeTS_gifSizeH] DEFAULT (0) FOR [gifSizeH], CONSTRAINT [PK_W@ctsCodeTS] PRIMARY KEY CLUSTERED ( [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctsCodeTSgif] ADD CONSTRAINT [DF_W@ctsCodeTSgif_SallFlag] DEFAULT (0) FOR [SallFlag], CONSTRAINT [DF_W@ctsCodeTSgif_SPracticeCode] DEFAULT ('') FOR [SPracticeCode], CONSTRAINT [DF_W@ctsCodeTSgif_SPrivateCode] DEFAULT ('') FOR [SPrivateCode], CONSTRAINT [DF_W@ctsCodeTSgif_SCompanyCode] DEFAULT ('') FOR [SCompanyCode], CONSTRAINT [DF_W@ctsCodeTSgif_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_W@ctsCodeTSgif] PRIMARY KEY CLUSTERED ( [IdentKey], [IdentName], [SPracticeCode], [SPrivateCode], [SCompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctsCodeTU] ADD CONSTRAINT [PK_W@ctsCodeTU] PRIMARY KEY CLUSTERED ( [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctsCodeTUprcItem] ADD CONSTRAINT [PK_W@ctsCodeTUprcItem] PRIMARY KEY CLUSTERED ( [PracticeCode], [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctsSystemF] ADD CONSTRAINT [PK_W@ctsSystemF] PRIMARY KEY CLUSTERED ( [UserCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cttStockM] ADD CONSTRAINT [DF_W@cttStockM_DealingUnit] DEFAULT (0) FOR [DealingUnit], CONSTRAINT [DF_W@cttStockM_FaceValue] DEFAULT (0) FOR [FaceValue], CONSTRAINT [DF_W@cttStockM_StartPrice] DEFAULT (0) FOR [StartPrice], CONSTRAINT [DF_W@cttStockM_HighPrice] DEFAULT (0) FOR [HighPrice], CONSTRAINT [DF_W@cttStockM_LowPrice] DEFAULT (0) FOR [LowPrice], CONSTRAINT [DF_W@cttStockM_EndPrice] DEFAULT (0) FOR [EndPrice], CONSTRAINT [DF_W@cttStockM_MoveValue] DEFAULT (0) FOR [MoveValue], CONSTRAINT [DF_W@cttStockM_TradeQty] DEFAULT (0) FOR [TradeQty], CONSTRAINT [DF_W@cttStockM_UpperLimitRate] DEFAULT (0) FOR [UpperLimitRate], CONSTRAINT [DF_W@cttStockM_LowerLimitRate] DEFAULT (0) FOR [LowerLimitRate], CONSTRAINT [PK_W@cttStockM] PRIMARY KEY CLUSTERED ( [PracticeCode], [StockCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@cttTradeMemberM] ADD CONSTRAINT [DF_W@cttTradeMemberM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [PK_W@cttTradeMemberM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctxGroupM] ADD CONSTRAINT [DF_W@ctxGroupM_GroupSeq] DEFAULT (0) FOR [GroupSeq], CONSTRAINT [DF_W@ctxGroupM_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_W@ctxGroupM] PRIMARY KEY CLUSTERED ( [GroupCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[W@ctxLoginF] ADD CONSTRAINT [DF_W@ctxLoginF_LoginFlag] DEFAULT (0) FOR [LoginFlag], CONSTRAINT [DF_W@ctxLoginF_LoginError] DEFAULT (0) FOR [LoginError], CONSTRAINT [DF_W@ctxLoginF_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_W@ctxLoginF] PRIMARY KEY CLUSTERED ( [LoginId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctaAuctionM] ADD CONSTRAINT [DF_ctaAuctionM_AuctionNo] DEFAULT (0) FOR [AuctionNo], CONSTRAINT [DF_ctaAuctionM_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_ctaAuctionM_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_ctaAuctionM_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_ctaAuctionM_Qty] DEFAULT (0) FOR [Qty], CONSTRAINT [DF_ctaAuctionM_LimitPrice] DEFAULT (0) FOR [LimitPrice], CONSTRAINT [DF_ctaAuctionM_AuctionStatus] DEFAULT (0) FOR [AuctionStatus], CONSTRAINT [PK_ctaAuctionM] PRIMARY KEY CLUSTERED ( [PracticeCode], [AuctionNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctaAuctionTrn] ADD CONSTRAINT [DF_ctaAuctionTrn_AuctionNo] DEFAULT (0) FOR [AuctionNo], CONSTRAINT [DF_ctaAuctionTrn_BPrivateCode] DEFAULT ('') FOR [BPrivateCode], CONSTRAINT [DF_ctaAuctionTrn_BCompanyCode] DEFAULT ('') FOR [BCompanyCode], CONSTRAINT [DF_ctaAuctionTrn_BTenantCode] DEFAULT ('') FOR [BTenantCode], CONSTRAINT [DF_ctaAuctionTrn_BidQty] DEFAULT (0) FOR [BidQty], CONSTRAINT [DF_ctaAuctionTrn_BidPrice] DEFAULT (0) FOR [BidPrice], CONSTRAINT [DF_ctaAuctionTrn_BidFlag] DEFAULT (0) FOR [BidFlag], CONSTRAINT [PK_ctaAuctionTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [AuctionNo], [BidSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctaBannerRoboT] ADD CONSTRAINT [DF_ctaBannerRoboT_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_ctaBannerRoboT_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_ctaBannerRoboT_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_ctaBannerRoboT_RoboSeq] DEFAULT (0) FOR [RoboSeq], CONSTRAINT [DF_ctaBannerRoboT_SCount] DEFAULT (0) FOR [SCount], CONSTRAINT [PK_ctaBannerRoboT] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [RoboSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctaSearchRoboT] ADD CONSTRAINT [DF_ctaSearchRoboT_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_ctaSearchRoboT_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_ctaSearchRoboT_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_ctaSearchRoboT_RoboSeq] DEFAULT (0) FOR [RoboSeq], CONSTRAINT [DF_ctaSearchRoboT_SCount] DEFAULT (0) FOR [SCount], CONSTRAINT [PK_ctaSearchRoboT] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [RoboSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctbBankAccountM] ADD CONSTRAINT [DF_ctbBankAccountM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [DF_ctbBankAccountM_BankLoanLimit] DEFAULT (0) FOR [BankLoanLimit], CONSTRAINT [DF_ctbBankAccountM_StopFlag] DEFAULT (0) FOR [StopFlag], CONSTRAINT [DF_ctbBankAccountM_LoginAction] DEFAULT (0) FOR [LoginAction], CONSTRAINT [PK_ctbBankAccountM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctcCreditAccountM] ADD CONSTRAINT [DF_ctcCreditAccountM_CreditRate] DEFAULT (0) FOR [CreditRate], CONSTRAINT [PK_ctcCreditAccountM] PRIMARY KEY CLUSTERED ( [PracticeCode], [CompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctcCreditMemberM] ADD CONSTRAINT [DF_ctcCreditMemberM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [DF_ctcCreditMemberM_TrustLimit] DEFAULT (0) FOR [TrustLimit], CONSTRAINT [PK_ctcCreditMemberM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctdItemM] ADD CONSTRAINT [DF_ctdItemM_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_ctdItemM_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_ctdItemM_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_ctdItemM_RegistrationType] DEFAULT (0) FOR [RegistrationType], CONSTRAINT [DF_ctdItemM_SGroupCode] DEFAULT ('') FOR [SGroupCode], CONSTRAINT [PK_ctdItemM] PRIMARY KEY CLUSTERED ( [PracticeCode], [ItemCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cteMailTrn] ADD CONSTRAINT [DF_cteMailTrn_SPrivateCode] DEFAULT ('') FOR [SPrivateCode], CONSTRAINT [DF_cteMailTrn_SCompanyCode] DEFAULT ('') FOR [SCompanyCode], CONSTRAINT [DF_cteMailTrn_STenantCode] DEFAULT ('') FOR [STenantCode], CONSTRAINT [DF_cteMailTrn_TPrivateCode] DEFAULT ('') FOR [TPrivateCode], CONSTRAINT [DF_cteMailTrn_TCompanyCode] DEFAULT ('') FOR [TCompanyCode], CONSTRAINT [DF_cteMailTrn_TTenantCode] DEFAULT ('') FOR [TTenantCode], CONSTRAINT [DF_cteMailTrn_ActNo] DEFAULT (0) FOR [ActNo], CONSTRAINT [DF_cteMailTrn_ReadFlag] DEFAULT (0) FOR [ReadFlag], CONSTRAINT [DF_cteMailTrn_SndDelFlag] DEFAULT (0) FOR [SndDelFlag], CONSTRAINT [DF_cteMailTrn_RecDelFlag] DEFAULT (0) FOR [RecDelFlag], CONSTRAINT [PK_cteMailTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [MailNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctgTradeParamT] ADD CONSTRAINT [DF_ctgTradeParamT_Std1] DEFAULT (0) FOR [Std1], CONSTRAINT [DF_ctgTradeParamT_Std2] DEFAULT (0) FOR [Std2], CONSTRAINT [DF_ctgTradeParamT_Std3] DEFAULT (0) FOR [Std3], CONSTRAINT [DF_ctgTradeParamT_Std1_1] DEFAULT (0) FOR [Std1_1], CONSTRAINT [DF_ctgTradeParamT_Std1_2] DEFAULT (0) FOR [Std1_2], CONSTRAINT [DF_ctgTradeParamT_Std1_3] DEFAULT (0) FOR [Std1_3], CONSTRAINT [DF_ctgTradeParamT_Std2_1] DEFAULT (0) FOR [Std2_1], CONSTRAINT [DF_ctgTradeParamT_Std2_2] DEFAULT (0) FOR [Std2_2], CONSTRAINT [DF_ctgTradeParamT_Std2_3] DEFAULT (0) FOR [Std2_3], CONSTRAINT [DF_ctgTradeParamT_Std3_1] DEFAULT (0) FOR [Std3_1], CONSTRAINT [DF_ctgTradeParamT_Std3_2] DEFAULT (0) FOR [Std3_2], CONSTRAINT [DF_ctgTradeParamT_Std3_3] DEFAULT (0) FOR [Std3_3], CONSTRAINT [DF_ctgTradeParamT_ExecFlag] DEFAULT (0) FOR [ExecFlag], CONSTRAINT [DF_ctgTradeParamT_ExecAmount] DEFAULT (0) FOR [ExecAmount], CONSTRAINT [PK_ctgTradeParamT] PRIMARY KEY CLUSTERED ( [PracticeCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cthPCompanyM] ADD CONSTRAINT [DF_cthPCompanyM_RegistType] DEFAULT (0) FOR [RegistType], CONSTRAINT [DF_cthPCompanyM_CapitalAmount] DEFAULT (0) FOR [CapitalAmount], CONSTRAINT [DF_cthPCompanyM_ManagerSalary] DEFAULT (0) FOR [ManagerSalary], CONSTRAINT [DF_cthPCompanyM_ManagerMax] DEFAULT (0) FOR [ManagerMax], CONSTRAINT [PK_cthPCompanyM] PRIMARY KEY CLUSTERED ( [PracticeCode], [CompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cthPTenantM] ADD CONSTRAINT [DF_cthPTenantM_TownNo] DEFAULT (0) FOR [TownNo], CONSTRAINT [DF_cthPTenantM_TownSeq] DEFAULT (0) FOR [TownSeq], CONSTRAINT [DF_cthPTenantM_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_cthPTenantM_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_cthPTenantM_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_cthPTenantM_CountVisit] DEFAULT (0) FOR [CountVisit], CONSTRAINT [DF_cthPTenantM_CountSells] DEFAULT (0) FOR [CountSells], CONSTRAINT [DF_cthPTenantM_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_cthPTenantM_TransportFlag] DEFAULT (0) FOR [TransportFlag], CONSTRAINT [DF_cthPTenantM_ShopDiscAmnt] DEFAULT (0) FOR [ShopDiscAmnt], CONSTRAINT [DF_cthPTenantM_ShopDiscRate] DEFAULT (0) FOR [ShopDiscRate], CONSTRAINT [DF_cthPTenantM_CloseFlag] DEFAULT (0) FOR [CloseFlag], CONSTRAINT [DF_cthPTenantM_ActionFlag] DEFAULT (1) FOR [ActionFlag], CONSTRAINT [PK_cthPTenantM] PRIMARY KEY CLUSTERED ( [PracticeCode], [TownNo], [TownSeq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cthPTenantTItem] ADD CONSTRAINT [DF_cthPTenantTItem_StockPrice] DEFAULT (0) FOR [StockPrice], CONSTRAINT [DF_cthPTenantTItem_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_cthPTenantTItem_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_cthPTenantTItem_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_cthPTenantTItem_RegistrationType] DEFAULT (0) FOR [RegistrationType], CONSTRAINT [DF_cthPTenantTItem_DisplayFlag] DEFAULT (0) FOR [DisplayFlag], CONSTRAINT [DF_cthPTenantTItem_DisplaySeq] DEFAULT (0) FOR [DisplaySeq], CONSTRAINT [PK_cthPTenantTItem] PRIMARY KEY CLUSTERED ( [PracticeCode], [TenantCode], [ItemCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cthPVoteDtl] ADD CONSTRAINT [DF_cthPVoteDtl_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_cthPVoteDtl_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_cthPVoteDtl_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_cthPVoteDtl_Point1] DEFAULT (0) FOR [Point1], CONSTRAINT [DF_cthPVoteDtl_Point2] DEFAULT (0) FOR [Point2], CONSTRAINT [DF_cthPVoteDtl_Point3] DEFAULT (0) FOR [Point3], CONSTRAINT [DF_cthPVoteDtl_Point4] DEFAULT (0) FOR [Point4], CONSTRAINT [DF_cthPVoteDtl_Point5] DEFAULT (0) FOR [Point5], CONSTRAINT [DF_cthPVoteDtl_TotalPoint] DEFAULT (0) FOR [TotalPoint], CONSTRAINT [PK_cthPVoteDtl] PRIMARY KEY CLUSTERED ( [PracticeCode], [PrivateCode], [CompanyCode], [TenantCode], [LoginId], [AddDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctnBuletF] ADD CONSTRAINT [DF_ctnBuletF_OriginalNo] DEFAULT (0) FOR [OriginalNo], CONSTRAINT [DF_ctnBuletF_BuletNo] DEFAULT (0) FOR [BuletNo], CONSTRAINT [DF_ctnBuletF_LastNo] DEFAULT (0) FOR [LastNo], CONSTRAINT [DF_ctnBuletF_PrivateCode] DEFAULT ('') FOR [PrivateCode], CONSTRAINT [DF_ctnBuletF_CompanyCode] DEFAULT ('') FOR [CompanyCode], CONSTRAINT [DF_ctnBuletF_TenantCode] DEFAULT ('') FOR [TenantCode], CONSTRAINT [DF_ctnBuletF_DeleteFlag] DEFAULT (0) FOR [DeleteFlag], CONSTRAINT [PK_ctnBuletF] PRIMARY KEY CLUSTERED ( [PracticeCode], [OriginalNo], [BuletNo], [LastNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctnNewsHdr] ADD CONSTRAINT [DF_ctnNewsHdr_NewsNo] DEFAULT (0) FOR [NewsNo], CONSTRAINT [DF_ctnNewsHdr_DeleteFlag] DEFAULT (0) FOR [DeleteFlag], CONSTRAINT [DF_ctnNewsHdr_LastNo] DEFAULT (0) FOR [LastNo], CONSTRAINT [PK_ctnNewsHdr] PRIMARY KEY CLUSTERED ( [PracticeCode], [NewsNo], [TargetGroup] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctnQandAM] ADD CONSTRAINT [DF_ctnQandAM_Seq] DEFAULT (0) FOR [Seq], CONSTRAINT [PK_ctnQandAM] PRIMARY KEY CLUSTERED ( [PracticeCode], [Seq] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctnQandATrn] ADD CONSTRAINT [DF_ctnQandATrn_Seq] DEFAULT (0) FOR [Seq], CONSTRAINT [DF_ctnQandATrn_Answer] DEFAULT (0) FOR [Answer], CONSTRAINT [PK_ctnQandATrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [Seq], [LoginId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpGroupT] ADD CONSTRAINT [DF_ctpGroupT_ActionFlag] DEFAULT (0) FOR [ActionFlag], CONSTRAINT [DF_ctpGroupT_ShoppingFlag] DEFAULT (0) FOR [ShoppingFlag], CONSTRAINT [DF_ctpGroupT_ShoppingLimit] DEFAULT (0) FOR [ShoppingLimit], CONSTRAINT [DF_ctpGroupT_DataLinkFlag] DEFAULT (0) FOR [DataLinkFlag], CONSTRAINT [DF_ctpGroupT_会社経営可否] DEFAULT (3) FOR [会社経営可否], CONSTRAINT [PK_ctpGroupT] PRIMARY KEY CLUSTERED ( [PracticeCode], [GroupCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpLoginT] ADD CONSTRAINT [DF_ctpLoginT_ActionFlag] DEFAULT (0) FOR [ActionFlag], CONSTRAINT [DF_ctpLoginT_ShoppingFlag] DEFAULT (0) FOR [ShoppingFlag], CONSTRAINT [DF_ctpLoginT_ShoppingLimit] DEFAULT (0) FOR [ShoppingLimit], CONSTRAINT [DF_ctpLoginT_DataLinkFlag] DEFAULT (0) FOR [DataLinkFlag], CONSTRAINT [DF_ctpLoginT_会社経営可否] DEFAULT (3) FOR [会社経営可否], CONSTRAINT [PK_ctpLoginT] PRIMARY KEY CLUSTERED ( [PracticeCode], [LoginId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpPracticeM] ADD CONSTRAINT [DF_ctpPracticeM_PracticeSeq] DEFAULT (0) FOR [PracticeSeq], CONSTRAINT [DF_ctpPracticeM_UnusedFlag] DEFAULT (0) FOR [UnusedFlag], CONSTRAINT [DF_ctpPracticeM_TCloseFlag] DEFAULT (0) FOR [TCloseFlag], CONSTRAINT [DF_ctpPracticeM_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [DF_ctpPracticeM_ManageFlag] DEFAULT (0) FOR [ManageFlag], CONSTRAINT [DF_ctpPracticeM_Settlement] DEFAULT (0) FOR [Settlement], CONSTRAINT [DF_ctpPracticeM_ExRate] DEFAULT (0) FOR [ExRate], CONSTRAINT [DF_ctpPracticeM_ExConsumptionTax] DEFAULT (0) FOR [ExConsumptionTax], CONSTRAINT [DF_ctpPracticeM_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_ctpPracticeM_ComputeFlag] DEFAULT (0) FOR [ComputeFlag], CONSTRAINT [DF_ctpPracticeM_PCapitalAmount] DEFAULT (0) FOR [PCapitalAmount], CONSTRAINT [DF_ctpPracticeM_CCapitalAmount] DEFAULT (0) FOR [CCapitalAmount], CONSTRAINT [DF_ctpPracticeM_COfficeGuarantee] DEFAULT (0) FOR [COfficeGuarantee], CONSTRAINT [DF_ctpPracticeM_COfficeRentalFee] DEFAULT (0) FOR [COfficeRentalFee], CONSTRAINT [DF_ctpPracticeM_COfficeAssetsPrice] DEFAULT (0) FOR [COfficeAssetsPrice], CONSTRAINT [DF_ctpPracticeM_HpOpeningCostH] DEFAULT (0) FOR [HpOpeningCostH], CONSTRAINT [DF_ctpPracticeM_HpOpeningCostL] DEFAULT (0) FOR [HpOpeningCostL], CONSTRAINT [DF_ctpPracticeM_HpRentalFeeH] DEFAULT (0) FOR [HpRentalFeeH], CONSTRAINT [DF_ctpPracticeM_HpRentalFeeL] DEFAULT (0) FOR [HpRentalFeeL], CONSTRAINT [DF_ctpPracticeM_HpManagerSalary] DEFAULT (0) FOR [HpManagerSalary], CONSTRAINT [DF_ctpPracticeM_HpClerkSalary] DEFAULT (0) FOR [HpClerkSalary], CONSTRAINT [DF_ctpPracticeM_HpIMaxSell] DEFAULT (0) FOR [HpIMaxSell], CONSTRAINT [DF_ctpPracticeM_HpIMaxBuy] DEFAULT (0) FOR [HpIMaxBuy], CONSTRAINT [DF_ctpPracticeM_HpStockCheck] DEFAULT (0) FOR [HpStockCheck], CONSTRAINT [DF_ctpPracticeM_HpStockAutoFlag] DEFAULT (0) FOR [HpStockAutoFlag], CONSTRAINT [DF_ctpPracticeM_HpVoteCheck] DEFAULT (0) FOR [HpVoteCheck], CONSTRAINT [DF_ctpPracticeM_PBankLoanLimit] DEFAULT (0) FOR [PBankLoanLimit], CONSTRAINT [DF_ctpPracticeM_CBankLoanLimit] DEFAULT (0) FOR [CBankLoanLimit], CONSTRAINT [DF_ctpPracticeM_CCreditFee] DEFAULT (0) FOR [CCreditFee], CONSTRAINT [DF_ctpPracticeM_CCreditRate] DEFAULT (0) FOR [CCreditRate], CONSTRAINT [DF_ctpPracticeM_CCreditLimit] DEFAULT (0) FOR [CCreditLimit], CONSTRAINT [DF_ctpPracticeM_PCreditLimit] DEFAULT (0) FOR [PCreditLimit], CONSTRAINT [DF_ctpPracticeM_XCreditActFee] DEFAULT (0) FOR [XCreditActFee], CONSTRAINT [DF_ctpPracticeM_XSecActFee] DEFAULT (0) FOR [XSecActFee], CONSTRAINT [DF_ctpPracticeM_XSecRate] DEFAULT (0) FOR [XSecRate], CONSTRAINT [DF_ctpPracticeM_XSecTax] DEFAULT (0) FOR [XSecTax], CONSTRAINT [DF_ctpPracticeM_PDealerDiscAmnt] DEFAULT (0) FOR [PDealerDiscAmnt], CONSTRAINT [DF_ctpPracticeM_PDealerDiscRate] DEFAULT (0) FOR [PDealerDiscRate], CONSTRAINT [DF_ctpPracticeM_CDealerDiscAmnt] DEFAULT (0) FOR [CDealerDiscAmnt], CONSTRAINT [DF_ctpPracticeM_CDealerDiscRate] DEFAULT (0) FOR [CDealerDiscRate], CONSTRAINT [DF_ctpPracticeM_PMakerDiscAmnt] DEFAULT (0) FOR [PMakerDiscAmnt], CONSTRAINT [DF_ctpPracticeM_PMakerDiscRate] DEFAULT (0) FOR [PMakerDiscRate], CONSTRAINT [DF_ctpPracticeM_PMakerMakeRate] DEFAULT (0) FOR [PMakerMakeRate], CONSTRAINT [DF_ctpPracticeM_PMakerCostRate] DEFAULT (0) FOR [PMakerCostRate], CONSTRAINT [DF_ctpPracticeM_PMakerSellRate] DEFAULT (0) FOR [PMakerSellRate], CONSTRAINT [DF_ctpPracticeM_CMakerDiscAmnt] DEFAULT (0) FOR [CMakerDiscAmnt], CONSTRAINT [DF_ctpPracticeM_CMakerDiscRate] DEFAULT (0) FOR [CMakerDiscRate], CONSTRAINT [DF_ctpPracticeM_CMakerMakeRate] DEFAULT (0) FOR [CMakerMakeRate], CONSTRAINT [DF_ctpPracticeM_CMakerCostRate] DEFAULT (0) FOR [CMakerCostRate], CONSTRAINT [DF_ctpPracticeM_CMakerSellRate] DEFAULT (0) FOR [CMakerSellRate], CONSTRAINT [DF_ctpPracticeM_XAdFee] DEFAULT (0) FOR [XAdFee], CONSTRAINT [DF_ctpPracticeM_XAdFee2] DEFAULT (0) FOR [XAdFee2], CONSTRAINT [DF_ctpPracticeM_SearchNGFlag] DEFAULT (0) FOR [SearchNGFlag], CONSTRAINT [DF_ctpPracticeM_POption01] DEFAULT (0) FOR [POption01], CONSTRAINT [DF_ctpPracticeM_POption02] DEFAULT (0) FOR [POption02], CONSTRAINT [DF_ctpPracticeM_POption03] DEFAULT (0) FOR [POption03], CONSTRAINT [DF_ctpPracticeM_POption04] DEFAULT (0) FOR [POption04], CONSTRAINT [DF_ctpPracticeM_POption05] DEFAULT (0) FOR [POption05], CONSTRAINT [PK_ctpPracticeM] PRIMARY KEY CLUSTERED ( [PracticeCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpTReport] ADD CONSTRAINT [DF_ctpTReport_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_ctpTReport_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_ctpTReport_BS] DEFAULT (0) FOR [BS], CONSTRAINT [DF_ctpTReport_BGenkin] DEFAULT (0) FOR [BGenkin], CONSTRAINT [DF_ctpTReport_BUrikakekin] DEFAULT (0) FOR [BUrikakekin], CONSTRAINT [DF_ctpTReport_BKaribaraiZei] DEFAULT (0) FOR [BKaribaraiZei], CONSTRAINT [DF_ctpTReport_BYukasyoken] DEFAULT (0) FOR [BYukasyoken], CONSTRAINT [DF_ctpTReport_BTanaoroshi] DEFAULT (0) FOR [BTanaoroshi], CONSTRAINT [DF_ctpTReport_BSonota] DEFAULT (0) FOR [BSonota], CONSTRAINT [DF_ctpTReport_BKurinobe] DEFAULT (0) FOR [BKurinobe], CONSTRAINT [DF_ctpTReport_BDTa1] DEFAULT (0) FOR [BDTa1], CONSTRAINT [DF_ctpTReport_BDTa2] DEFAULT (0) FOR [BDTa2], CONSTRAINT [DF_ctpTReport_BKaikakekin] DEFAULT (0) FOR [BKaikakekin], CONSTRAINT [DF_ctpTReport_BMibarai1] DEFAULT (0) FOR [BMibarai1], CONSTRAINT [DF_ctpTReport_BMibarai2] DEFAULT (0) FOR [BMibarai2], CONSTRAINT [DF_ctpTReport_BKariukeZei] DEFAULT (0) FOR [BKariukeZei], CONSTRAINT [DF_ctpTReport_BShihonkin] DEFAULT (0) FOR [BShihonkin], CONSTRAINT [DF_ctpTReport_BCTa1] DEFAULT (0) FOR [BCTa1], CONSTRAINT [DF_ctpTReport_BCTa2] DEFAULT (0) FOR [BCTa2], CONSTRAINT [DF_ctpTReport_PL] DEFAULT (0) FOR [PL], CONSTRAINT [DF_ctpTReport_PUriage] DEFAULT (0) FOR [PUriage], CONSTRAINT [DF_ctpTReport_PGenka] DEFAULT (0) FOR [PGenka], CONSTRAINT [DF_ctpTReport_PUrisoRieki] DEFAULT (0) FOR [PUrisoRieki], CONSTRAINT [DF_ctpTReport_PHankanhi] DEFAULT (0) FOR [PHankanhi], CONSTRAINT [DF_ctpTReport_PEigyoSonEki] DEFAULT (0) FOR [PEigyoSonEki], CONSTRAINT [DF_ctpTReport_PGaiEkiKabu] DEFAULT (0) FOR [PGaiEkiKabu], CONSTRAINT [DF_ctpTReport_PGaiEkiTa] DEFAULT (0) FOR [PGaiEkiTa], CONSTRAINT [DF_ctpTReport_PGaiSonHiyo] DEFAULT (0) FOR [PGaiSonHiyo], CONSTRAINT [DF_ctpTReport_PGaiSonKabu] DEFAULT (0) FOR [PGaiSonKabu], CONSTRAINT [DF_ctpTReport_PGaiSonTa] DEFAULT (0) FOR [PGaiSonTa], CONSTRAINT [DF_ctpTReport_PKeijoSonEki] DEFAULT (0) FOR [PKeijoSonEki], CONSTRAINT [DF_ctpTReport_PToukiSonEki] DEFAULT (0) FOR [PToukiSonEki], CONSTRAINT [DF_ctpTReport_PH] DEFAULT (0) FOR [PH], CONSTRAINT [DF_ctpTReport_PHKaihatuhi] DEFAULT (0) FOR [PHKaihatuhi], CONSTRAINT [DF_ctpTReport_PHUnchin] DEFAULT (0) FOR [PHUnchin], CONSTRAINT [DF_ctpTReport_PHSendenhi] DEFAULT (0) FOR [PHSendenhi], CONSTRAINT [DF_ctpTReport_PHJinkenhi] DEFAULT (0) FOR [PHJinkenhi], CONSTRAINT [DF_ctpTReport_PHHpkanrihi] DEFAULT (0) FOR [PHHpkanrihi], CONSTRAINT [DF_ctpTReport_PHYachin] DEFAULT (0) FOR [PHYachin], CONSTRAINT [DF_ctpTReport_PHTesuryo] DEFAULT (0) FOR [PHTesuryo], CONSTRAINT [DF_ctpTReport_PHSonota] DEFAULT (0) FOR [PHSonota], CONSTRAINT [DF_ctpTReport_PHTa1] DEFAULT (0) FOR [PHTa1], CONSTRAINT [DF_ctpTReport_PHTa2] DEFAULT (0) FOR [PHTa2], CONSTRAINT [DF_ctpTReport_OldFlag] DEFAULT (0) FOR [OldFlag], CONSTRAINT [PK_ctpTReport] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ReportDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpTownT] ADD CONSTRAINT [DF_ctpTownT_TownNo] DEFAULT (0) FOR [TownNo], CONSTRAINT [DF_ctpTownT_NumberOfShop] DEFAULT (0) FOR [NumberOfShop], CONSTRAINT [PK_ctpTownT] PRIMARY KEY CLUSTERED ( [PracticeCode], [TownNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctpTradeTrn] ADD CONSTRAINT [DF_ctpTradeTrn_APrivateCode] DEFAULT ('') FOR [APrivateCode], CONSTRAINT [DF_ctpTradeTrn_ACompanyCode] DEFAULT ('') FOR [ACompanyCode], CONSTRAINT [DF_ctpTradeTrn_ATenantCode] DEFAULT ('') FOR [ATenantCode], CONSTRAINT [DF_ctpTradeTrn_ActNo] DEFAULT (0) FOR [ActNo], CONSTRAINT [DF_ctpTradeTrn_OrderNo] DEFAULT (0) FOR [OrderNo], CONSTRAINT [DF_ctpTradeTrn_OrderSeq] DEFAULT (0) FOR [OrderSeq], CONSTRAINT [DF_ctpTradeTrn_BPrivateCode] DEFAULT ('') FOR [BPrivateCode], CONSTRAINT [DF_ctpTradeTrn_BCompanyCode] DEFAULT ('') FOR [BCompanyCode], CONSTRAINT [DF_ctpTradeTrn_BTenantCode] DEFAULT ('') FOR [BTenantCode], CONSTRAINT [DF_ctpTradeTrn_PaymentTerm] DEFAULT (0) FOR [PaymentTerm], CONSTRAINT [DF_ctpTradeTrn_TransportFlag] DEFAULT (0) FOR [TransportFlag], CONSTRAINT [DF_ctpTradeTrn_SellsDiscFlag] DEFAULT (0) FOR [SellsDiscFlag], CONSTRAINT [DF_ctpTradeTrn_COfficeAssetsFlag] DEFAULT (0) FOR [COfficeAssetsFlag], CONSTRAINT [DF_ctpTradeTrn_Qty] DEFAULT (0) FOR [Qty], CONSTRAINT [DF_ctpTradeTrn_StandardPrice] DEFAULT (0) FOR [StandardPrice], CONSTRAINT [DF_ctpTradeTrn_MakesPrice] DEFAULT (0) FOR [MakesPrice], CONSTRAINT [DF_ctpTradeTrn_StockPrice] DEFAULT (0) FOR [StockPrice], CONSTRAINT [DF_ctpTradeTrn_SellsPrice] DEFAULT (0) FOR [SellsPrice], CONSTRAINT [DF_ctpTradeTrn_TransportPrice] DEFAULT (0) FOR [TransportPrice], CONSTRAINT [DF_ctpTradeTrn_ConsumptionTax] DEFAULT (0) FOR [ConsumptionTax], CONSTRAINT [DF_ctpTradeTrn_CCreditRate] DEFAULT (0) FOR [CCreditRate], CONSTRAINT [DF_ctpTradeTrn_MakesAmnt] DEFAULT (0) FOR [MakesAmnt], CONSTRAINT [DF_ctpTradeTrn_StockAmnt] DEFAULT (0) FOR [StockAmnt], CONSTRAINT [DF_ctpTradeTrn_SellsAmnt] DEFAULT (0) FOR [SellsAmnt], CONSTRAINT [DF_ctpTradeTrn_TaxAmnt] DEFAULT (0) FOR [TaxAmnt], CONSTRAINT [DF_ctpTradeTrn_TransportAmnt] DEFAULT (0) FOR [TransportAmnt], CONSTRAINT [DF_ctpTradeTrn_TransportTax] DEFAULT (0) FOR [TransportTax], CONSTRAINT [DF_ctpTradeTrn_CreditAmnt] DEFAULT (0) FOR [CreditAmnt], CONSTRAINT [DF_ctpTradeTrn_AAmnt] DEFAULT (0) FOR [AAmnt], CONSTRAINT [DF_ctpTradeTrn_BAmnt] DEFAULT (0) FOR [BAmnt], CONSTRAINT [PK_ctpTradeTrn] PRIMARY KEY CLUSTERED ( [PracticeCode], [APrivateCode], [ACompanyCode], [ATenantCode], [TradeCode], [OrderNo], [OrderSeq], [AddDate] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctsCodeTC] ADD CONSTRAINT [DF_ctsCodeTC_AMF] DEFAULT (0) FOR [AMF], CONSTRAINT [DF_ctsCodeTC_BMF] DEFAULT (0) FOR [BMF] GO ALTER TABLE [dbo].[ctsCodeTS] ADD CONSTRAINT [DF_ctsCodeTS_UnusedFlag] DEFAULT (0) FOR [UnusedFlag], CONSTRAINT [DF_ctsCodeTS_gifSizeW] DEFAULT (0) FOR [gifSizeW], CONSTRAINT [DF_ctsCodeTS_gifSizeH] DEFAULT (0) FOR [gifSizeH], CONSTRAINT [PK_ctsCodeTS] PRIMARY KEY CLUSTERED ( [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctsCodeTSgif] ADD CONSTRAINT [DF_ctsCodeTSgif_SallFlag] DEFAULT (0) FOR [SallFlag], CONSTRAINT [DF_ctsCodeTSgif_SPracticeCode] DEFAULT ('') FOR [SPracticeCode], CONSTRAINT [DF_ctsCodeTSgif_SPrivateCode] DEFAULT ('') FOR [SPrivateCode], CONSTRAINT [DF_ctsCodeTSgif_SCompanyCode] DEFAULT ('') FOR [SCompanyCode], CONSTRAINT [DF_ctsCodeTSgif_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_ctsCodeTSgif] PRIMARY KEY CLUSTERED ( [IdentKey], [IdentName], [SPracticeCode], [SPrivateCode], [SCompanyCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctsCodeTU] ADD CONSTRAINT [PK_ctsCodeTU] PRIMARY KEY CLUSTERED ( [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctsCodeTUprcItem] ADD CONSTRAINT [PK_ctsCodeTUprcItem] PRIMARY KEY CLUSTERED ( [PracticeCode], [DataIdent], [IdentKey] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctsSystemF] ADD CONSTRAINT [PK_ctsSystemF] PRIMARY KEY CLUSTERED ( [UserCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cttStockM] ADD CONSTRAINT [DF_cttStockM_DealingUnit] DEFAULT (0) FOR [DealingUnit], CONSTRAINT [DF_cttStockM_FaceValue] DEFAULT (0) FOR [FaceValue], CONSTRAINT [DF_cttStockM_StartPrice] DEFAULT (0) FOR [StartPrice], CONSTRAINT [DF_cttStockM_HighPrice] DEFAULT (0) FOR [HighPrice], CONSTRAINT [DF_cttStockM_LowPrice] DEFAULT (0) FOR [LowPrice], CONSTRAINT [DF_cttStockM_EndPrice] DEFAULT (0) FOR [EndPrice], CONSTRAINT [DF_cttStockM_MoveValue] DEFAULT (0) FOR [MoveValue], CONSTRAINT [DF_cttStockM_TradeQty] DEFAULT (0) FOR [TradeQty], CONSTRAINT [DF_cttStockM_UpperLimitRate] DEFAULT (0) FOR [UpperLimitRate], CONSTRAINT [DF_cttStockM_LowerLimitRate] DEFAULT (0) FOR [LowerLimitRate], CONSTRAINT [PK_cttStockM] PRIMARY KEY CLUSTERED ( [PracticeCode], [StockCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cttTradeMemberM] ADD CONSTRAINT [DF_cttTradeMemberM_UserType] DEFAULT (0) FOR [UserType], CONSTRAINT [PK_cttTradeMemberM] PRIMARY KEY CLUSTERED ( [PracticeCode], [UserType], [AccountNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctxGroupM] ADD CONSTRAINT [DF_ctxGroupM_GroupSeq] DEFAULT (0) FOR [GroupSeq], CONSTRAINT [DF_ctxGroupM_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_ctxGroupM] PRIMARY KEY CLUSTERED ( [GroupCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ctxLoginF] ADD CONSTRAINT [DF_ctxLoginF_LoginFlag] DEFAULT (0) FOR [LoginFlag], CONSTRAINT [DF_ctxLoginF_LoginError] DEFAULT (0) FOR [LoginError], CONSTRAINT [DF_ctxLoginF_DefaultFlag] DEFAULT (0) FOR [DefaultFlag], CONSTRAINT [PK_ctxLoginF] PRIMARY KEY CLUSTERED ( [LoginId] ) ON [PRIMARY] GO