KIMSResource

테이블 (25)

1:1문의 (BBS_Inquiry)

  • ContentID — int — 기본 키 — NOT NULL
  • ContentNo — int
  • Category — varchar(2) — NOT NULL
  • 제목 (Title) — varchar(1000)
  • 내용 (Contents) — text
  • 읽음횟수 (ViewCount) — int
  • InquiryType — varchar(1) — NOT NULL
  • 질문자ID (InquiryID) — varchar(25)
  • 질문자명 (InquiryName) — varchar(25)
  • 질문자메일 (InquiryMail) — varchar(100)
  • 질문일 (InquiryDate) — datetime
  • 회원코드 (MemberCode) — varchar(10)
  • 답변자ID (ReplyID) — varchar(25)
  • 답변자명 (ReplyName) — varchar(25)
  • 답변일 (ReplyDate) — datetime
  • 답변내용 (ReplyText) — text
  • 답변첨부파일1 (ReplyFileName1) — varchar(200)
  • 답변첨부파일2 (ReplyFileName2) — varchar(200)
  • 답변첨부파일3 (ReplyFileName3) — varchar(200)
  • ReplyYN — varchar(1)
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • KIMSCode — varchar(11)
  • InquiryIP — varchar(30)
  • DeleteYN — char(1)
  • AdminMemberCode — varchar(10)
  • AdminUpdateDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

BBS_FileName

  • BBSType — char(3)
  • ContentID — int
  • FileType — varchar(10)
  • FileName — varchar(500)
  • RealFileName — varchar(1000)
  • FolderName — varchar(500)
  • PrintOrder — int
  • LastUpdate — datetime
  • CategoryID — varchar(8)
  • ContentNo — int

CME (CTS_CME)

  • ContentID — int — 기본 키 — NOT NULL
  • Key — 기본 키 — NOT NULL
  • ContentNo — int — NOT NULL
  • Category — char(2) — NOT NULL
  • SubCategory — char(4) — NOT NULL
  • Section — char(2) — NOT NULL
  • Title — varchar(1000)
  • Summary — varchar(max)
  • Contents — text
  • ViewCount — int
  • WriteDate — datetime
  • UpdateDate — datetime
  • ImageFile — varchar(200)
  • OpenYN — varchar(1)
  • DeleteYN — char(1)
  • SearchField — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CMS_Source

  • NHIGenCode — varchar(20) — 기본 키 — NOT NULL
  • 학술센터 게시판 종류코드 (categoryID) — varchar(4) — 기본 키 — NOT NULL — 학술센터 게시판 종류코드
  • 학술센터 게시물 ContentID (ContentID) — varchar(10) — 기본 키 — NOT NULL — 학술센터 게시물 ContentID
  • (ContentNo) — varchar(20)
  • 학술센터 게시판 종류 (Category) — varchar(40) — 학술센터 게시판 종류
  • Contents_ID — int
  • 학술센터 게시물 제목 (Title) — varchar(500) — 학술센터 게시물 제목
  • P:킴스코드/G:주성분코드 (CodeType) — char(1) — NOT NULL — P:킴스코드/G:주성분코드
  • InsertDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

CTS_NewsLetter

  • 컨텐츠ID (ContentID) — int — 기본 키 — NOT NULL — 컨텐츠ID
  • 발송년월(ex:201705) (YYYY) — varchar(4) — 발송년월(ex:201705)
  • MM — varchar(2)
  • Issue(회차) (Issue) — varchar(50) — Issue(회차)
  • 제목 (Title) — varchar(300) — 제목
  • FileName — varchar(100)
  • 발송일 (SendDate) — datetime — 발송일
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DRS_Event_Target

  • DRS_Event.ContentID (ContentID) — int — 기본 키 — NOT NULL — DRS_Event.ContentID
  • 대상순번 (TargetIdx) — int — 기본 키 — NOT NULL — 대상순번
  • 전공1 (MedicalPart) — varchar(4) — 전공1
  • 전공2 (MedicalPartDtl) — varchar(4) — 전공2
  • 근무기관1 (OrgCls) — varchar(4) — 근무기관1
  • 근무기관2 (OrgClsDtl) — varchar(4) — 근무기관2
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

FAQ리스트 (REF_FAQCategory)

  • Code — char(3) — 기본 키 — NOT NULL
  • FAQ명 (Name) — varchar(50)
  • 메뉴순서 (PrintOrder) — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

FAQ상세내용 (BBS_FAQ)

  • ContentID — int — 기본 키 — NOT NULL
  • Type — char(1)
  • Title — varchar(1000)
  • Contents — text
  • OpenYN — varchar(1)
  • SearchField — varchar(max)
  • LastUpdate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =
  • Code (Category) — char(3) — 외래 키 → FAQ리스트.Code — NOT NULL

MNG_PopularDisease

  • DiseaseID — int — 기본 키 — NOT NULL
  • DiseaseName — varchar(100)
  • DiseaseNameEn — varchar(100)
  • PrintOrder — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MNG_RecommendWord

  • YYMM — nvarchar(7) — 기본 키 — NOT NULL
  • SearchWord — nvarchar(100) — 기본 키 — NOT NULL
  • RecommendWord — nvarchar(100) — 기본 키 — NOT NULL
  • CNT — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

MNG_SearchFailWord

  • YYMM — nvarchar(7) — 기본 키 — NOT NULL
  • WORD — nvarchar(100) — 기본 키 — NOT NULL
  • CNT — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

MemberCMELog

  • MemberCode — char(10) — NOT NULL
  • ContentID — int — NOT NULL
  • InsertDate — datetime — NOT NULL

공지사항 (BBS_Notice)

  • ContentID — int — 기본 키 — NOT NULL
  • ContentNo — int — NOT NULL
  • Title — varchar(1000) — NOT NULL
  • Contents — text
  • ViewCount — int
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • WriteDate — datetime
  • FileName1 — varchar(200)
  • FileName2 — varchar(200)
  • FileName3 — varchar(200)
  • Type — char(1) — NOT NULL
  • OpenYN — varchar(1) — NOT NULL
  • SearchField — nvarchar(max)
  • NoticeYN — char(1) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

메디컬포커스 (CTS_MedicalFocus)

  • ContentID — int — 기본 키 — NOT NULL
  • ContentNo — int — NOT NULL
  • Title — varchar(1000)
  • Summary — varchar(max)
  • Contents — text
  • ViewCount — int
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • WriteDate — datetime
  • ImageFile — varchar(200)
  • OpenYN — varchar(1)
  • DeleteYN — char(1)
  • SearchField — nvarchar(max)
  • 정렬순서 (Sort) — int — 정렬순서
  • 게시판 타입(메디컬포커스 : M / Pharma Updates : P) (BoardType) — char(1) — 게시판 타입(메디컬포커스 : M / Pharma Updates : P)
  • Pharma Updates 데이터이관(백업용) (BackupContentID) — int — Pharma Updates 데이터이관(백업용)
  • Pharma Updates 데이터이관(백업용) (BackupContentType) — char(1) — Pharma Updates 데이터이관(백업용)
  • LastUpdate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

문의카테고리 (REF_InquiryCategory)

  • Code — char(2) — 기본 키 — NOT NULL
  • Name — varchar(50)
  • PrintOrder — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

성상변경내역 (CTS_National_News_Appearance)

  • ContentID — int — 기본 키 — NOT NULL
  • ProductCode — char(11)
  • ComCode — char(11)
  • ImageFileAfter — varchar(200) — NOT NULL
  • DescriptionAfter — varchar(200)
  • DimAxisLongAfter — varchar(10)
  • DimAxisShortAfter — varchar(10)
  • DimThicknessAfter — varchar(10)
  • SymbolFrontAfter — varchar(200)
  • SymbolBackAfter — varchar(200)
  • ImageFileBefore — varchar(200) — NOT NULL
  • DescriptionBefore — varchar(200)
  • DimAxisLongBefore — varchar(10)
  • DimAxisShortBefore — varchar(10)
  • DimThicknessBefore — varchar(10)
  • SymbolFrontBefore — varchar(200)
  • SymbolBackBefore — varchar(200)
  • ViewCount — int
  • WriteDate — datetime
  • LastUpdate — datetime — NOT NULL
  • RegisterDate — datetime — NOT NULL
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • ProductNameRaw — varchar(100)
  • CompanyNameRaw — varchar(100)
  • DeleteTag — bit
  • ItemIdx — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

세계의학뉴스 (CTS_GlobalHealthNews)

  • ContentID — int — 기본 키 — NOT NULL
  • ContentNo — int — NOT NULL
  • Title — varchar(1000)
  • Contents — text
  • ViewCount — int
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • WriteDate — datetime
  • ImageFile — varchar(200)
  • SourceUrl — varchar(1000)
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • LastUpdate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

약제급여기준개정내역 (CTS_National_News_Benefit)

  • ContentID — int — 기본 키 — NOT NULL
  • Title — varchar(1000) — NOT NULL
  • Basis — varchar(200) — NOT NULL
  • StartDate — datetime — NOT NULL
  • Category — varchar(50) — NOT NULL
  • Division — varchar(50) — NOT NULL
  • Reason — varchar(max) — NOT NULL
  • Detail — varchar(max) — NOT NULL
  • ViewCount — int
  • WriteDate — datetime
  • LastUpdate — datetime — NOT NULL
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

이벤트 (BBS_Event)

  • ContentID — int — 기본 키 — NOT NULL
  • ContentNo — int — NOT NULL
  • 이벤트명 (Title) — varchar(1000)
  • 내용 (Contents) — text
  • 클릭수 (ViewCount) — int
  • 작성자ID (WriterID) — varchar(25)
  • 작성자 (WriterName) — varchar(25)
  • 작성일 (WriteDate) — datetime
  • ImageFile — varchar(200)
  • FileName1 — varchar(200)
  • FileName2 — varchar(200)
  • FileName3 — varchar(200)
  • BeginDate — datetime
  • EndDate — datetime
  • ResultUrl — varchar(1000)
  • NoticeContentID — int
  • Site — char(1)
  • Type — char(1)
  • OpenYN — varchar(1)
  • 검색내용 (SearchField) — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

제약업계소식 (CTS_National_News_Story)

  • ContentID — int — 기본 키 — NOT NULL
  • Title — varchar(1000) — NOT NULL
  • Contents — varchar(max) — NOT NULL
  • ViewCount — int
  • WriteDate — datetime
  • LastUpdate — datetime — NOT NULL
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • CategoryId — int
  • ScheduledPublishDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

질환포커스카테고리 (REF_QNACategory)

  • Class — char(1) — 기본 키 — NOT NULL
  • Code — char(3) — 기본 키 — NOT NULL
  • Name — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

컨퍼런스 (CTS_Conference_Issue)

  • IssueID — int — 기본 키 — NOT NULL
  • Title — varchar(1000)
  • IssuePlace — varchar(100)
  • IssueDate — datetime
  • OpenYN — varchar(1)
  • PCShortURL — varchar(100)
  • 모바일 단축 URL (SPShortURL) — varchar(100) — 모바일 단축 URL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

컨퍼런스콘텐츠 (CTS_Conference_Content)

  • ContentID — int — 기본 키 — NOT NULL
  • TopicID — int — 외래 키 → 컨퍼런스토픽.TopicID — NOT NULL
  • Language — char(2)
  • Title — varchar(1000)
  • Introduction — varchar(max)
  • Contents — text
  • ViewCount — int
  • WriterID — varchar(25)
  • WriterName — varchar(25)
  • WriteDate — datetime
  • OpenYN — varchar(1)
  • SearchField — nvarchar(max)
  • LastUpdate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =

컨퍼런스토픽 (CTS_Conference_Topic)

  • TopicID — int — 기본 키 — NOT NULL
  • ImageFile — varchar(200)
  • ImageFileList — varchar(200)
  • Author — varchar(50)
  • OpenYN — varchar(1)
  • RegDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =
  • IssueID — int — 외래 키 → 컨퍼런스.IssueID — NOT NULL

회사링크 (CTS_National_News_Story_Company_Link)

  • LinkID — int — 기본 키 — NOT NULL
  • ItemID — int — NOT NULL
  • ComCode — char(5) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • ContentID — int — 외래 키 → 성상변경내역.ContentID — NOT NULL
  • ContentID (ContentID2) — int — 외래 키 → 약제급여기준개정내역.ContentID — NOT NULL
  • ContentID (ContentID3) — int — 외래 키 → 제약업계소식.ContentID — NOT NULL