cybms
Tables (13)
TSM_ATHRT_MENU_MAPPING (권한/메뉴 매핑)
- athrtMgtId (Key3) — String — Foreign key → TSM_ATHRT_MGT_M.athrtMgtId — NOT NULL
- menuMgtId (Key2) — String — Foreign key → TSM_MENU_MGT_D.menuMgtId — NOT NULL
- delYn (Field) — String
- RGST_DTTM (Field2) — DATE
- REGSTR_ID (Field3) — VARCHAR2(50)
- MDFC_DTTM (Field4) — String
- MDFR_ID (Field5) — VARCHAR2(50)
TSM_ATHRT_MGT_M (권한관리기본)
- athrtMgtId (Key) — String — Primary key — NOT NULL
- athrtMgtNm (Field) — String
- delYn (Field6) — String
- RGST_DTTM (Field2) — DATE
- REGSTR_ID (Field3) — VARCHAR2(50)
- MDFC_DTTM (Field4) — String
- MDFR_ID (Field5) — VARCHAR2(50)
TSM_BLTNBD_MGT_M (게시판관리)
- BLTNBD_MGT_SN (Key) — VARCHAR(20) — Primary key — NOT NULL
- MENU_MGT_ID (Key2) — VARCHAR(20) — Foreign key → TSM_MENU_MGT_M.menuMgtId — NOT NULL
- BLTNBD_NM (Field) — VARCHAR(20)
- bltnbdDvsCd (Key3) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- bltnbdDvsCdId (Key22) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- BLTNBD_DISEVC (Field3) — VARCHAR(20)
- ATCHFL_YN (Field4) — CHAR(1)
- CMNT_USE_YN (Field5) — CHAR(1)
- USE_YN (Field6) — CHAR(1)
- SCRT_WRTNG_USE_YN (Field7) — CHAR(1)
- NTC_PRD_USE_YN (Field8) — CHAR(1)
- DEL_YN (Field9) — CHAR(1)
- RGST_DTTM (Field2) — DATE
- REGSTR_ID (Field10) — VARCHAR2(50)
- MDFC_DTTM (Field11) — DATE
- MDFR_ID (Field12) — VARCHAR2(50)
TSM_CMNCD_MGT_M (공통코드관리기본)
- CMNCD_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- GRP_CD_ID (Key2) — VARCHAR(20) — Primary key — NOT NULL
- CMNCD_NM (Field) — VARCHAR(20)
- CMNCD_ENGNM (Field4) — VARCHAR(20)
- hgrnkGrpCd (Key3) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- hgrnkCmncd (Key22) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- SEQC (Field3) — VARCHAR(3)
- CD_EXPLN (Field14) — VARCHAR(2000)
- ADD_ATTR (Field6) — VARCHAR(10)
- USE_YN (Field5) — CHAR(1)
- DEL_YN (Field10) — CHAR(1)
- RGST_DTTM (Field9) — DATE
- REGSTR_ID (Field11) — VARCHAR2(50)
- MDFC_DTTM (Field12) — DATE
- MDFR_ID (Field13) — VARCHAR2(50)
TSM_GRP_CD_M (그룹코드)
- GRP_CD_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- GRP_CD_NM (Field) — VARCHAR2(50)
- USE_YN (Field7) — CHAR(1)
- DEL_YN (Field2) — CHAR(1)
- RGST_DTTM (Field3) — DATE
- REGSTR_ID (Field4) — VARCHAR2(50)
- MDFC_DTTM (Field5) — DATE
- MDFR_ID (Field6) — VARCHAR2(50)
TSM_MENU_MGT_D (메뉴관리상세)
- menuMgtId (Key2) — String — Foreign key → TSM_MENU_MGT_M.menuMgtId — NOT NULL
- btnCd (Key) — CHAR(2) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- grpCdId (Key22) — String — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- wrtDttm (Field4) — DATE
- REGSTR_ID (Field2) — VARCHAR2(50)
- RGST_DTTM (Field5) — String
- MDFR_ID (Field6) — VARCHAR2(50)
- delYn (Field7) — String
TSM_MENU_MGT_M (메뉴관리기본)
- menuMgtId (Key) — String — Primary key — NOT NULL
- menuId (Field) — String
- menuNm (Field2) — String
- menuUrl (Field3) — String
- hgrnkMenuId (Field4) — String
- useYn (Field10) — String
- trnngModeUseYn (Field11) — String
- seq (Field13) — String
- screenDvs (Field12) — String
- menuExtrnlRspc (Field14) — String
- arngHrzntLen (Field15) — String
- arngVtclLen (Field16) — String
- delYn (Field9) — String
- RGST_DTTM (Field6) — DATE
- REGSTR_ID (Field5) — VARCHAR2(50)
- MDFC_DTTM (Field7) — String
- MDFR_ID (Field8) — VARCHAR2(50)
TSM_NTC_WRTNG_MGT_M (게시글관리기본)
- NTC_WRTNG_MGT_SN (Key) — VARCHAR(20) — Primary key — NOT NULL
- BLTNBD_MGT_SN (Key2) — VARCHAR(20) — Foreign key → TSM_BLTNBD_MGT_M.BLTNBD_MGT_SN — NOT NULL
- TITLE (Field) — VARCHAR(20)
- CTNT (Field2) — VARCHAR(2000)
- RGST_UNIT (Field9) — CHAR(10)
- ATCHFL_SN_CTLG (Field5) — VARCHAR(200)
- answrYn (Field14) — CHAR(1)
- ANSWR_YN (Field10) — VARCHAR(20)
- ANSWR_ATCHFL_SN_CTLG (Field12) — VARCHAR(200)
- ANSWR_CTNT (Field11) — VARCHAR(2000)
- SCRT_WRTNG_YN (Field13) — CHAR(1)
- NTC_STARTDT (Field15) — DATE
- NTC_ENDDT (Field16) — DATE
- DEL_YN (Field3) — CHAR(1)
- RGST_DTTM (Field4) — DATE
- REGSTR_ID (Field6) — VARCHAR2(50)
- MDFC_DTTM (Field7) — DATE
- MDFR_ID (Field8) — VARCHAR2(50)
TSM_SYSTEM_USER_UC (체계사용자부대코드)
- SYSTEM_USER_UC (Field3) — CHAR(10) — Foreign key → TSM_UNIT_INFO.UC
- SYSTEM_USER_NM (Field) — VARCHAR(20)
- MN_UNIT_YN (Field2) — CHAR(1)
- TELNO (Field4) — VARCHAR(20)
- DEL_YN (Field5) — CHAR(1)
- RGST_DTTM (Field6) — DATE
- REGSTR_ID (Field7) — VARCHAR2(50)
- MDFC_DTTM (Field8) — DATE
- MDFR_ID (Field9) — VARCHAR2(50)
TSM_UNIT_INFO (부대정보)
- UC (Field) — CHAR(10) — Primary key
- HGRNK_UNIT_NM (Field3) — CHAR(10)
- UNIT_NM (Field2) — VARCHAR(20)
- UNIT_COORD (Field4) — VARCHAR(15)
- Cmncd (Key) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- grpCd (Key2) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- mdcd (Key3) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- mdcdId (Key22) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- unitScaleCd (Key4) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- UNIT_SCALE_CD_ID (Key23) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- DEL_YN (Field5) — CHAR(1)
- RGST_DTTM (Field6) — DATE
- REGSTR_ID (Field7) — VARCHAR2(50)
- MDFC_DTTM (Field8) — DATE
- MDFR_ID (Field9) — VARCHAR2(50)
TSM_USER_ATHRT_MAPPING (사용자/권한 매핑)
- ATHRT_MGT_ID (Key3) — String — Foreign key → TSM_ATHRT_MGT_M.athrtMgtId — NOT NULL
- USER_MGT_ID (Key) — VARCHAR2(50) — Foreign key → TSM_USER_MGT_M.USER_MGT_ID — NOT NULL
- DEL_YN (r) — String
- RGST_DTTM (w) — DATE
- REGSTR_ID (Field4) — VARCHAR2(50)
- MDFC_DTTM (Field5) — String
- MDFR_ID (Field) — VARCHAR2(50)
TSM_USER_CTFCTN_SETUP_MGT_M (사용자인증설정관리)
- USER_CTFCTN_SETUP_MGT_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- ACC_TRMVT (Field6) — VARCHAR2(2)
- CNNTN_MTNC_TIME (Field7) — VARCHAR2(2)
- PW_ENGLSH_USE_YN (Field8) — CHAR(1)
- PW_NMRL_USE_YN (Field9) — CHAR(1)
- PW_SPCHR_USE_YN (Field10) — CHAR(1)
- PW_CHNG_CYCLE (Field11) — VARCHAR2(2)
- PW_MIN_LEN (Field12) — VARCHAR2(2)
- ERR_PRMSN_NUMTM (Field13) — CHAR(1)
- DEL_YN (Field) — CHAR(1)
- RGST_DTTM (Field2) — DATE
- REGSTR_ID (Field3) — VARCHAR2(50)
- MDFC_DTTM (Field4) — DATE
- MDFR_ID (Field5) — VARCHAR2(50)
TSM_USER_MGT_M (사용자관리기본)
- USER_MGT_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- USER_ID (Field) — VARCHAR2(50)
- USER_PW (Field4) — VARCHAR2(50)
- SRVNO (Field2) — VARCHAR2(50)
- RANK (Field16) — VARCHAR2(20)
- USER_NM (Field3) — VARCHAR2(50)
- ASGMT_UNIT (Field6) — VARCHAR2(50)
- SYSTEM_USER_UNIT (Field5) — VARCHAR2(50)
- MDCD (Key4) — CHAR(1) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- MDCD_ID (Key22) — VARCHAR2(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- TELNO (Field8) — VARCHAR2(20)
- PW_CHNG_DTTM (Field9) — DATE
- FNL_LOGIN_DTTM (Field10) — DATE
- IP (Field13) — VARCHAR2(15)
- CNNTN_PRMSN_IP_YN (Field20) — CHAR(1)
- API_APLY_YN (Field22) — CHAR(1)
- CLSLVCD (Key2) — CHAR(1) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- GRPCDID (Key23) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- ASSSTATECD (Key3) — CHAR(3) — Foreign key → TSM_CMNCD_MGT_M.CMNCD_ID — NOT NULL
- ASSSTATEDCDID (Key24) — VARCHAR(20) — Foreign key → TSM_CMNCD_MGT_M.GRP_CD_ID — NOT NULL
- SOLTN_ATHRT (Field14) — VARCHAR2(50)
- DEL_YN (Field21) — CHAR(1)
- RGST_DTTM (Field17) — DATE
- REGSTR_ID (Field18) — VARCHAR2(50)
- MDFC_DTTM (Field11) — DATE
- MDFR_ID (Field19) — VARCHAR2(50)