SmartFramework

Tables (7)

ATRB_INFO (속성_정보)

  • ATRB_INFO_ID (속성_정보_아이디) — Primary key — NOT NULL
  • PRJ_ID (프로젝트_아이디) — Foreign key → PRJ_INFO.PRJ_ID — NOT NULL
  • ATRB_NM (속성_명)
  • ATRB_PHYS_NM (속성_물리_명)
  • ATRB_TYPE (속성_타입)
  • CD_NM (코드_명)
  • BSC_VL (기본_값)
  • UP_ATRB_INFO_ID (상위_속성_번호)

BSC_INFO (기본_정보)

  • BSC_INFO_ID (기본_정보_아이디) — Primary key — NOT NULL
  • PRJ_ID (프로젝트_아이디) — Foreign key → PRJ_INFO.PRJ_ID — NOT NULL
  • MENU_ID (화면_명)
  • MENU_TYPE (화면_타입)
  • MENU_YN (메뉴_여부)
  • SCRN_YN (화면_여부)
  • SORT_SEQ (정렬_순서)
  • DEL_YN (삭제_여부)
  • POPUP_YN (팝업_여부)
  • DSGNR_ID (설계자_아이디)
  • DSG_CMPTN_YN (설계_완료_여부)
  • DVLPR_ID (개발자_아이디)
  • DVLP_CMPTN_YN (개발_완료_여부)
  • REG_YMD (등록_일자)
  • MDFCN_YMD (수정_일자)

EVENT_INFO (이벤트_정보)

  • EVENT_INFO_ID (이벤트_정보_아이디) — Primary key — NOT NULL
  • PRJ_ID (프로젝트_아이디) — Foreign key → PRJ_INFO.PRJ_ID — NOT NULL
  • ATRB_NM (속성_명)
  • ATRB_PHYS_NM (속성_물리_명)
  • PRCS_TYPE (처리_유형)
  • PRCS_CN (처리_내용)
  • PRCS_FN (처리_함수)
  • UP_EVENT_INFO_ID (상위_이벤트_번호)

PRJ_INFO (프로젝트_정보)

  • PRJ_ID (프로젝트_아이디) — Primary key — NOT NULL
  • PRJ_NM (프로젝트_명)
  • CMD_NM (커맨드_명)
  • SCRN_NM (화면_명)
  • MENU_YN (메뉴_여부)
  • SCRN_YN (화면_여부)
  • DSGNR_NM (설계자_명)
  • DESIGN_CMPTN_YN (설계_완료_여부)
  • DVLPR_NM (개발자_명)
  • DVLP_CMPTN_YN (개발_완료_여부)

SCRN_INFO (화면_정보)

  • SCRN_INFO_ID (화면_정보_아이디) — Primary key — NOT NULL
  • PRJ_ID (프로젝트_아이디) — Foreign key → PRJ_INFO.PRJ_ID — NOT NULL
  • SCRN_IMG_PATH (화면_이미지_경로)
  • SCRN_EXPLN (화면_설명)
  • PRCS_CN (처리_내용)
  • SCRN_NM (화면_명)

SYS_INFO (시스템_정보)

  • SYS_ID (시스템_아이디) — Primary key — NOT NULL
  • SYS_NM (시스템_명)

SYS_ROLE_INFO (시스템_권한_정보)

  • SYS_ROLE_INFO_ID (시스템_권한_아이디) — Primary key — NOT NULL
  • SYS_ID (시스템_아이디) — Foreign key → SYS_INFO.SYS_ID — NOT NULL
  • SYS_ROLE_INFO_NM (시스템_권한_명)