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 (시스템_권한_명)