123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103 |
- USE [MainDB]
- GO
- /****** Object: Table [dbo].[Sales_Factor] Script Date: 2018/12/13 18:16:11 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Sales_Factor](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [YearMonth] [int] NOT NULL,
- [Factor_1] [int] NOT NULL,
- [Factor_2] [int] NOT NULL,
- [Factor_3] [int] NOT NULL,
- [Factor_4] [int] NOT NULL,
- [Factor_5] [int] NOT NULL,
- CONSTRAINT [PK_Sales_Factor] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[Sales_factor_farmer] Script Date: 2018/12/13 18:16:11 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Sales_factor_farmer](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [YearMonth] [int] NOT NULL,
- [factor_1] [int] NOT NULL,
- [factor_2] [int] NOT NULL,
- [factor_3] [int] NOT NULL,
- [factor_4] [int] NOT NULL,
- [factor_5] [int] NOT NULL,
- [factor_6] [int] NOT NULL,
- [factor_7] [int] NOT NULL,
- [factor_chuzhi] [int] NOT NULL,
- CONSTRAINT [PK_Sales_factor_farmer] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[sales_ManagerUser_Month] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[sales_ManagerUser_Month](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [YearMonth] [int] NOT NULL,
- [ManagerUserId] [smallint] NOT NULL,
- [Obj_Sales] [int] NULL,
- [Real_Sales] [int] NULL,
- [DescrIption] [nvarchar](2000) NULL,
- CONSTRAINT [PK_sales_ManagerUser_Month] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers],
- CONSTRAINT [IX_sales_ManagerUser_Month_unique] UNIQUE NONCLUSTERED
- (
- [YearMonth] ASC,
- [ManagerUserId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Index]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[sales_workDate] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[sales_workDate](
- [workDate] [int] NOT NULL,
- [status] [smallint] NOT NULL,
- CONSTRAINT [PK_sales_workDate] PRIMARY KEY CLUSTERED
- (
- [workDate] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[schMailPrev] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[schMailPrev](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [MailType] [tinyint] NOT NULL,
- [dcProvinceID] [smallint] NOT NULL,
- [AccountID] [int] NOT NULL,
- [AccountName] [varchar](100) NOT NULL,
- [UserName] [varchar](50) NOT NULL,
- [SubID] [int] NULL,
- [Title] [varchar](200) NOT NULL,
- [EmailNumber] [tinyint] NOT NULL,
- [emailsite] [varchar](50) NOT NULL,
- [Email] [varchar](50) NOT NULL,
- [SubSiteName] [nvarchar](20) NOT NULL,
- [MailBody] [nvarchar](max) NULL,
- [HasSend] [bit] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [MaxAge] [int] NULL,
- [MinAge] [int] NULL,
- [dcJobTypeID] [smallint] NULL,
- [dcRegionID] [varchar](6) NULL,
- [JobName] [nvarchar](50) NULL,
- [RefreshDate] [datetime] NULL,
- CONSTRAINT [PK_schMailPrev] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[schMailPrev3] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[schMailPrev3](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [MailType] [tinyint] NOT NULL,
- [dcProvinceID] [smallint] NOT NULL,
- [AccountID] [int] NOT NULL,
- [AccountName] [varchar](100) NOT NULL,
- [UserName] [varchar](50) NOT NULL,
- [SubID] [int] NULL,
- [Title] [varchar](200) NOT NULL,
- [EmailNumber] [tinyint] NOT NULL,
- [emailsite] [varchar](50) NOT NULL,
- [Email] [varchar](50) NOT NULL,
- [SubSiteName] [nvarchar](20) NOT NULL,
- [MailBody] [nvarchar](max) NULL,
- [HasSend] [bit] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [MaxAge] [int] NULL,
- [MinAge] [int] NULL,
- [dcJobTypeID] [smallint] NULL,
- [dcRegionID] [varchar](6) NULL,
- [JobName] [nvarchar](50) NULL,
- [RefreshDate] [datetime] NULL
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[schMailPrevJobResume] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[schMailPrevJobResume](
- [schMailPrevId] [int] NOT NULL,
- [ResumeId] [int] NOT NULL,
- [JobId] [int] NOT NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SearchCountLog] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchCountLog](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [SearchCount] [int] NULL,
- [AddDate] [smalldatetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SearchIp] Script Date: 2018/12/13 18:16:12 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchIp](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [Ip] [varchar](50) NULL,
- [Source] [varchar](10) NULL,
- [AddDate] [datetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SearchJobRefresh] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchJobRefresh](
- [CpMainID] [int] NOT NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SearchJobTop] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchJobTop](
- [CpMainID] [int] NOT NULL,
- [JobID] [int] NOT NULL,
- [OpenDate] [datetime] NULL,
- [OrderType] [tinyint] NULL,
- [JobName] [nvarchar](50) NULL,
- CONSTRAINT [PK_SearchJobTop] PRIMARY KEY CLUSTERED
- (
- [JobID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[searchkeywords] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[searchkeywords](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [keywords] [nvarchar](20) NOT NULL,
- [province_Id] [int] NOT NULL,
- [power] [smallint] NOT NULL,
- [Competition] [smalldatetime] NULL,
- [tuneDate] [smalldatetime] NULL,
- [version_Id] [int] NOT NULL,
- [CompetitionPrice] [numeric](5, 2) NULL,
- [Competition_sogou] [smalldatetime] NULL,
- [Competition_soso] [smalldatetime] NULL,
- [CompetitionPrice_sogou] [numeric](5, 2) NULL,
- [CompetitionPrice_soso] [numeric](5, 2) NULL,
- CONSTRAINT [PK_searchkeywords] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[SearchKeywordsPower] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchKeywordsPower](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [searchkeywords_Id] [int] NOT NULL,
- [YearMonthDay] [int] NOT NULL,
- [power] [smallint] NULL,
- [engine] [varchar](50) NOT NULL,
- [addDate] [smalldatetime] NULL,
- [Ip] [varchar](20) NULL,
- [cookies] [varchar](50) NULL,
- CONSTRAINT [PK_SearchKeywordsPower] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[SearchKeywordsPower0520] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SearchKeywordsPower0520](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [searchkeywords_Id] [int] NOT NULL,
- [YearMonthDay] [int] NOT NULL,
- [power] [smallint] NULL,
- [engine] [varchar](50) NOT NULL,
- [addDate] [smalldatetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SeatStatus] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SeatStatus](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [StatusType] [varchar](20) NULL,
- [state] [tinyint] NULL,
- [Agent] [varchar](50) NULL,
- [Statustime] [datetime] NULL,
- [Exten] [varchar](10) NULL,
- [ExtenType] [varchar](10) NULL,
- [str] [varchar](200) NULL,
- [BusyType] [varchar](50) NULL,
- CONSTRAINT [PK_SeatStatus] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[SeatStatusCount] Script Date: 2018/12/13 18:16:13 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SeatStatusCount](
- [CountDate] [varchar](8) NOT NULL,
- [Exten] [varchar](10) NOT NULL,
- [PRestatus] [tinyint] NOT NULL,
- [PreTime] [datetime] NOT NULL,
- [LoginSeCond] [int] NOT NULL,
- [LogoutSeCond] [int] NOT NULL,
- [BusySeCond] [int] NOT NULL,
- [IdleSeCond] [int] NOT NULL,
- CONSTRAINT [PK_SeatStatusCount] PRIMARY KEY NONCLUSTERED
- (
- [CountDate] ASC,
- [Exten] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[Seconderer] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Seconderer](
- [Referer] [varchar](200) NULL,
- [VersionId] [int] NULL,
- [LoginDate] [smalldatetime] NOT NULL,
- [Ip] [varchar](15) NULL,
- [Keywords] [nvarchar](50) NULL,
- [Province_Id] [smallint] NULL,
- [SessionId] [varchar](30) NULL
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[Seconderer_Count] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Seconderer_Count](
- [CountDate] [int] NOT NULL,
- [Province_Id] [smallint] NOT NULL,
- [HowMany] [int] NOT NULL,
- [Referer] [varchar](200) NOT NULL,
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [VersionId] [int] NULL,
- CONSTRAINT [PK_seConderer_count] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[Seconderer_Count_Keywords] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Seconderer_Count_Keywords](
- [Referer_Count_Id] [int] NOT NULL,
- [Keywords] [nvarchar](50) NOT NULL,
- [HowMany] [smallint] NOT NULL
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[Seconderer_YearMonth] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Seconderer_YearMonth](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [YearMonth] [int] NOT NULL,
- [Item_Name] [varchar](50) NOT NULL,
- [Province_Id] [smallint] NULL,
- [HowMany] [int] NOT NULL,
- CONSTRAINT [PK_seConderer_YearMonth] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[Seconderer2] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Seconderer2](
- [Referer] [varchar](200) NULL,
- [VersionId] [int] NULL,
- [LoginDate] [smalldatetime] NOT NULL,
- [Ip] [varchar](15) NULL,
- [Keywords] [nvarchar](50) NULL,
- [Province_Id] [smallint] NULL,
- [SessionId] [varchar](30) NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SendResume_recruit] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SendResume_recruit](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [ResumeId] [int] NOT NULL,
- [RecruitId] [int] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_sendResume_recruit] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [FOthers]
- ) ON [FOthers]
- GO
- /****** Object: Table [dbo].[Servi_Account] Script Date: 2018/12/13 18:16:14 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Servi_Account](
- [RtxId] [int] NOT NULL,
- [Status] [tinyint] NOT NULL,
- [CompanyId] [int] NOT NULL,
- CONSTRAINT [PK_servi_account] PRIMARY KEY CLUSTERED
- (
- [RtxId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[servi_log] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[servi_log](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [ProcessId] [int] NOT NULL,
- [Sender] [tinyint] NOT NULL,
- [Message] [varchar](max) NOT NULL,
- [CrDate] [datetime] NOT NULL,
- CONSTRAINT [PK_servi_log] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers] TEXTIMAGE_ON [BOthers]
- GO
- /****** Object: Table [dbo].[servi_process] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[servi_process](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [RtxId] [int] NOT NULL,
- [VersionDomain] [varchar](30) NULL,
- [CompanyId] [int] NOT NULL,
- [Province_Id] [tinyint] NOT NULL,
- [Companyname] [nvarchar](50) NOT NULL,
- [Province] [nvarchar](10) NULL,
- [ValidDate] [varchar](30) NULL,
- [Balance] [varchar](20) NULL,
- [Channel] [varchar](50) NULL,
- [ManagerUserId] [varchar](10) NULL,
- [ManagerrtxId] [smallint] NULL,
- [Manager_User] [varchar](20) NULL,
- [StartDate] [smalldatetime] NOT NULL,
- [RefReshDate] [datetime] NOT NULL,
- [EndDate] [smalldatetime] NULL,
- [Lastrow] [int] NOT NULL,
- [Satisfaction] [tinyint] NOT NULL,
- [Remark] [nvarchar](500) NULL,
- [Idlecount] [smallint] NOT NULL,
- [IsActive] [bit] NULL,
- CONSTRAINT [PK_servi_summary] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[Servi_User] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Servi_User](
- [Id] [smallint] NOT NULL,
- [Name] [nvarchar](50) NOT NULL,
- [Name_Eng] [varchar](50) NOT NULL,
- [Superior] [smallint] NOT NULL,
- [DeptId] [smallint] NOT NULL,
- [DisplayNo] [tinyint] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [LetterNumber] [int] NULL,
- CONSTRAINT [PK_Servi_User] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[ServiceRunLog] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[ServiceRunLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [ServiceId] [tinyint] NOT NULL,
- [RunRows] [int] NULL,
- [RunId] [int] NULL,
- [ObjectNo] [varchar](50) NULL,
- [RunStatus] [int] NULL,
- [RunMessage] [nvarchar](200) NULL,
- [AddDate] [datetime] NULL,
- CONSTRAINT [PK_ServiceRunLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[smsBatchSend] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[smsBatchSend](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Mobile] [varchar](max) NULL,
- [Msg] [nvarchar](300) NULL,
- [SendDate] [datetime] NULL,
- [SendStatus] [int] NULL,
- [AddDate] [smalldatetime] NULL
- ) ON [BOthers] TEXTIMAGE_ON [BOthers]
- GO
- /****** Object: Table [dbo].[SmsMessageLog] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SmsMessageLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [SendMan] [smallint] NOT NULL,
- [ManagerUserId] [smallint] NULL,
- [paMainId] [int] NULL,
- [caMainId] [int] NULL,
- [Mobile] [varchar](20) NOT NULL,
- [Msg] [nvarchar](210) NOT NULL,
- [IsCat] [bit] NOT NULL,
- [AddDate] [datetime] NOT NULL,
- [PortNo] [tinyint] NULL,
- [SendDate] [datetime] NULL,
- [SendStatus] [int] NULL,
- [SmsType] [tinyint] NOT NULL,
- [MsgType] [tinyint] NOT NULL,
- CONSTRAINT [PK_SmsMessageLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[SmsWatch] Script Date: 2018/12/13 18:16:15 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SmsWatch](
- [ID] [int] NOT NULL,
- [CpMainID] [int] NULL,
- [CaMainID] [int] NULL,
- [SmsType] [tinyint] NULL,
- [Msg] [nvarchar](100) NULL,
- [Mobile] [varchar](11) NULL,
- [LastLoginTime] [int] NULL,
- [exMessageP2CCount] [int] NULL,
- [exInterviewCount] [int] NULL,
- [exJobApplyCount] [int] NULL,
- [cacvIntentionCount] [int] NULL,
- [LastDate] [datetime] NULL,
- [LastLoginDate] [smalldatetime] NULL,
- [IsSend] [bit] NULL,
- [WatchDate] [varchar](8) NOT NULL,
- [MsgType] [tinyint] NULL
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[SmsWatchLog] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SmsWatchLog](
- [WatchDate] [smalldatetime] NOT NULL,
- [SendDate] [varchar](10) NOT NULL,
- [LoginNumber] [int] NULL,
- [AllNumBer] [int] NULL,
- [LoginNumberSend] [int] NULL,
- [AllNumBerSend] [int] NULL,
- [LoginNumberNotSend] [int] NULL,
- [AllNumBerNotSend] [int] NULL,
- [MsgType] [tinyint] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SOLLog] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SOLLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [ProcessID] [int] NOT NULL,
- [Sender] [tinyint] NOT NULL,
- [IsViewed] [bit] NOT NULL,
- [Message] [varchar](5000) NULL,
- [AddDate] [datetime] NOT NULL,
- CONSTRAINT [PK_SOLLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SOLProcess] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SOLProcess](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [caMainID] [int] NOT NULL,
- [CompanyName] [nvarchar](50) NOT NULL,
- [caName] [nvarchar](6) NULL,
- [StartDate] [smalldatetime] NOT NULL,
- [EndDate] [smalldatetime] NULL,
- [IsActive] [bit] NOT NULL,
- [ManagerUserId] [smallint] NOT NULL,
- [Evaluate] [smallint] NULL,
- [Remark] [nvarchar](500) NULL,
- [OfflineType] [tinyint] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_SOLProcess] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[SOLService] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SOLService](
- [ID] [int] NOT NULL,
- [Name] [nvarchar](50) NOT NULL,
- [NameEng] [varchar](50) NOT NULL,
- [Superior] [smallint] NOT NULL,
- [DeptID] [smallint] NOT NULL,
- [DisplayNo] [tinyint] NOT NULL,
- [LetterNumber] [int] NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_SOLService] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Sow] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Sow](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [Title] [nvarchar](50) NOT NULL,
- [DescrIption] [nvarchar](1000) NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [ManagerUserId] [smallint] NOT NULL,
- [Attachment] [varchar](50) NULL,
- [Privi] [varchar](500) NULL,
- CONSTRAINT [PK_Sow] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[SpreadCallLog] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SpreadCallLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Filename] [varchar](100) NOT NULL,
- [FileMD5] [varchar](200) NOT NULL,
- [PhoneNo] [varchar](20) NOT NULL,
- [TimeLength] [smallint] NOT NULL,
- [AddMan] [smallint] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_SpreadCallLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Standard] Script Date: 2018/12/13 18:16:16 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Standard](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [Title] [nvarchar](50) NOT NULL,
- [DescrIption] [nvarchar](1000) NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [Type] [smallint] NOT NULL,
- [ManagerUserId] [smallint] NOT NULL,
- [Attachment] [varchar](50) NULL,
- [Privi] [varchar](500) NULL,
- CONSTRAINT [PK_Standard] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[SurName] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[SurName](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [surname] [nvarchar](10) NOT NULL,
- [name] [nvarchar](50) NULL,
- CONSTRAINT [PK_surname] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers],
- CONSTRAINT [IX_surname_surname] UNIQUE NONCLUSTERED
- (
- [surname] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Index]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[TableSpaceInfo] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[TableSpaceInfo](
- [NAMEINFO] [varchar](50) NULL,
- [ROWSINFO] [int] NULL,
- [RESERVED] [varchar](20) NULL,
- [DATAINFO] [varchar](20) NULL,
- [INDEX_SIZE] [varchar](20) NULL,
- [UNUSED] [varchar](20) NULL,
- [AddDate] [smalldatetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[telephonebill_Day] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[telephonebill_Day](
- [countDate] [int] NOT NULL,
- [ManagerUserId] [int] NOT NULL,
- [name] [nvarchar](50) NOT NULL,
- [telephone_num_all] [smallint] NOT NULL,
- [telephone_interval_all] [int] NOT NULL,
- [telephone_num_up60] [smallint] NOT NULL,
- [telephone_interval_up60] [int] NOT NULL,
- [status] [tinyint] NULL,
- CONSTRAINT [IX_telephonebill_Day_unique] UNIQUE NONCLUSTERED
- (
- [countDate] ASC,
- [ManagerUserId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Index]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[tmp_BlackWord] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmp_BlackWord](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [BlackWord] [nvarchar](50) NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmp_jobPublishLog] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmp_jobPublishLog](
- [id] [int] NULL,
- [cpMainId] [int] NULL,
- [InsertDate] [smalldatetime] NULL,
- [Deletedate] [smalldatetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Tmp_limitip] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Tmp_limitip](
- [LastLoginIp] [varchar](31) NULL,
- [Cnt] [int] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmp_limitip2] Script Date: 2018/12/13 18:16:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmp_limitip2](
- [ip] [varchar](31) NULL,
- [cnt] [int] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmp_limitmobile] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmp_limitmobile](
- [mobile] [varchar](20) NOT NULL,
- [cnt] [int] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmpPaBaiduJson] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmpPaBaiduJson](
- [paMainID] [int] NOT NULL,
- [Json] [varchar](max) NOT NULL,
- [Adddate] [smalldatetime] NOT NULL
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmpResume_Xinxi_Check] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmpResume_Xinxi_Check](
- [email] [varchar](50) NULL,
- [addman] [smallint] NULL,
- [province_id] [int] NULL,
- [regdate] [datetime] NULL,
- [paMainId] [int] NULL,
- [DeleteDate] [datetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tmpWsLog] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tmpWsLog](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [ip] [varchar](15) NULL,
- [pageID] [int] NULL,
- [AddDate] [datetime] NULL,
- [EndDate] [datetime] NULL,
- [para] [varchar](100) NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[ToolRunLog] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[ToolRunLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [ToolType] [tinyint] NOT NULL,
- [RunServer] [tinyint] NULL,
- [BeginTime] [datetime] NOT NULL,
- [EndTime] [datetime] NULL,
- [RunTime] [int] NULL,
- [RunStatus] [tinyint] NULL,
- [RunMessage] [varchar](200) NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_ToolRunLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[Topics] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Topics](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Title] [nvarchar](50) NOT NULL,
- [Description] [nvarchar](250) NOT NULL,
- [FileName] [varchar](50) NOT NULL,
- [Url] [varchar](100) NOT NULL,
- [type] [tinyint] NOT NULL,
- [EmailClick] [int] NOT NULL,
- [ClickNumber] [int] NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_Topics] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tpiCompany] Script Date: 2018/12/13 18:16:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tpiCompany](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [tpiListId] [int] NULL,
- [cpMainId] [int] NULL,
- [tpiCompanyId] [varchar](100) NULL,
- [Status] [tinyint] NULL,
- [AddDate] [datetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[tpiList] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[tpiList](
- [Id] [int] NULL,
- [ThirdPartyName] [nvarchar](100) NULL,
- [Programmer] [varchar](20) NULL,
- [AddDate] [datetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Url] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Url](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [DescrIption] [nvarchar](50) NULL,
- [url] [varchar](200) NOT NULL,
- [allclick] [int] NOT NULL,
- [toDayclick] [int] NOT NULL,
- [beginDate] [smalldatetime] NOT NULL,
- [province_Id] [int] NOT NULL,
- [Type] [tinyint] NULL,
- [allResume] [int] NOT NULL,
- [toDayResume] [int] NOT NULL,
- [allCompany] [int] NOT NULL,
- [toDayCompany] [int] NOT NULL,
- [status] [smallint] NOT NULL,
- [Ip_repeat] [smallint] NOT NULL,
- [yestoDayclick] [int] NULL,
- [yestoDayResume] [int] NULL,
- [yestoDayCompany] [int] NULL,
- [AddMan] [int] NULL,
- CONSTRAINT [PK_url] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[url_click_log] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[url_click_log](
- [url_Id] [int] NOT NULL,
- [Ip] [varchar](50) NOT NULL,
- [addDate] [smalldatetime] NOT NULL
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[url_Month] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[url_Month](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [url_Id] [int] NOT NULL,
- [Month] [int] NOT NULL,
- [click] [int] NOT NULL,
- [Resume] [int] NOT NULL,
- [Company] [int] NOT NULL,
- CONSTRAINT [PK_url_Month] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market],
- CONSTRAINT [IX_url_Month_weiyi] UNIQUE NONCLUSTERED
- (
- [Month] ASC,
- [url_Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Index]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[UrlAccount] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[UrlAccount](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [UrlID] [int] NOT NULL,
- [paMainID] [int] NULL,
- [cpMainID] [int] NULL,
- [AddDate] [smalldatetime] NOT NULL,
- CONSTRAINT [PK_UrlAccount] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[VersionPrLog] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[VersionPrLog](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [VersionId] [int] NOT NULL,
- [Pr] [tinyint] NOT NULL,
- [AddDate] [varchar](10) NOT NULL,
- CONSTRAINT [PK_VersionPrLog] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Market]
- ) ON [Market]
- GO
- /****** Object: Table [dbo].[Video] Script Date: 2018/12/13 18:16:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Video](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [CompanyId] [int] NOT NULL,
- [vIdeono] [char](10) NOT NULL,
- [seetime] [datetime] NOT NULL
- ) ON [FOthers]
- GO
- /****** Object: Table [dbo].[WapCounter] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WapCounter](
- [countDate] [int] NOT NULL,
- [versionId] [smallint] NOT NULL,
- [viewnumber] [int] NOT NULL,
- [spIderviewnumber] [int] NOT NULL,
- CONSTRAINT [IX_WapCounter_unique] UNIQUE CLUSTERED
- (
- [countDate] ASC,
- [versionId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [FOthers]
- ) ON [FOthers]
- GO
- /****** Object: Table [dbo].[WebSiteMonitor] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WebSiteMonitor](
- [ID] [smallint] NOT NULL,
- [SubSiteName] [varchar](50) NULL,
- [SubSiteUrl] [varchar](50) NULL,
- [Interval] [smallint] NULL,
- [LogTime] [datetime] NULL,
- [RtxNumber] [tinyint] NOT NULL,
- CONSTRAINT [PK_WebSiteMonitor] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WebSiteMonitorLog] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WebSiteMonitorLog](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [ProvinceID] [int] NOT NULL,
- [SiteStatus] [tinyint] NULL,
- [AddDate] [datetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WordList] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WordList](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [Word] [varchar](50) NULL,
- [WordType] [tinyint] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[workDate] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[workDate](
- [workDate] [int] NOT NULL,
- [Type] [smallint] NULL,
- [IsPaid] [bit] NOT NULL,
- CONSTRAINT [PK_workDate] PRIMARY KEY CLUSTERED
- (
- [workDate] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[workDate_province_ManagerUser] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[workDate_province_ManagerUser](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [WorkDate] [int] NOT NULL,
- [Province_Id] [tinyint] NOT NULL,
- [ManagerUser_Id] [smallint] NOT NULL,
- CONSTRAINT [PK_workDate_province_ManagerUser] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[WxAttention] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxAttention](
- [WxServiceNoID] [int] NULL,
- [OpenID] [varchar](100) NULL,
- [UpdateDate] [smalldatetime] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[wxChatOnlineTemp] Script Date: 2018/12/13 18:16:20 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[wxChatOnlineTemp](
- [ChatOnineId] [int] NULL,
- [paMainId] [int] NULL,
- [cvMainid] [int] NULL,
- [caMainId] [int] NULL,
- [IsSend] [bit] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxFans] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxFans](
- [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
- [OpenID] [varchar](50) NOT NULL,
- [PaMainID] [int] NULL,
- [AttentionDate] [smalldatetime] NULL,
- [AttentionCancelDate] [smalldatetime] NULL,
- [LastReceiveDate] [smalldatetime] NULL,
- [LastSendMessage] [varchar](500) NULL,
- [Status] [smallint] NULL,
- [WxServiceNoID] [int] NULL,
- [caMainId] [int] NULL,
- [caBindCancelDate] [smalldatetime] NULL,
- [unionid] [varchar](50) NULL,
- CONSTRAINT [PK_WxUser] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxMax] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxMax](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [TableName] [varchar](50) NULL,
- [MaxID] [varchar](50) NULL,
- [UpdateDate] [datetime] NULL,
- CONSTRAINT [PK_WxMax] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxMessageReceive] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxMessageReceive](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [WxFansID] [int] NOT NULL,
- [AddDate] [smalldatetime] NULL,
- [Message] [varchar](500) NULL,
- [LogType] [smallint] NULL,
- CONSTRAINT [PK_WxUserLog] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxMessageSend] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxMessageSend](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [WxFansID] [int] NOT NULL,
- [Message] [varchar](1000) NULL,
- [SendDate] [smalldatetime] NULL,
- [Status] [smallint] NULL,
- [MessageType] [smallint] NULL,
- [WxTemplatenoID] [int] NULL,
- [Remark] [nvarchar](200) NULL,
- [CpMainID] [int] NULL,
- [AddDate] [smalldatetime] NULL,
- CONSTRAINT [PK_WxMessageSend] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WXQrImage] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WXQrImage](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Ticket] [varchar](150) NOT NULL,
- [PageType] [tinyint] NOT NULL,
- [Status] [tinyint] NOT NULL,
- [AddDate] [datetime] NOT NULL,
- [paMainId] [int] NULL,
- [ip] [varchar](31) NULL,
- [OpenID] [varchar](100) NULL,
- CONSTRAINT [PK__WXScene__3CAC54C0] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CP]
- ) ON [CP]
- GO
- /****** Object: Table [dbo].[WxServiceNo] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxServiceNo](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Name] [varchar](50) NOT NULL,
- [AppID] [varchar](50) NOT NULL,
- [AppSecret] [varchar](100) NULL,
- [UserName] [varchar](50) NOT NULL,
- [Password] [varchar](50) NOT NULL,
- [ProvinceID] [int] NOT NULL,
- [AddDate] [smalldatetime] NULL,
- [Status] [smallint] NULL,
- CONSTRAINT [PK_WxServiceNo] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[wxSmallPrograminfo] Script Date: 2018/12/13 18:16:21 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[wxSmallPrograminfo](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [thirdSessionId] [varchar](200) NOT NULL,
- [openId] [varchar](50) NULL,
- [sessionId] [varchar](50) NOT NULL,
- [unionId] [varchar](50) NULL,
- [addDate] [smalldatetime] NULL,
- [pamainid] [int] NULL
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxTemplate] Script Date: 2018/12/13 18:16:22 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxTemplate](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [Title] [varchar](50) NULL,
- [TemplateTitle] [varchar](50) NOT NULL,
- [Detail] [varchar](1000) NOT NULL,
- [Url] [varchar](200) NULL,
- [Type] [smallint] NULL,
- [Remark] [nvarchar](500) NULL,
- [AddDate] [smalldatetime] NULL,
- [Status] [smallint] NULL,
- CONSTRAINT [PK_WxTemplate] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxTemplateNo] Script Date: 2018/12/13 18:16:22 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxTemplateNo](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [No] [varchar](100) NOT NULL,
- [WxTemplateId] [int] NOT NULL,
- [WxServiceNoID] [int] NOT NULL,
- CONSTRAINT [PK_WxTemplateNo] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[WxTemplatePara] Script Date: 2018/12/13 18:16:22 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[WxTemplatePara](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [WxTemplateID] [int] NOT NULL,
- [ParaName] [varchar](50) NOT NULL,
- [ParaValue] [varchar](500) NULL,
- [ParaColor] [varchar](50) NULL,
- CONSTRAINT [PK_WxTemplatePara] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[yingyelog] Script Date: 2018/12/13 18:16:22 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[yingyelog](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [ManagerUserId] [smallint] NOT NULL,
- [countDate] [int] NOT NULL,
- [province_Id] [tinyint] NOT NULL,
- [faxpassed] [int] NOT NULL,
- [faxnotpassed] [int] NOT NULL,
- [uploadpassed] [int] NOT NULL,
- [uploadnotpassed] [int] NOT NULL,
- [transferpassed] [int] NOT NULL,
- [transfernotpassed] [int] NOT NULL,
- CONSTRAINT [PK_yingyelog] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [BOthers]
- ) ON [BOthers]
- GO
- /****** Object: Table [dbo].[ZmxyTransaction] Script Date: 2018/12/13 18:16:22 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[ZmxyTransaction](
- [ID] [varchar](32) NOT NULL,
- [AddDate] [smalldatetime] NOT NULL,
- [cpMainID] [int] NULL,
- [cpCertificationID] [int] NULL,
- CONSTRAINT [PK_ZmxyTransaction] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Sales_Factor] ADD CONSTRAINT [DF_Sales_Factor_Factor_1] DEFAULT ((0)) FOR [Factor_1]
- GO
- ALTER TABLE [dbo].[Sales_Factor] ADD CONSTRAINT [DF_Sales_Factor_Factor_2] DEFAULT ((0)) FOR [Factor_2]
- GO
- ALTER TABLE [dbo].[Sales_Factor] ADD CONSTRAINT [DF_Sales_Factor_Factor_3] DEFAULT ((0)) FOR [Factor_3]
- GO
- ALTER TABLE [dbo].[Sales_Factor] ADD CONSTRAINT [DF_Sales_Factor_Factor_4] DEFAULT ((0)) FOR [Factor_4]
- GO
- ALTER TABLE [dbo].[Sales_Factor] ADD CONSTRAINT [DF_Sales_Factor_Factor_5] DEFAULT ((0)) FOR [Factor_5]
- GO
- ALTER TABLE [dbo].[schMailPrev] ADD CONSTRAINT [DF_schMailPrev_HasSend] DEFAULT ((0)) FOR [HasSend]
- GO
- ALTER TABLE [dbo].[schMailPrev] ADD CONSTRAINT [DF_schMailPrev_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SearchIp] ADD DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SearchKeywordsPower] ADD CONSTRAINT [DF_SearchKeywordsPower_addDate] DEFAULT (getdate()) FOR [addDate]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_CountDate] DEFAULT (CONVERT([varchar](8),getdate(),(112))) FOR [CountDate]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_PRestatus] DEFAULT ((0)) FOR [PRestatus]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_PreTime] DEFAULT (getdate()) FOR [PreTime]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_LoginSeCond] DEFAULT ((0)) FOR [LoginSeCond]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_LogoutSeCond] DEFAULT ((0)) FOR [LogoutSeCond]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_BusySeCond] DEFAULT ((0)) FOR [BusySeCond]
- GO
- ALTER TABLE [dbo].[SeatStatusCount] ADD CONSTRAINT [DF_SeatStatusCount_IdleSeCond] DEFAULT ((0)) FOR [IdleSeCond]
- GO
- ALTER TABLE [dbo].[Seconderer] ADD CONSTRAINT [DF_seCondere_loginDate] DEFAULT (getdate()) FOR [LoginDate]
- GO
- ALTER TABLE [dbo].[SendResume_recruit] ADD CONSTRAINT [DF_sendResume_recruit_addDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Servi_Account] ADD CONSTRAINT [DF_servi_account_CompanyId] DEFAULT ((0)) FOR [CompanyId]
- GO
- ALTER TABLE [dbo].[servi_log] ADD CONSTRAINT [DF_servi_log_crDate] DEFAULT (getdate()) FOR [CrDate]
- GO
- ALTER TABLE [dbo].[servi_process] ADD CONSTRAINT [DF_servi_summary_startDate] DEFAULT (getdate()) FOR [StartDate]
- GO
- ALTER TABLE [dbo].[servi_process] ADD CONSTRAINT [DF_servi_process_refReshDate] DEFAULT (getdate()) FOR [RefReshDate]
- GO
- ALTER TABLE [dbo].[servi_process] ADD CONSTRAINT [DF_servi_process_lastrow] DEFAULT ((0)) FOR [Lastrow]
- GO
- ALTER TABLE [dbo].[servi_process] ADD CONSTRAINT [DF_servi_summary_Satisfaction] DEFAULT ((0)) FOR [Satisfaction]
- GO
- ALTER TABLE [dbo].[servi_process] ADD CONSTRAINT [DF_servi_process_Idlecount] DEFAULT ((0)) FOR [Idlecount]
- GO
- ALTER TABLE [dbo].[servi_process] ADD DEFAULT ((0)) FOR [IsActive]
- GO
- ALTER TABLE [dbo].[Servi_User] ADD CONSTRAINT [DF_Servi_User_DisplayNo] DEFAULT ((0)) FOR [DisplayNo]
- GO
- ALTER TABLE [dbo].[Servi_User] ADD CONSTRAINT [DF_Servi_User_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[ServiceRunLog] ADD CONSTRAINT [DF_ServiceRunLog_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[smsBatchSend] ADD DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SmsMessageLog] ADD CONSTRAINT [DF_SmsCat_IsCat] DEFAULT ((0)) FOR [IsCat]
- GO
- ALTER TABLE [dbo].[SmsMessageLog] ADD CONSTRAINT [DF_SmsCat_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SmsMessageLog] ADD CONSTRAINT [DF_SmsCat_SmsType] DEFAULT ((1)) FOR [SmsType]
- GO
- ALTER TABLE [dbo].[SmsMessageLog] ADD CONSTRAINT [DF_SmsCat_MsgType] DEFAULT ((1)) FOR [MsgType]
- GO
- ALTER TABLE [dbo].[SmsWatchLog] ADD CONSTRAINT [DF_SmsWatchLog_WatchDate] DEFAULT (getdate()) FOR [WatchDate]
- GO
- ALTER TABLE [dbo].[SOLLog] ADD CONSTRAINT [DF_SOLLog_IsViewed] DEFAULT ((1)) FOR [IsViewed]
- GO
- ALTER TABLE [dbo].[SOLLog] ADD CONSTRAINT [DF_SOLLog_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SOLProcess] ADD CONSTRAINT [DF_SOLProcess_StartDate] DEFAULT (getdate()) FOR [StartDate]
- GO
- ALTER TABLE [dbo].[SOLProcess] ADD CONSTRAINT [DF_SOLProcess_IsActive] DEFAULT ((1)) FOR [IsActive]
- GO
- ALTER TABLE [dbo].[SOLProcess] ADD CONSTRAINT [DF_SOLProcess_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[SOLService] ADD CONSTRAINT [DF_SOLService_DisplayNo] DEFAULT ((0)) FOR [DisplayNo]
- GO
- ALTER TABLE [dbo].[SOLService] ADD CONSTRAINT [DF_SOLService_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Sow] ADD CONSTRAINT [DF_Sow_addDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Standard] ADD CONSTRAINT [DF_Standard_addDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[TableSpaceInfo] ADD CONSTRAINT [DF_TableSpaceInfo_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[tmpPaBaiduJson] ADD CONSTRAINT [DF_tmpPaBaiduJson_Adddate] DEFAULT (getdate()) FOR [Adddate]
- GO
- ALTER TABLE [dbo].[tmpWsLog] ADD DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[ToolRunLog] ADD CONSTRAINT [DF_ToolRunLog_RunServer] DEFAULT ((1)) FOR [RunServer]
- GO
- ALTER TABLE [dbo].[ToolRunLog] ADD CONSTRAINT [DF_ToolRunLog_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Topics] ADD CONSTRAINT [DF_Topics_type] DEFAULT ((1)) FOR [type]
- GO
- ALTER TABLE [dbo].[Topics] ADD CONSTRAINT [DF_Topics_EmailClick] DEFAULT ((0)) FOR [EmailClick]
- GO
- ALTER TABLE [dbo].[Topics] ADD CONSTRAINT [DF_Topics_ClickNumber] DEFAULT ((0)) FOR [ClickNumber]
- GO
- ALTER TABLE [dbo].[Topics] ADD CONSTRAINT [DF_Topics_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_allclick] DEFAULT ((0)) FOR [allclick]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_toDayclick] DEFAULT ((0)) FOR [toDayclick]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_beginDate] DEFAULT (getdate()) FOR [beginDate]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_allResume] DEFAULT ((0)) FOR [allResume]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_toDayResume] DEFAULT ((0)) FOR [toDayResume]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_allCompany] DEFAULT ((0)) FOR [allCompany]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_toDayCompany] DEFAULT ((0)) FOR [toDayCompany]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_status] DEFAULT ((1)) FOR [status]
- GO
- ALTER TABLE [dbo].[Url] ADD CONSTRAINT [DF_url_Ip_repeat] DEFAULT ((1)) FOR [Ip_repeat]
- GO
- ALTER TABLE [dbo].[url_click_log] ADD CONSTRAINT [DF_url_click_log_Ip] DEFAULT (getdate()) FOR [Ip]
- GO
- ALTER TABLE [dbo].[url_click_log] ADD CONSTRAINT [DF_url_click_log_addDate] DEFAULT (getdate()) FOR [addDate]
- GO
- ALTER TABLE [dbo].[UrlAccount] ADD CONSTRAINT [DF_UrlAccount_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[VersionPrLog] ADD CONSTRAINT [DF_VersionPrLog_AddDate] DEFAULT (CONVERT([varchar](10),getdate(),(120))) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[Video] ADD CONSTRAINT [DF_vIdeo_seetime] DEFAULT (getdate()) FOR [seetime]
- GO
- ALTER TABLE [dbo].[WapCounter] ADD CONSTRAINT [DF_WapCounter_viewnumber] DEFAULT ((0)) FOR [viewnumber]
- GO
- ALTER TABLE [dbo].[WapCounter] ADD CONSTRAINT [DF_WapCounter_spIderviewnumber] DEFAULT ((0)) FOR [spIderviewnumber]
- GO
- ALTER TABLE [dbo].[workDate] ADD CONSTRAINT [DF_workDate_IsPaid] DEFAULT ((0)) FOR [IsPaid]
- GO
- ALTER TABLE [dbo].[wxChatOnlineTemp] ADD DEFAULT ((0)) FOR [IsSend]
- GO
- ALTER TABLE [dbo].[WXQrImage] ADD CONSTRAINT [DF_WXQrImage_PageType] DEFAULT ((1)) FOR [PageType]
- GO
- ALTER TABLE [dbo].[WXQrImage] ADD CONSTRAINT [DF_WXQrImage_Status] DEFAULT ((0)) FOR [Status]
- GO
- ALTER TABLE [dbo].[WXQrImage] ADD CONSTRAINT [DF_WXQrImage_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_faxpassed] DEFAULT ((0)) FOR [faxpassed]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_faxnotpassed] DEFAULT ((0)) FOR [faxnotpassed]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_uploadpassed] DEFAULT ((0)) FOR [uploadpassed]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_uploadnotpassed] DEFAULT ((0)) FOR [uploadnotpassed]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_transferpassed] DEFAULT ((0)) FOR [transferpassed]
- GO
- ALTER TABLE [dbo].[yingyelog] ADD CONSTRAINT [DF_yingyelog_transfernotpassed] DEFAULT ((0)) FOR [transfernotpassed]
- GO
- ALTER TABLE [dbo].[ZmxyTransaction] ADD CONSTRAINT [DF_ZmxyTransaction_AddDate] DEFAULT (getdate()) FOR [AddDate]
- GO
- ALTER TABLE [dbo].[sales_ManagerUser_Month] WITH CHECK ADD CONSTRAINT [FK_sales_ManagerUser_Month_ManagerUser] FOREIGN KEY([ManagerUserId])
- REFERENCES [dbo].[ManagerUser] ([id])
- GO
- ALTER TABLE [dbo].[sales_ManagerUser_Month] CHECK CONSTRAINT [FK_sales_ManagerUser_Month_ManagerUser]
- GO
- ALTER TABLE [dbo].[SearchKeywordsPower] WITH CHECK ADD CONSTRAINT [FK_SearchKeywordsPower_searchkeywords] FOREIGN KEY([searchkeywords_Id])
- REFERENCES [dbo].[searchkeywords] ([Id])
- ON DELETE CASCADE
- GO
- ALTER TABLE [dbo].[SearchKeywordsPower] CHECK CONSTRAINT [FK_SearchKeywordsPower_searchkeywords]
- GO
- ALTER TABLE [dbo].[servi_log] WITH CHECK ADD CONSTRAINT [FK_servi_log_servi_process] FOREIGN KEY([ProcessId])
- REFERENCES [dbo].[servi_process] ([Id])
- GO
- ALTER TABLE [dbo].[servi_log] CHECK CONSTRAINT [FK_servi_log_servi_process]
- GO
- ALTER TABLE [dbo].[servi_process] WITH CHECK ADD CONSTRAINT [FK_servi_process_servi_account] FOREIGN KEY([RtxId])
- REFERENCES [dbo].[Servi_Account] ([RtxId])
- GO
- ALTER TABLE [dbo].[servi_process] CHECK CONSTRAINT [FK_servi_process_servi_account]
- GO
- ALTER TABLE [dbo].[Sow] WITH CHECK ADD CONSTRAINT [FK_Sow_ManagerUser] FOREIGN KEY([ManagerUserId])
- REFERENCES [dbo].[ManagerUser] ([id])
- GO
- ALTER TABLE [dbo].[Sow] CHECK CONSTRAINT [FK_Sow_ManagerUser]
- GO
- ALTER TABLE [dbo].[Standard] WITH CHECK ADD CONSTRAINT [FK_Standard_ManagerUser] FOREIGN KEY([ManagerUserId])
- REFERENCES [dbo].[ManagerUser] ([id])
- GO
- ALTER TABLE [dbo].[Standard] CHECK CONSTRAINT [FK_Standard_ManagerUser]
- GO
- ALTER TABLE [dbo].[url_click_log] WITH CHECK ADD CONSTRAINT [FK_url_click_log_url] FOREIGN KEY([url_Id])
- REFERENCES [dbo].[Url] ([Id])
- ON DELETE CASCADE
- GO
- ALTER TABLE [dbo].[url_click_log] CHECK CONSTRAINT [FK_url_click_log_url]
- GO
- ALTER TABLE [dbo].[url_Month] WITH CHECK ADD CONSTRAINT [FK_url_Month_url] FOREIGN KEY([url_Id])
- REFERENCES [dbo].[Url] ([Id])
- ON DELETE CASCADE
- GO
- ALTER TABLE [dbo].[url_Month] CHECK CONSTRAINT [FK_url_Month_url]
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] WITH CHECK ADD CONSTRAINT [FK_workDate_province_manageruser_dcProvince] FOREIGN KEY([Province_Id])
- REFERENCES [dbo].[dcProvince] ([ID])
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] CHECK CONSTRAINT [FK_workDate_province_manageruser_dcProvince]
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] WITH CHECK ADD CONSTRAINT [FK_workDate_province_ManagerUser_manageruser] FOREIGN KEY([ManagerUser_Id])
- REFERENCES [dbo].[ManagerUser] ([id])
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] CHECK CONSTRAINT [FK_workDate_province_ManagerUser_manageruser]
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] WITH CHECK ADD CONSTRAINT [FK_workDate_province_ManagerUser_workDate_province_ManagerUser_workDate] FOREIGN KEY([WorkDate])
- REFERENCES [dbo].[workDate] ([workDate])
- GO
- ALTER TABLE [dbo].[workDate_province_ManagerUser] CHECK CONSTRAINT [FK_workDate_province_ManagerUser_workDate_province_ManagerUser_workDate]
- GO
- ALTER TABLE [dbo].[yingyelog] WITH CHECK ADD CONSTRAINT [FK_yingyelog_ManagerUser] FOREIGN KEY([ManagerUserId])
- REFERENCES [dbo].[ManagerUser] ([id])
- GO
- ALTER TABLE [dbo].[yingyelog] CHECK CONSTRAINT [FK_yingyelog_ManagerUser]
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1:职位订阅简历;2:个人搜索器订阅职位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'schMailPrev', @level2type=N'COLUMN',@level2name=N'MailType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MailType=1为cpMainID;MailType=2为paMainID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'schMailPrev', @level2type=N'COLUMN',@level2name=N'AccountID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MailType=1时为JobID,MailType=2时为paSearchID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'schMailPrev', @level2type=N'COLUMN',@level2name=N'SubID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位刷新表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchJobRefresh'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位置顶表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchJobTop'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0系统发送;否则是工号;如果是收到的企业短信,则是招聘顾问编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'SendMan'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收信人的工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'ManagerUserId'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收短信的求职者账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'paMainId'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收短信的企业用户帐号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'caMainId'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收短信的手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'Mobile'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'短信息内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'Msg'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过短信猫发送,0否;1是' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'IsCat'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'端口号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'PortNo'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发送状态,null待发送,1:发送成功;2:发送失败' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'SendStatus'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'短信类型,1:发送;2:接收' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SmsMessageLog', @level2type=N'COLUMN',@level2name=N'SmsType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发送人:1、公司 2、客服、顾问 3、系统' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SOLLog', @level2type=N'COLUMN',@level2name=N'Sender'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 已查看 0 未查看' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SOLLog', @level2type=N'COLUMN',@level2name=N'IsViewed'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SOLProcess', @level2type=N'COLUMN',@level2name=N'IsActive'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'评价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SOLProcess', @level2type=N'COLUMN',@level2name=N'Evaluate'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'离线方式:1、点击退出 2、意外退出 3、长时间退出 4、踢出 5、留言' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SOLProcess', @level2type=N'COLUMN',@level2name=N'OfflineType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1、RTX发送 2、短信发送 3、文件监视 4、文件更新 5、传真发送 6、RTX状态检测 7、RTX消息检测' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ToolRunLog', @level2type=N'COLUMN',@level2name=N'ToolType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题的标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Topics', @level2type=N'COLUMN',@level2name=N'Title'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Topics', @level2type=N'COLUMN',@level2name=N'Description'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Topics', @level2type=N'COLUMN',@level2name=N'FileName'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Topics', @level2type=N'COLUMN',@level2name=N'Url'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题类型 : 1员工风采 2职场专题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Topics', @level2type=N'COLUMN',@level2name=N'type'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1工作日,3休息日,2半天工作日' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'workDate', @level2type=N'COLUMN',@level2name=N'Type'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关注时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxFans', @level2type=N'COLUMN',@level2name=N'AttentionDate'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关注取消时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxFans', @level2type=N'COLUMN',@level2name=N'AttentionCancelDate'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后一次接收消息日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxFans', @level2type=N'COLUMN',@level2name=N'LastReceiveDate'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后一次消息内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxFans', @level2type=N'COLUMN',@level2name=N'LastSendMessage'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0已取消关注 1 正在关注 2 已绑定账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxFans', @level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'粉丝发送的消息或者关注日期或者定位信息等' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageReceive', @level2type=N'COLUMN',@level2name=N'Message'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1关注 2发送文本 3 定位 4点击菜单 5点击链接 6取消关注 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageReceive', @level2type=N'COLUMN',@level2name=N'LogType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageSend', @level2type=N'COLUMN',@level2name=N'WxFansID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0未发送 1已成功发送 2发送失败' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageSend', @level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 模板消息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageSend', @level2type=N'COLUMN',@level2name=N'MessageType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'存放发送失败时的错误代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageSend', @level2type=N'COLUMN',@level2name=N'Remark'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxMessageSend', @level2type=N'COLUMN',@level2name=N'CpMainID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 登陆页面 2注册页面' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WXQrImage', @level2type=N'COLUMN',@level2name=N'PageType'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0默认 1用户已关注 2用户已确认' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WXQrImage', @level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务号名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'Name'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应用ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'AppID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应用密钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'AppSecret'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'UserName'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'Password'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1正常 2已停用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxServiceNo', @level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Title'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'TemplateTitle'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'详细内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Detail'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点击跳转路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Url'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1个人 2 企业' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Type'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Remark'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1正常 2 已停用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplate', @level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属模板编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplatePara', @level2type=N'COLUMN',@level2name=N'WxTemplateID'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参数名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplatePara', @level2type=N'COLUMN',@level2name=N'ParaName'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参数值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplatePara', @level2type=N'COLUMN',@level2name=N'ParaValue'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参数文本颜色' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WxTemplatePara', @level2type=N'COLUMN',@level2name=N'ParaColor'
- GO
|