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)