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)