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)