Kims_Contents_DB
Tables (22)
Autoit_Temp
- UID — uniqueidentifier — NOT NULL
- GovNewsNo — int — NOT NULL
- CategoryID — char(100) — NOT NULL
- Category — nvarchar(100) — NOT NULL
- Title — nvarchar(100) — NOT NULL
- Content — nvarchar(max) — NOT NULL
- SubCategory — nvarchar(100) — NOT NULL
- PartType — nvarchar(100)
- Department — nvarchar(100) — NOT NULL
- NoticeNo — nvarchar(100)
- SiteURL — nvarchar(200) — NOT NULL
- WriteDate — datetime — NOT NULL
- NoticeDate — datetime — NOT NULL
- ClickCnt — int — NOT NULL
- OpenYN — char(100) — NOT NULL
- AttFile1 — nvarchar(200)
- AttFile2 — nvarchar(200)
- AttFile3 — nvarchar(200)
- AttFile4 — nvarchar(200)
- AttFile5 — nvarchar(200)
- AttFile6 — nvarchar(200)
- AttFile7 — nvarchar(200)
- AttFile8 — nvarchar(200)
- AttFile9 — nvarchar(200)
- AttFile10 — nvarchar(200)
- AttFileB1 — varbinary(max)
- AttFileB2 — varbinary(max)
- AttFileB3 — varbinary(max)
- AttFileB4 — varbinary(max)
- AttFileB5 — varbinary(max)
- AttFileB6 — varbinary(max)
- AttFileB7 — varbinary(max)
- AttFileB8 — varbinary(max)
- AttFileB9 — varbinary(max)
- AttFileB10 — varbinary(max)
- LastUpDate — datetime — NOT NULL
Drug_Disease_Guide
- id — int
- Name — nvarchar(60)
- Name_Hsp — varchar(2)
- Description — ntext
- Symptoms — ntext
- Complication — ntext
- Cause — ntext
- Self — ntext
- Treat — ntext
- Prevention — ntext
- Parents — ntext
- SelfEdit — ntext
HS_TotalBoard
- BIDX — int — NOT NULL
- BNumber — int
- BTitle — varchar(1000)
- BContent — text
- BWDate — datetime
- BHitNum — int
- BWNm — varchar(100)
- BEmail — varchar(1000)
- BTeam — varchar(500)
- BWID — varchar(50)
- BRef — int
- BRefStep — int
- BRefLevel — int
- BPIDX — int
- BMenuType — varchar(20)
- BFileNm0 — varchar(100)
- BFileNm1 — varchar(100)
- BFileNm2 — varchar(100)
- BCheckYN — varchar(1)
- BSubTitle — varchar(1000)
- BSubContent — varchar(2000)
- BPublishNo — varchar(50)
- BPageNo — varchar(50)
- BEDate — datetime
- TempID — varchar(50)
- BOrder — varchar(10)
- BReferMan — varchar(100)
- vBMenuType — varchar(50)
- sCateID_Old — varchar(15)
- BArticleSource — text
KIMS_GovNews
- GovNewsNo — int — NOT NULL
- CategoryID — char(4) — NOT NULL
- Category — nvarchar(10) — NOT NULL
- Title — nvarchar(100) — NOT NULL
- Content — text — NOT NULL
- SubCategory — nvarchar(20) — NOT NULL
- PartType — nvarchar(10)
- Department — nvarchar(40) — NOT NULL
- NoticeNo — nvarchar(20)
- SiteURL — nvarchar(200) — NOT NULL
- WriteDate — datetime — NOT NULL
- NoticeDate — datetime — NOT NULL
- ClickCnt — int — NOT NULL
- OpenYN — char(1) — NOT NULL
- AttFile1 — nvarchar(200)
- AttFile2 — nvarchar(200)
- AttFile3 — nvarchar(200)
- AttFile4 — nvarchar(200)
- AttFile5 — nvarchar(200)
- AttFile6 — nvarchar(200)
- AttFile7 — nvarchar(200)
- AttFile8 — nvarchar(200)
- AttFile9 — nvarchar(200)
- AttFile10 — nvarchar(200)
- LastUpDate — datetime — NOT NULL
- KCDYN — nvarchar(2)
KIMS_GovNews_Temp
- UID — uniqueidentifier — NOT NULL
- GovNewsNo — int — NOT NULL
- CategoryID — char(100) — NOT NULL
- Category — nvarchar(100) — NOT NULL
- Title — nvarchar(100) — NOT NULL
- Content — nvarchar(max) — NOT NULL
- SubCategory — nvarchar(100) — NOT NULL
- PartType — nvarchar(100)
- Department — nvarchar(100) — NOT NULL
- NoticeNo — nvarchar(100)
- SiteURL — nvarchar(200) — NOT NULL
- WriteDate — datetime — NOT NULL
- NoticeDate — datetime — NOT NULL
- ClickCnt — int — NOT NULL
- OpenYN — char(100) — NOT NULL
- AttFile1 — nvarchar(200)
- AttFile2 — nvarchar(200)
- AttFile3 — nvarchar(200)
- AttFile4 — nvarchar(200)
- AttFile5 — nvarchar(200)
- AttFile6 — nvarchar(200)
- AttFile7 — nvarchar(200)
- AttFile8 — nvarchar(200)
- AttFile9 — nvarchar(200)
- AttFile10 — nvarchar(200)
- AttFileB1 — varbinary(max)
- AttFileB2 — varbinary(max)
- AttFileB3 — varbinary(max)
- AttFileB4 — varbinary(max)
- AttFileB5 — varbinary(max)
- AttFileB6 — varbinary(max)
- AttFileB7 — varbinary(max)
- AttFileB8 — varbinary(max)
- AttFileB9 — varbinary(max)
- AttFileB10 — varbinary(max)
- LastUpDate — datetime — NOT NULL
KIMS_Main_CME
- CNo — int — Primary key — NOT NULL
- Title — nvarchar(100)
- ConURL — nvarchar(200)
- MemberCode — char(10)
- LastUpDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Category_History
- HistNo — int — Primary key — NOT NULL
- HistCode — varchar(10)
- HistMm — varchar(500)
- HistDate — datetime
- MemberNo — int
- HistStatus — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Category_Setting
- CategoryNo — int — Primary key — NOT NULL
- CategoryConf — varchar(20)
- CategoryID — varchar(8)
- CommentYN — varchar(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Contents_File
- CategoryID — varchar(8) — Primary key — NOT NULL
- ContentNo — int — Primary key — NOT NULL
- FileNo — int — Primary key — NOT NULL
- FileType — varchar(10)
- FileNm — varchar(500)
- FileRealNm — varchar(1000)
- FolderNm — varchar(500)
- FileFullNm — varchar(1000)
- FileDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Contents_Info
- ContentNo — int — Primary key — NOT NULL
- ctsTitle — nvarchar(max)
- ctsText — nvarchar(max)
- ctsSummary — nvarchar(2000)
- ctsClickNum — int
- ctsDownNum — int
- ctsWriterNm — varchar(25)
- ctsEmail — varchar(50)
- cts_Org_Dept — varchar(200)
- ctsWDate — datetime
- ctsPosition — varchar(1)
- cts_Mo_Ho — varchar(10)
- cts_Mo_Page — varchar(10)
- ctsStatus — varchar(1)
- ctsKeyWord — varchar(500)
- cts_Org_Source — varchar(1000)
- cts_Page_Num — varchar(10)
- cts_Mo_Pub_Date — varchar(10)
- CategoryID — varchar(8)
- ctsStep — int
- ctsLevel — int
- ctsRefKey — int — NOT NULL
- ctsReplyText — text
- ctsReplyYN — varchar(1)
- ctsPrintNum — int
- MemberNo — int
- MemberCode — char(10)
- ctsWriterID — varchar(25)
- ctsTel — varchar(25)
- ctsMbl — varchar(20)
- ctsWriterPWD — varchar(20)
- ctsPublicYN — varchar(1)
- ctsSiteCode — varchar(8)
- ctsRootNo — int
- cts_Org_Title — varchar(100)
- ctsUrl — varchar(1000)
- subCateID — varchar(100)
- ctsSDate — varchar(10)
- ctsEDate — varchar(10)
- cts_ThumbNail — varchar(100)
- cts_Data0 — varchar(200)
- cts_Data1 — varchar(200)
- cts_Data2 — varchar(200)
- FileRefID — varchar(10)
- RefCateID — varchar(100)
- ctsSubTitle — varchar(1000)
- ctsSubText — text
- ctsStamp — timestamp — NOT NULL
- ctsSearchText — text
- ctsClassify — varchar(50)
- ctsReplyNo — int
- SearchField — nvarchar(max)
- ctsReciveEmailYN — varchar(50)
- ctsPolycyType — varchar(100)
- ctsWriteTypeCD — varchar(8)
- ctsReplyDate — datetime
- ctsOpenYn — varchar(1)
- ctsReplyID — varchar(20)
- ctsReplyNM — varchar(20)
- remark1 — nvarchar(1000)
- … +6
MMKGroup_Contents_Info_Delete
- ID — int — Primary key — NOT NULL
- ContentNo — int — NOT NULL
- ctsTitle — varchar(500)
- ctsText — text
- ctsClickNum — int
- ctsWriterNm — varchar(25)
- ctsEmail — varchar(50)
- ctsReciveEmailYN — varchar(50)
- ctsWDate — datetime
- ctsPosition — varchar(1)
- cts_Org_Source — varchar(1000)
- CategoryID — varchar(8)
- ctsStep — int
- ctsLevel — int
- ctsRefKey — int — NOT NULL
- ctsReplyText — text
- ctsSummary — nvarchar(500)
- ctsReplyYN — varchar(1)
- MemberNo — int
- ctsWriterID — varchar(25)
- ctsUrl — varchar(1000)
- subCateID — varchar(100)
- ctsSDate — varchar(10)
- ctsEDate — varchar(10)
- cts_Data0 — varchar(200)
- SearchField — varchar(7000)
- DeleteDate — datetime
- ctsWriteTypeCD — varchar(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Contents_LOG
- LogNo — int — Primary key — NOT NULL
- LogIP — varchar(20)
- MemberNo — int
- LogDate — datetime
- ContentNo — int — Foreign key → MMKGroup_Contents_Info.ContentNo
- CategoryID — varchar(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_Contents_Memo
- MemoNo — int — Primary key — NOT NULL
- MemoTt — varchar(200)
- MemoCont — varchar(1000)
- MemoWriter — varchar(50)
- MemoDate — datetime
- MemoPoint — int
- MemoStatus — varchar(2)
- ContentNo — int — Foreign key → MMKGroup_Contents_Info.ContentNo
- MemoPassword — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_LCate_Info
- LCateID — char(3) — Primary key — NOT NULL
- LCateNm — varchar(50)
- LCateYN — varchar(1)
- LCateOrd — smallint
- MemberNo — int
- LCateDate — datetime
- LCateMm — varchar(200)
- GroupCode — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_MCate_Info
- MCateID — char(8) — Primary key — NOT NULL
- MCateNm — varchar(50)
- MCateYN — varchar(1)
- MCateOrd — smallint
- MemberNo — int
- MCateDate — datetime
- LCateID — char(3) — Foreign key → MMKGroup_LCate_Info.LCateID
- MCateMm — varchar(200)
- MCateNodeYN — varchar(1)
- ctsClassify — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_MCate_Setting
- MSetNo — int — Primary key — NOT NULL
- MCateID — char(8) — Foreign key → MMKGroup_MCate_Info.MCateID
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMKGroup_SCate_Info
- SCateID — varchar(8) — Primary key — NOT NULL
- SCateNm — varchar(50)
- SCateYN — varchar(1)
- SCateOrd — smallint
- MemberNo — int
- SCateDate — datetime
- MCateID — char(8) — Foreign key → MMKGroup_MCate_Info.MCateID
- SCateMm — varchar(200)
- SCateSetting — varchar(20)
- CategoryConf — varchar(10)
- CommentYN — char(1)
- SCateNmEn — varchar(50)
- Category — varchar(10)
- CategoryNM — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TBL_CME
- CMESEQ — int — Primary key — NOT NULL
- Specailty1 — nvarchar(100)
- Specailty2 — nvarchar(100)
- Specailty3 — nvarchar(100)
- TitleKor — nvarchar(200)
- ContentsKor — text
- TitleEng — nvarchar(200)
- ContentsEng — text
- Url — nvarchar(200)
- RegDT — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TBL_PrescribeGuide
- PGSeq — int — Primary key — NOT NULL
- TitleKor — nvarchar(200) — NOT NULL
- TitleEng — nvarchar(200) — NOT NULL
- Topyn — bit — NOT NULL
- Lvl — int
- Remark — nvarchar(500)
- Cover — nvarchar(255)
- ListImg — nvarchar(255)
- UseYN — bit — NOT NULL
- RegDT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TBL_PrescribeGuide_Sub
- PGSSeq — int — Primary key — NOT NULL
- PGSeq — int — NOT NULL
- sTitle — nvarchar(200) — NOT NULL
- sTitleen — nvarchar(200)
- Keyword — nvarchar(4000)
- Lvl — int — NOT NULL
- Remark — nvarchar(500)
- RegDT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TBL_PrescribeGuide_SubImage
- PGSISeq — int — Primary key — NOT NULL
- PGSSeq — int — NOT NULL
- FileName — nvarchar(500) — NOT NULL
- Width — int
- Height — int
- Lvl — int — NOT NULL
- SampleYN — bit
- RegDT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
dig
- DiseCd — nvarchar(255)
- UserDef — nvarchar(255)
- E_Dis — nvarchar(255)
- H_Dis — nvarchar(255)