ax-boot
Tables (12)
AUTH_GROUP_MAP_M
- GRP_AUTH_CD — varchar(100) — Primary key — NOT NULL
- MENU_ID — bigint(20) — Primary key — NOT NULL
- SCH_AH — varchar(1)
- SAV_AH — varchar(1)
- EXL_AH — varchar(1)
- DEL_AH — varchar(1)
- FN1_AH — varchar(1)
- FN2_AH — varchar(1)
- FN3_AH — varchar(1)
- FN4_AH — varchar(1)
- FN5_AH — varchar(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
CHILD_SAMPLE
- SAMPLE_KEY — varchar(255) — Primary key — NOT NULL
- SAMPLE_PARENT_KEY — varchar(255)
- SAMPLE_VALUE — varchar(255)
- ETC1 — varchar(255)
- ETC2 — varchar(255)
- ETC3 — varchar(255)
COMMON_CODE_M
- CODE — varchar(100) — Primary key — NOT NULL
- GROUP_CD — varchar(100) — Primary key — NOT NULL
- GROUP_NM — varchar(100)
- NAME — varchar(50)
- SORT — int(11)
- DATA1 — varchar(100)
- DATA2 — varchar(100)
- DATA3 — varchar(100)
- DATA4 — int(11)
- DATA5 — int(11)
- REMARK — varchar(200)
- USE_YN — varchar(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
ERROR_LOG_M
- ID — bigint(20) — Primary key — NOT NULL
- PHASE — varchar(10)
- SYSTEM — varchar(50)
- LOGGER_NAME — varchar(300)
- SERVER_NAME — varchar(50)
- HOST_NAME — varchar(50)
- PATH — varchar(2048)
- MESSAGE — text
- TRACE — text
- ERROR_DATETIME — datetime
- ALERT_YN — varchar(1)
- HEADER_MAP — text
- PARAMETER_MAP — text
- USER_INFO — text
FILE_L
- ID — bigint(20) — Primary key — NOT NULL
- TARGET_TYPE — varchar(50)
- TARGET_ID — varchar(100)
- FILE_NM — text
- SAVE_NM — text
- FILE_TYPE — varchar(30)
- EXTENSION — varchar(10)
- FILE_SIZE — bigint(20)
- DEL_YN — varchar(1)
- FILE_DESC — text
- SORT — int(11)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
MANUAL_M
- MANUAL_ID — bigint(20) — Primary key — NOT NULL
- MANUAL_GRP_CD — varchar(100)
- MANUAL_NM — varchar(100)
- PARENT_ID — bigint(20)
- LEVEL — int(11)
- SORT — int(11)
- CONTENT — longtext
- MANUAL_KEY — varchar(100)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
MENU_M
- MENU_ID — bigint(20) — Primary key — NOT NULL
- MENU_GRP_CD — varchar(100)
- MENU_NM — varchar(100)
- PARENT_ID — bigint(20)
- LEVEL — int(11)
- SORT — int(11)
- PROG_CD — varchar(50)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
PARENT_SAMPLE
- SAMPLE_KEY — varchar(255) — Primary key — NOT NULL
- SAMPLE_VALUE — varchar(255)
- ETC1 — varchar(255)
- ETC2 — varchar(255)
- ETC3 — varchar(255)
- ETC4 — varchar(255)
PROG_M
- PROG_CD — varchar(50) — Primary key — NOT NULL
- PROG_NM — varchar(50)
- PROG_PH — varchar(100)
- TARGET — varchar(10)
- AUTH_CHECK — varchar(1)
- SCH_AH — varchar(1)
- SAV_AH — varchar(1)
- EXL_AH — varchar(1)
- DEL_AH — varchar(1)
- FN1_AH — varchar(1)
- FN2_AH — varchar(1)
- FN3_AH — varchar(1)
- FN4_AH — varchar(1)
- FN5_AH — varchar(1)
- REMARK — varchar(200)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
USER_AUTH_M
- ID — bigint(20) — Primary key — NOT NULL
- USER_CD — varchar(255)
- GRP_AUTH_CD — varchar(255)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
USER_M
- USER_CD — varchar(100) — Primary key — NOT NULL
- USER_NM — varchar(30) — NOT NULL
- USER_PS — varchar(128) — NOT NULL
- EMAIL — varchar(50)
- HP_NO — varchar(15)
- REMARK — varchar(200)
- LAST_LOGIN_DATE — datetime
- PASSWORD_UPDATE_DATE — datetime
- USER_STATUS — varchar(10)
- IP — varchar(100)
- LOCALE — varchar(10)
- MENU_GRP_CD — varchar(100)
- USE_YN — varchar(1) — NOT NULL
- DEL_YN — varchar(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
USER_ROLE_M
- ID — bigint(20) — Primary key — NOT NULL
- USER_CD (USER_CD2) — varchar(100) — Foreign key → USER_M.USER_CD — NOT NULL
- ROLE_CD — varchar(100) — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)