TEST
Tables (7)
BA
- PID — VARCHAR2(20) — Primary key — NOT NULL
- PW — VARCHAR2(20)
- KOR_NAME — VARCHAR2(50)
- ENG_NAME — VARCHAR2(50)
- PART — VARCHAR2(3)
- PART_1 — VARCHAR2(5)
- AUTH — VARCHAR2(1)
- POS — CHAR(1)
- IP_ADDR — CHAR(15)
- REG_NO — CHAR(13)
- EXPIRED — CHAR(1)
- ENTRY_DT — CHAR(10)
- TEL_NO — VARCHAR2(20)
- EMAIL_ADDR — VARCHAR2(50)
- CELL_NO — VARCHAR2(20)
- BIZ_CD — VARCHAR2(4)
- PW_ERR_CNT — NUMBER(10)
- REMARK — VARCHAR2(1000)
- INP_PID — VARCHAR2(30)
- INP_IP_ADDR — VARCHAR2(30)
- CTRY — VARCHAR2(100)
- MAC_ADDR — VARCHAR2(500)
- MAC_CNT_TOT — NUMBER(10)
- MAC_CNT_CUR — NUMBER(10)
BB
- PART — VARCHAR2(5) — Primary key — NOT NULL
- PART_KN — VARCHAR2(50)
- PART_EN — VARCHAR2(100)
BIZ_MST
- BIZ_CD — CHAR(4) — Primary key — NOT NULL
- BIZ_KOR_NM — VARCHAR2(30)
- BIZ_ENG_NM — VARCHAR2(30)
- BIZ_EXPLAIN — VARCHAR2(50)
- INP_DTIME — TIMESTAMP(3)
- INP_EMP_NO — CHAR(6)
- INP_IP_ADDR — VARCHAR2(15)
MN_AUTH
- USER_ID — VARCHAR2(10) — Primary key — NOT NULL
- MENU_ID — VARCHAR2(10) — Primary key — NOT NULL
- MENU_ORDER — NUMBER(10)
- CRT_AUTH_YN — CHAR(1)
- READ_AUTH_YN — CHAR(1)
- MOD_AUTH_YN — CHAR(1)
- DEL_AUTH_YN — CHAR(1)
- INP_DTIME — TIMESTAMP(3)
- INP_EMP_NO — VARCHAR2(10)
- INP_IP_ADDR — VARCHAR2(15)
MN_GRP
- MENU_ID — VARCHAR2(10) — Primary key — NOT NULL
- BIZ_CD — CHAR(4) — Primary key — NOT NULL
- MENU_ORDER — NUMBER(10)
- INP_DTIME — TIMESTAMP(3)
- INP_EMP_NO — CHAR(6)
- INP_IP_ADDR — VARCHAR2(15)
MN_MST
- MENU_ID — VARCHAR2(10) — Primary key — NOT NULL
- PARENT_ID — VARCHAR2(10)
- VIEW_NO — VARCHAR2(4)
- MENU_SEQ — NUMBER(10)
- MENU_NM — VARCHAR2(100)
- MENU_ENM — VARCHAR2(100)
- DLL_PATH — VARCHAR2(100)
- CLASS_NM — VARCHAR2(100)
- MENU_DEPTH — NUMBER(10)
- MENU_TP — VARCHAR2(20)
- MENU_RB_TP — VARCHAR2(50)
- OPEN_MODE — VARCHAR2(10)
- IMAGE_INDEX — VARCHAR2(2)
- IMAGE_TYPE — NUMBER(10)
- ETC_INFO — VARCHAR2(1000)
- USE_YN — CHAR(1)
- MENU_DESCRIPTION — VARCHAR2(200)
- LEGACY_MENU_ID — VARCHAR2(20)
- LEGACY_MENU_NAME — VARCHAR2(50)
- LEGACY_REQUEST_PART — VARCHAR2(200)
- CODER — VARCHAR2(20)
- REG_DT — TIMESTAMP(6)
- REG_USR_ID — VARCHAR2(20)
TR_LOG_BAT
- STD_DT — VARCHAR2(8) — Primary key — NOT NULL
- SEQ — NUMBER(20) — Primary key — NOT NULL
- BASE_DT — VARCHAR2(8)
- TR_CSCO_ID — VARCHAR2(1000)
- REG_DTM — DATE
- BATCH_STEP — VARCHAR2(100)
- STATUS — VARCHAR2(20)
- SUCCESS_YN — VARCHAR2(2)
- ERR_MSG — VARCHAR2(1000)