skycms

Tables (15)

Authority (사용자권한)

  • AuthorityType (Field) — 권한타입
  • AuthorityNo (Field2) — 권한번호
  • RegDt (Field3)
  • RegId (Field4)
  • ModDt (Field5)
  • ModId (Field6)

Board (게시판목록)

  • BoardNo (Field1) — 게시판번호
  • BoardCd (Field2) — 게시판코드
  • BoardUpperCd (Field3)
  • BoardNm (Field4)
  • SortOrder (Field5)
  • BoardUseYn (Field6)
  • BoardDeleteYn (Field7)
  • RegDt (Field8)
  • RegId (Field9)
  • ModDt (Field10)
  • ModId (Field11)
  • BoardDepth (Field12)
  • RssUrl (Field13) — Url주소

BoardAuthority (게시판권한)

  • BoardNo (Field) — 게시판번호
  • ListAuthority (Field2) — 목록권한
  • ReadAuthority (Field3) — 읽기권한
  • WriteAuthority (Field4) — 쓰기권한
  • ModAuthority (Field5) — 수정권한
  • DeleteAuthority (Field6) — 삭제권한
  • AnswerAuthority (Field7) — 답변권한
  • RegDt (Field8)
  • RegId (Field9)
  • ModDt (Field10)
  • ModId (Field11)

BoardConfig (게시판상세항목(템플릿))

  • BoardNo (게시판번호)
  • BoardTemplate (Field2)
  • BoarApproveYn (Field3)
  • CategoryUseYn (Field4)
  • BoardFileCount (Field)
  • RegDt (Field5)
  • RegId (Field6)
  • ModDt (Field7)
  • ModId (Field8)

BoardContent (게시물목록)

  • ContentNo (Field) — 게시물번호
  • BoardNo (Field2)
  • ParentNo (Field3) — 상위글번호
  • AnswerStep (Field4) — 답변글정렬순서
  • AnswerDepth (Field5)
  • CategoryContent (Field6)
  • Title (Field7)
  • Content (Field8)
  • ViewCount (Field9)
  • OpenYn (Field10) — 공개여부
  • AnswerYn (Field11)
  • RegDt (Field12)
  • RegId (Field13)
  • ModDt (Field14)
  • ModId (Field15)

ConfigProperty (게시판템플릿selectbox)

  • Template (Field)
  • ListCd (Field2)
  • ViewCd (Field3)
  • RegistCd (Field4)
  • RegDt (Field5)
  • RegId (Field6)
  • ModDt (Field7)
  • ModId (Field8)

DeleteReason (삭제이유)

  • DeleteCd (Field)
  • DeleteReson (Field2)

File (게시판첨부파일)

  • ContentNo (Field) — 게시물번호
  • BoardNo (Field2) — 게시판번호
  • FileNo (Field3) — 파일번호
  • FilePath (Field4)
  • FileNm (Field5)
  • OriginalNm (Field6)
  • FileExtension (Field7) — 파일확장자
  • FileSize (Field8)
  • FileUseYn (Field9)
  • RegDt (Field10)
  • RegId (Field11)
  • ModDt (Field12)
  • ModId (Field13)

Layout (레이아웃목록)

  • SiteCd (사이트코드) — varchar(20)
  • LayoutCd (레이아웃코드) — varchar(20)
  • LayoutDesc (레이아웃이름) — varchar(200)
  • LayoutContent (레이아웃컨텐츠) — varchar(1000)
  • FilePath (파일경로) — varchar(100)
  • RegDt (등록날짜) — varchar(20)
  • RegId (등록자) — varchar(20)
  • ModDt (수정날짜) — varchar(20)
  • ModId (수정자) — varchar(20)

LoginLog (로그인기록)

  • MemberId (Field)
  • MemberNm (Field2)
  • MemberIp (Field3)
  • LoginYn (Field4) — 로그인성공여부
  • RegDt (Field5)
  • RegId (Field6)
  • ModDt (Field7)
  • ModId (Field8)

Member (회원)

  • MemberId (회원아이디) — varchar(20)
  • MenberPw (비밀번호) — varchar(20)
  • MemberNm (회원이름) — varchar(10)
  • MemberEmail (이메일주소) — varchar(30)
  • PermissionCd (관리자코드) — varchar(20) — 최고관리자or일반관리자
  • DepartmentCd (부서코드) — varchar(20) — 관리자소속부서
  • ManagerUse (관리자해당여부) — char(1) — 관리자or일반사용자
  • MemberUse (회원사용여부) — char(1) — 탈퇴회원or이용중인회원
  • RegDt (등록날짜) — varchar(20)
  • RegId (등록자) — varchar(20)
  • ModDt (수정날짜) — varchar(20)
  • ModId (수정자) — varchar(20)

Menu (메뉴목록)

  • SiteCd (Field) — varchar(20)
  • MenuCd (Field2)
  • SortOrder (Field3)
  • MenuNm (Field4)
  • Title (Field5)
  • BasePath (Field6)
  • MenuPath (Field7)
  • MenuDepth (Field8)
  • AdminMenuUrl (Field9)
  • UserMenuUrl (Field10)
  • LayoutCd (Field11)
  • ParentsLayoutUseYn (Field12)
  • MenuType (Field13)
  • LinkType (Field14)
  • ShowYn (Field15)
  • UseYn (Field16)
  • RegDt (Field17)
  • RegId (Field18)
  • ModDt (Field19)
  • ModId (Field20)
  • HeadContent (Field21)

MenuContent (콘텐츠발행목록)

  • SiteCd (Field)
  • MenuCd (Field2)
  • ContentNo (Field3)
  • HeadContent (Field4)
  • BodyContent (Field5)
  • ApplyYn (Field6)
  • RegDt (Field7)
  • RegId (Field8)
  • ModDt (Field9)
  • ModId (Field10)

Site (사이트목록)

  • SiteNo (Field) — number
  • SiteCd (Field2) — varchar(20)
  • SiteNm (Field3) — varchar(50)
  • SiteDomain (Field4) — varchar(50)
  • SiteTypeCd (Field5) — varchar(20)
  • RegDt (Field6) — varchar(20)
  • RegId (Field7) — varchar(20)
  • ModDt (Field8) — varchar(20)
  • ModId (Field9) — varchar(20)
  • SitePath (Field10) — varchar(50)
  • Field11 (사이트사용여부(삭제여부)) — varchar(2)

TemplateDetail (게시판템플릿)

  • BoardNo (Field)
  • OrderNo (Field2)
  • ContentMapping (Field3)
  • LabelNmProperty (Field4)
  • LabelNecessaryYn (Field5)
  • LabelSize (Field6)
  • SearchLabelUseYn (Field7)
  • RegDt (Field8)
  • RegId (Field9)
  • ModDt (Field10)
  • ModId (Field11)