system

Tables (6)

TB_COMPANY

  • COMP_ID — BIGINT
  • COMP_CODE — VARCHAR(20) — NOT NULL
  • COMP_NM — VARCHAR(100) — NOT NULL
  • UP_COMP_ID — BIGINT — Foreign key → TB_COMPANY.COMP_ID
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME

TB_COMP_MENU

  • COMP_MENU_ID — BIGINT
  • COMP_ID — BIGINT — Foreign key → TB_COMPANY.COMP_ID — NOT NULL
  • MENU_ID — BIGINT — Foreign key → TB_MENU.MENU_ID — NOT NULL
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME

TB_MENU

  • MENU_ID — BIGINT
  • MENU_CODE — VARCHAR(20) — NOT NULL
  • MENU_NM — VARCHAR(100) — NOT NULL
  • UP_MENU_ID — BIGINT — Foreign key → TB_MENU.MENU_ID
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME

TB_ROLE

  • ROLE_ID — BIGINT
  • ROLE_CODE — VARCHAR(20) — NOT NULL
  • COMP_ID — BIGINT — Foreign key → TB_COMPANY.COMP_ID — NOT NULL
  • ROLE_NM — VARCHAR(100) — NOT NULL
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME

TB_ROLE_MENU

  • ROLE_MENU_ID — BIGINT
  • ROLE_ID — BIGINT — Foreign key → TB_ROLE.ROLE_ID — NOT NULL
  • MENU_ID — BIGINT — Foreign key → TB_MENU.MENU_ID — NOT NULL
  • READ_YN — CHAR(1)
  • WRITE_YN — CHAR(1)
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME

TB_USER

  • USER_ID — BIGINT
  • LOGIN_ID — VARCHAR(50) — NOT NULL
  • COMP_ID — BIGINT — Foreign key → TB_COMPANY.COMP_ID — NOT NULL
  • ROLE_ID — BIGINT — Foreign key → TB_ROLE.ROLE_ID — NOT NULL
  • USER_NM — VARCHAR(50) — NOT NULL
  • CRT_ID — VARCHAR(50)
  • CRT_DT — DATETIME