ADMIN
테이블 (5)
리프레시 토큰 (refresh_token)
- REFRESH_TOKEN_ID (PK) — int — 기본 키 — NOT NULL — PK
- REFRESH_TOKEN (Field) — varchar(500) — NOT NULL
- DEL_YN (Field2) — int — NOT NULL
- FIRST_SAVE_DT (Field3) — datetime — NOT NULL
- FIRST_SAVE_USER (Field4) — varchar(20) — NOT NULL
- LAST_UPDATE_DT (Field5) — datetime
- LAST_UPDATE_USER (Field6) — varchar(20)
어드민 메뉴 (admin_menu)
- ADMIN_ACCOUNT_ID (PK) — int — 기본 키 — NOT NULL — PK
- PARENT_MENU_ID (Field) — int
- MENU_ORDER (Field2) — int
- MENU_PATH (Field3) — varchar(100)
- MENU_NAME (Field4) — varchar(100)
- DEL_YN (Field5) — int
- FIRST_SAVE_DT (Field6) — datetime
- FIRST_SAVE_USER (Field7) — varchar(20)
- LAST_UPDATE_DT (Field8) — datetime
- LAST_UPDATE_USER (Field9) — varchar(20)
어드민 유저 (admin_account)
- ADMIN_ACCOUNT_ID (PK) — int — 기본 키 — NOT NULL — PK
- REFRESH_TOKEN_ID (PK2) — int — 외래 키 → 리프레시 토큰.REFRESH_TOKEN_ID — NOT NULL — PK
- ADMIN_ID (Field) — varchar(20)
- PASSWORD (Field2) — varchar(100)
- NAME (Field3) — varchar(30)
- DEL_YN (Field5) — int
- FIRST_SAVE_DT (Field6) — datetime
- FIRST_SAVE_USER (Field7) — varchar(20)
- LAST_UPDATE_DT (Field8) — datetime
- LAST_UPDATE_USER (Field9) — varchar(20)
어드민 코드 (admin_code)
- ADMIN_CODE_ID (PK) — int — 기본 키 — NOT NULL — PK
- ADMIN_CODE_GROUP_ID (PK2) — int — 외래 키 → 어드민 코드 그룹.ADMIN_CODE_GROUP_ID — NOT NULL — PK
- ADMIN_CODE_NAME (Field) — varchar(50)
- ADMIN_CODE (Field2) — varchar(10)
- DEL_YN (Field3) — int
- FIRST_SAVE_DT (Field4) — datetime
- FIRST_SAVE_USER (Field5) — varchar(20)
- LAST_UPDATE_DT (Field6) — datetime
- LAST_UPDATE_USER (Field7) — varchar(20)
어드민 코드 그룹 (admin_code_group)
- ADMIN_CODE_GROUP_ID (PK) — int — 기본 키 — NOT NULL — PK
- ADMIN_CODE_GROUP_NAME (Field) — varchar(100) — NOT NULL
- DEL_YN (Field2) — int — NOT NULL
- FIRST_SAVE_DT (Field3) — datetime — NOT NULL
- FIRST_SAVE_USER (Field4) — varchar(20) — NOT NULL
- LAST_UPDATE_DT (Field5) — datetime
- LAST_UPDATE_USER (Field6) — varchar(20)