new cms

Tables (16)

Authority (게시판권한)

  • Field
  • Field2
  • Field3
  • Field4

Bbs (게시판목록)

  • BbsNo (Field)
  • BbsCd (Field2)
  • BbsUpperCd (Field3)
  • BbsName (Field4)
  • SortOrder (Field5)
  • BbsUserYn (Field6) — 사용여부
  • BbsDeleteYn (Field7) — 삭제여부
  • RegDt (Field8)
  • RegId (Field9)
  • ModDt (Field10)
  • ModId (Field11)
  • BbsDepth (Field12)

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

  • Field
  • Field2
  • Field3
  • Field4

BbsContents (게시물목록)

  • Field
  • Field2
  • Field3
  • Field4

BbsDetail (게시판상세)

  • Field
  • Field2
  • Field3
  • Field4

DeleteReason (삭제이유)

  • Field
  • Field2
  • Field3
  • Field4

File (게시판첨부파일)

  • Field
  • Field2
  • Field3
  • Field4

Layout (레이아웃목록)

  • SiteCd (Field)
  • LayoutCd (Field2)
  • LayoutDesc (Field3)
  • LayoutContent (Field4)
  • FilePath (Field5)
  • RegDt (Field6)
  • RegId (Field7)
  • ModDt (Field8)
  • ModId (Field9)

LoginLog (Untitled)

  • Field
  • Field2
  • Field3
  • Field4

Member (회원)

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

Menu (메뉴목록)

  • SiteCd (Field)
  • 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 (콘텐츠발행목록)

  • Field
  • Field2
  • Field3
  • Field4

MenuDetail (메뉴상세)

  • Field
  • Field2
  • Field3
  • Field4

Site (사이트목록)

  • SiteNo (사이트idx) — number
  • SiteCd (사이트코드) — varchar(20)
  • SiteNm (사이트네임) — varchar(50)
  • SiteDomain (사이트도메인) — varchar(50)
  • SiteTypeCd (사이트유형코드) — varchar(20)
  • RegDt (등록날짜) — varchar(20)
  • RegId (등록자) — varchar(20)
  • ModDt (수정날짜) — varchar(20)
  • ModId (수정자) — varchar(20)
  • SitePath (사이트경로) — varchar(50)

Template (템플릿목록)

  • Field
  • Field2
  • Field3
  • Field4

TemplateDetail (템플릿상세)

  • Field
  • Field2
  • Field3
  • Field4