Data Dictionary Creator Data Dictionary Creator 2010-11-02T18:56:01Z 2010-11-02T18:56:01Z 12.00 10005 10005 120 135 26 24 False False Schema Table Description dbo Admin dbo AdminGroup dbo AdminLimitData dbo AdminLimitMenu dbo AdminLimitPage dbo AdminLog dbo AdminMenu dbo AdvCate dbo AdvData dbo CaseData dbo CaseLog dbo CaseRecruit dbo CaseReport dbo ContentCate dbo ContentData dbo FileData dbo ItemCate dbo ItemData dbo LinkCate dbo LinkData dbo Log dbo MarqueeData dbo MemberLog dbo OrderData dbo SetData dbo Teacher dbo TeacherFav dbo TeacherLog dbo TeachScore dbo TwAreaDB dbo TwCityDB 9 600 600 False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AdminID Int 4 N Y N 2 GroupID Int 4 Y N N 3 AdminAct NVarChar (50) 50 Y N N 4 AdminPwd NVarChar (50) 50 Y N N 5 AdminName NVarChar (50) 50 Y N N 7 Gender NChar (1) 1 Y N N 8 Email NVarChar (50) 50 Y N N 26 Note NText 16 Y N N 27 Enabled Bit 1 Y N N 28 IsReceiver Bit 1 Y N N 29 LoginCount Int 4 Y N N 30 LoginTime DateTime 8 Y N N 31 CreUser NVarChar (20) 20 Y N N 32 CreDate DateTime 8 Y N N 33 UpdUser NVarChar (20) 20 Y N N 34 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 GroupID Int 4 N Y N 2 Name NVarChar (50) 50 Y N N 3 Description NVarChar (500) 500 Y N N 4 Code NChar (10) 10 Y N N 5 Score Int 4 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AdminLimitID Int 4 N Y N 2 GroupID Int 4 Y N N 3 MenuID Int 4 Y N N 4 IsRead Bit 1 Y N N 5 IsWrite Bit 1 Y N N 6 IsEdit Bit 1 Y N N 7 IsDelete Bit 1 Y N N 8 Enabled Bit 1 Y N N 9 CreUser NVarChar (20) 20 Y N N 10 CreDate DateTime 8 Y N N 11 UpdUser NVarChar (20) 20 Y N N 12 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AdminLimitMenuID Int 4 N Y N 2 MenuID Int 4 Y N N 3 GroupID Int 4 Y N N 4 CreUser NVarChar (20) 20 Y N N 5 CreDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AdminLimitPageID Int 4 N Y N 2 MenuID Int 4 Y N N 3 PageName NVarChar (50) 50 Y N N 4 PageUrl NVarChar (255) 255 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 LogID Int 4 N Y N 2 StoreID Int 4 Y N N 3 AdminID Int 4 Y N N 4 LoginTime DateTime 8 Y N N 5 IP NVarChar (50) 50 Y N N 6 Chapter NVarChar (50) 50 Y N N 7 PageUrl NVarChar (500) 500 Y N N 8 Status NChar (10) 10 Y N N 9 Message NVarChar (500) 500 Y N N 10 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 MenuID Int 4 N Y N 2 ParentID Int 4 Y N N 3 Type NVarChar (10) 10 Y N N 4 Title NVarChar (50) 50 Y N N 5 Code NChar (20) 20 Y N N 6 URL NVarChar (255) 255 Y N N 7 Icon NVarChar (50) 50 Y N N 8 SortNum Int 4 Y N N 9 Folder Bit 1 Y N N 10 Enabled Bit 1 Y N N 11 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 CateID Int 4 N Y N 2 Name NVarChar (50) 50 Y N N 3 Code NChar (20) 20 Y N N 4 Description NText 16 Y N N 5 Width Int 4 Y N N 6 Height Int 4 Y N N 7 Mode NChar (1) 1 Y N N 8 SortNum Int 4 Y N N 9 Enabled Bit 1 Y N N 10 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AdvID Int 4 N Y N 2 LocCode NChar (20) 20 Y N N 3 Code NChar (20) 20 Y N N 4 Name Char (10) 10 Y N N 5 FilePath NVarChar (200) 200 Y N N 6 FileSize Int 4 Y N N 7 FileType NChar (10) 10 Y N N 8 Width Int 4 Y N N 9 Height Int 4 Y N N 10 Url NVarChar (200) 200 Y N N 11 StartDate DateTime 8 Y N N 12 EndDate DateTime 8 Y N N 13 ClickCount Int 4 Y N N 14 ViewCount Int 4 Y N N 15 Enabled Bit 1 Y N N 16 SortNum Int 4 Y N N 17 CreUser NVarChar (20) 20 Y N N 18 CreDate DateTime 8 Y N N 19 UpdUser NVarChar (20) 20 Y N N 20 UpdDate DateTime 8 Y N N 21 IsNever Bit 1 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 CaseID Int 4 N Y N 系統編號 2 CaseNo NVarChar (15) 15 Y N N 案件編號 3 Name NChar (10) 10 Y N N 家長姓名 4 TelH_F NChar (10) 10 Y N N 連絡電話(H)區碼 5 TelH NChar (10) 10 Y N N 連絡電話(H) 6 TelO_F NChar (10) 10 Y N N 連絡電話(O)區碼 7 TelO NChar (10) 10 Y N N 連絡電話(O) 8 Mobile NChar (20) 20 Y N N 行動電話 9 Email NVarChar (50) 50 Y N N Email 10 CaseStatus NChar (10) 10 Y N N 案件狀態 11 City NChar (10) 10 Y N N 上課縣市 12 Town NChar (10) 10 Y N N 上課區域 13 Addr NChar (10) 10 Y N N 上課地址 14 AddrNote NChar (10) 10 Y N N 附近地標說明 15 SchoolLevel NChar (10) 10 Y N N 學生等級 16 SchoolClass NChar (10) 10 Y N N 學生年級 17 ClassOnWeek Int 4 Y N N 每周上課數 18 ClassOnHour Int 4 Y N N 每次時數 19 ClassRequire NVarChar (20) 20 Y N N 家長需求時間 20 Pay Int 4 Y N N 時薪 21 StLevel Int 4 Y N N 學生目前程度 22 StSchool NVarChar (50) 50 Y N N 學生學校名稱 23 StGender NChar (2) 2 Y N N 學生性別 24 StCount Int 4 Y N N 學生人數 25 ClassDay NVarChar (500) 500 Y N N 可上課日 26 ClassItems NVarChar (500) 500 Y N N 學習科目 27 ClassItemOther NVarChar (50) 50 Y N N 學習科目其他 28 TrGender NChar (5) 5 Y N N 教師性別 29 TrExp Int 4 Y N N 教師資歷年 30 IsRole Bit 1 Y N N 是否限制教師身分 31 TrRole NVarChar (50) 50 Y N N 教師身分 32 IsSchool Bit 1 Y N N 學校科系限制 33 TrCate1 NChar (10) 10 Y N N 學校類別1 34 TrCate2 NChar (10) 10 Y N N 學校類別2 35 TrSchool1 NVarChar (50) 50 Y N N 學校名1 36 TrSchool2 NVarChar (50) 50 Y N N 學校名2 37 TrClass1 NVarChar (50) 50 Y N N 科系1 38 TrClass2 NVarChar (50) 50 Y N N 科系2 39 Note NText 16 Y N N 其他說明 40 How NChar (20) 20 Y N N 如何得知本站 41 HowFriend NChar (20) 20 Y N N 如何得知本站(朋友) 42 HowOther NVarChar (50) 50 Y N N 如何得知本站(其他) 43 RealClassDate DateTime 8 Y N N 實際上課日 44 Status NChar (1) 1 Y N N 案件回報狀態代碼 45 ViewCount Int 4 Y N N 瀏覽數 46 Enabled Bit 1 Y N N 啟用 47 IsFast Bit 1 Y N N 是否為急案件 48 IsSale Bit 1 Y N N 是否為優惠案件 49 IP NChar (20) 20 Y N N IP位址 50 InDate DateTime 8 Y N N 建檔日期 False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 LogID Int 4 N Y N 2 CaseID Int 4 Y N N 3 Code NVarChar (20) 20 Y N N 4 IP NVarChar (20) 20 Y N N 5 Valid Bit 1 Y N N 6 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 RecruitID Int 4 N Y N 2 CaseID Int 4 Y N N 3 TeacherID Int 4 Y N N 4 Q1 Int 4 Y N N 5 Q2 Int 4 Y N N 6 Q3 Int 4 Y N N 7 Q4 Int 4 Y N N 8 Q5 Int 4 Y N N 9 Q6 Int 4 Y N N 10 Q6Txt NChar (20) 20 Y N N 11 Note NText 16 Y N N 12 Status NChar (10) 10 Y N N 13 IsValid Bit 1 Y N N 14 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ReportID Int 4 N Y N 2 CaseID Int 4 Y N N 3 TeacherID Int 4 Y N N 4 Status NChar (1) 1 Y N N 5 TestDate DateTime 8 Y N N 6 ChangeDate DateTime 8 Y N N 7 ClassDate DateTime 8 Y N N 8 Class Int 4 Y N N 9 Hour Int 4 Y N N 10 Pay Int 4 Y N N 11 Note NText 16 Y N N 12 IsValid Bit 1 Y N N 13 IsSend Bit 1 Y N N 14 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 CateId Int 4 N Y N 2 Code NChar (10) 10 Y N N 3 CateName NVarChar (50) 50 Y N N 4 CateDesc NVarChar (50) 50 Y N N 5 IconPath NVarChar (50) 50 Y N N 6 PicPath NVarChar (50) 50 Y N N 7 SortNum Int 4 Y N N 8 Enabled Bit 1 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ContentID Int 4 N Y N 2 Code NChar (20) 20 Y N N 3 Subject NVarChar (500) 500 Y N N 4 Intro NText 16 Y N N 5 Description NText 16 Y N N 6 EventDate DateTime 8 Y N N 7 StartDate DateTime 8 Y N N 8 EndDate DateTime 8 Y N N 9 IsNever Bit 1 Y N N 10 PicPath NVarChar (500) 500 Y N N 11 PicType NChar (20) 20 Y N N 12 FilePath NVarChar (500) 500 Y N N 13 FileType NChar (20) 20 Y N N 14 Enabled Bit 1 Y N N 15 SortNum Int 4 Y N N 16 IsDate Bit 1 Y N N 17 ViewCount Int 4 Y N N 18 CreUser NVarChar (20) 20 Y N N 19 CreDate DateTime 8 Y N N 20 UpdUser NVarChar (20) 20 Y N N 21 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 FileID Int 4 N Y N 2 Code NChar (10) 10 Y N N 3 RelationID Int 4 Y N N 4 FileNo NVarChar (20) 20 Y N N 5 Name NVarChar (200) 200 Y N N 6 Description NText 16 Y N N 7 FilePath NVarChar (200) 200 Y N N 8 FileSize NVarChar (50) 50 Y N N 9 FileDate DateTime 8 Y N N 10 Enabled Bit 1 Y N N 11 SortNum Int 4 Y N N 12 CreUser NVarChar (20) 20 Y N N 13 CreDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ItemCateID Int 4 N Y N 2 Chapter NChar (10) 10 Y N N 3 CateName NVarChar (50) 50 Y N N 4 CateCode NVarChar (50) 50 Y N N 5 IsRange Bit 1 Y N N 6 Locked Bit 1 Y N N 7 SortNum Int 4 Y N N 8 Enabled Bit 1 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ItemID Int 4 N Y N 2 CateCode NChar (20) 20 Y N N 3 ItemName NVarChar (50) 50 Y N N 4 ItemValue NVarChar (50) 50 Y N N 5 SortNum Int 4 Y N N 6 Enabled Bit 1 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 CateID Int 4 N Y N 2 CateName NVarChar (50) 50 Y N N 3 Enabled Bit 1 Y N N 4 SortNum Int 4 Y N N 5 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 LinkID Int 4 N Y N 2 CateID Int 4 Y N N 3 Name NVarChar (50) 50 Y N N 4 Description NText 16 Y N N 5 URL NVarChar (500) 500 Y N N 6 PicPath NVarChar (200) 200 Y N N 7 Enabled Bit 1 Y N N 8 SortNum Int 4 Y N N 9 CreUser NVarChar (20) 20 Y N N 10 CreDate DateTime 8 Y N N 11 UpdUser NVarChar (20) 20 Y N N 12 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 LogID BigInt 8 N Y N 2 Code NChar (20) 20 Y N N 3 Act NVarChar (20) 20 Y N N 4 RelationID NVarChar (50) 50 Y N N 5 SessionID NVarChar (50) 50 Y N N 6 Name NVarChar (200) 200 Y N N 7 RefererURL NVarChar (200) 200 Y N N 8 CurrentURL NVarChar (200) 200 Y N N 9 ClientIP NVarChar (20) 20 Y N N 10 Description NText 16 Y N N 11 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 MarqID Int 4 N Y N 2 Subject NVarChar (100) 100 Y N N 3 LinkUrl NVarChar (500) 500 Y N N 4 SortNum Int 4 Y N N 5 Enabled Bit 1 Y N N 6 CreUser NChar (10) 10 Y N N 7 CreDate DateTime 8 Y N N 8 UpdUser NChar (10) 10 Y N N 9 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ID Int 4 N Y N 2 TeacherID Int 4 Y N N 3 SessionID NVarChar (50) 50 Y N N 4 RelationID Int 4 Y N N 5 Chapter NChar (20) 20 Y N N 6 Code NChar (20) 20 Y N N 7 Type NChar (1) 1 Y N N 8 URL NVarChar (500) 500 Y N N 9 Dscr NText 16 Y N N 10 Coin Int 4 Y N N 11 ClientIP NVarChar (20) 20 Y N N 12 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 OrderID Int 4 N Y N 2 OrderNo NVarChar (50) 50 Y N N 3 MemberID Int 4 Y N N 4 MemberName NVarChar (50) 50 Y N N 5 MemberGender NChar (10) 10 Y N N 6 ProductID Int 4 Y N N 7 ProductName NVarChar (100) 100 Y N N 8 Quantity Int 4 Y N N 9 Price Int 4 Y N N 10 Total Int 4 Y N N 11 Tel NVarChar (50) 50 Y N N 12 Mobile NVarChar (50) 50 Y N N 13 Address NVarChar (200) 200 Y N N 14 Status NChar (10) 10 Y N N 15 PayType NChar (10) 10 Y N N 16 PayStatus NChar (10) 10 Y N N 17 OutDate DateTime 8 Y N N 18 PayDate DateTime 8 Y N N 19 OrderDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 SetID Int 4 N Y N 2 Mode NChar (1) 1 Y N N 3 Status NChar (10) 10 Y N N 4 Hour Int 4 Y N N 5 UpDown Bit 1 Y N N 6 RepStatus NChar (10) 10 Y N N 7 RepWay NChar (10) 10 Y N N 8 Note NVarChar (50) 50 Y N N 10 UpdUser NVarChar (50) 50 Y N N 11 UpdDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 TeacherID Int 4 N Y N 系統編號 2 GUID NVarChar (50) 50 Y N N GUID 3 No NChar (10) 10 Y N N 教師編號 4 Type NChar (1) 1 Y N N 教師身分 5 Act NChar (20) 20 Y N N 帳號 6 Pwd NChar (50) 50 Y N N 密碼 7 Name NVarChar (20) 20 Y N N 姓名 8 NickName NVarChar (50) 50 Y N N 暱稱 9 Gender NChar (10) 10 Y N N 性別 10 IDNum NVarChar (50) 50 Y N N 身分證字號 11 Birthday DateTime 8 Y N N 出生日期 12 Email NVarChar (50) 50 Y N N Email 13 Email2 NVarChar (50) 50 Y N N 備用Email 14 TelType NChar (1) 1 Y N N 電話形式 15 TelF NChar (15) 15 Y N N 電話區碼 16 Tel NChar (20) 20 Y N N 電話號碼 17 TelOF NChar (10) 10 Y N N 宿舍電話區碼 18 TelO NChar (20) 20 Y N N 宿舍電話號碼 19 TelOExt NChar (15) 15 Y N N 宿舍電話分機 20 TelOther NChar (20) 20 Y N N 其他連絡電話 21 Fax NChar (20) 20 Y N N 傳真 22 Mobile1 NChar (20) 20 Y N N 行動電話 23 Mobile2 NChar (20) 20 Y N N 行動電話2 24 Hobby NVarChar (250) 250 Y N N 興趣 25 NCity NChar (10) 10 Y N N 現居地址縣市 26 NTown NChar (10) 10 Y N N 現居地址區域 27 NAddress NVarChar (50) 50 Y N N 現居地址 28 FCity NChar (10) 10 Y N N 永久地址縣市 29 FTown NChar (10) 10 Y N N 永久地址區域 30 FAddress NVarChar (50) 50 Y N N 永久地址 31 MSN NVarChar (50) 50 Y N N MSN 32 SKYPE NVarChar (50) 50 Y N N SKYPE 33 PPT NVarChar (50) 50 Y N N PPT 34 PicPath NVarChar (250) 250 Y N N 圖片路徑 35 ShowPic Bit 1 Y N N 是否顯示圖片 36 SchoolTopCate NChar (10) 10 Y N N 最高學歷學校類別 37 SchoolTop NChar (10) 10 Y N N 最高學歷學校 38 SchoolFile NVarChar (50) 50 Y N N 學校附件 39 SchoolClass NVarChar (50) 50 Y N N 學校科系 40 SchoolLevel NChar (10) 10 Y N N 41 SchoolCate NChar (10) 10 Y N N 42 BeforeSchool NVarChar (50) 50 Y N N 前一學校 43 BeforeOther NVarChar (20) 20 Y N N 前一學校其他 44 NowRole NVarChar (20) 20 Y N N 目前身份 45 NowOther NVarChar (20) 20 Y N N 其他身分 46 Profassional NVarChar (50) 50 Y N N 專業證照 47 TeachExp Int 4 N N N 教學經驗年 48 TeachClass NVarChar (250) 250 Y N N 授課科目 49 TeachOther NVarChar (50) 50 Y N N 授課科目其他 50 Target1 Bit 1 Y N N 可教授對象1 51 Target2 Bit 1 Y N N 可教授對象2 52 Target3 Bit 1 Y N N 可教授對象3 53 Target4 Bit 1 Y N N 可教授對象4 54 Target5 Bit 1 Y N N 可教授對象5 55 Target6 Bit 1 Y N N 可教授對象6 56 TargetPay1 Int 4 Y N N 希望待遇1 57 TargetPay2 Int 4 Y N N 希望待遇2 58 TargetPay3 Int 4 Y N N 希望待遇3 59 TargetPay4 Int 4 Y N N 希望待遇4 60 TargetPay5 Int 4 Y N N 希望待遇5 61 TargetPay6 Int 4 Y N N 希望待遇6 62 TeachDay NVarChar (200) 200 Y N N 可上課日 63 TeachDayDis Bit 1 Y N N 可上課日是否面議 64 TeachTown NVarChar (200) 200 Y N N 可上課區域 65 Concept NText 16 Y N N 教學理念 66 How NVarChar (20) 20 Y N N 如何得知本站 67 HowFriend NChar (10) 10 Y N N 如何得知本站(朋友名) 68 HowOther NChar (20) 20 Y N N 如何得知本站(其他) 69 Enabled Bit 1 Y N N 啟用 70 ValidMail Bit 1 Y N N 是否通過Email驗證 71 ValidRole Bit 1 Y N N 是否通過身分驗證 72 ValidModify Bit 1 Y N N 是否通過修改資料驗證 73 IsNew Bit 1 Y N N 是否是New 74 IsRecommend Bit 1 Y N N 是否是推薦教師 75 IsBlack Bit 1 Y N N 是否為黑名單 76 IsClose Bit 1 Y N N 是否關閉履歷 77 ViewCount Int 4 Y N N 瀏覽數 78 CreDate DateTime 8 Y N N 建檔日期 79 UpdDate DateTime 8 Y N N 異動日期 6 3 4 R5 False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 FavID Int 4 N N N 2 Code NChar (20) 20 Y N N 3 RelationID Int 4 Y N N 4 FavURL NVarChar (500) 500 Y N N 5 TeacherID Int 4 Y N N 6 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 LogID Int 4 N Y N 2 TeacherID Int 4 Y N N 3 Code NVarChar (20) 20 Y N N 4 IP NVarChar (20) 20 Y N N 5 Valid Bit 1 Y N N 6 InDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 ScoreID Int 4 N Y N 2 TeacherID Int 4 Y N N 3 Good Int 4 Y N N 4 Normal Int 4 Y N N 5 Bad Int 4 Y N N 6 CreUser NVarChar (20) 20 Y N N 7 CreDate DateTime 8 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 AreaId Int 4 N Y N 2 CityId NVarChar (50) 50 Y N N 3 AreaName NVarChar (50) 50 Y N N 4 Dscr NVarChar (50) 50 Y N N 5 ZipCode NChar (10) 10 Y N N 6 SortNum Int 4 Y N N 7 Enabled Bit 1 Y N N False False Number Column Datatype Size Nullable InPrimaryKey IsForeignKey Description 1 CityId Int 4 N Y N 2 CityName NVarChar (50) 50 Y N N 3 Dscr NChar (10) 10 Y N N 4 ZipCode NChar (10) 10 Y N N 5 PartName NVarChar (50) 50 Y N N 6 PartCode NChar (10) 10 Y N N 7 SortNum Int 4 Y N N 8 Enabled Bit 1 Y N N False False