MSolution

Tables (10)

tb_ms_authority

  • authority — varchar(50) — Primary key — NOT NULL
  • authority_name — varchar(50) — NOT NULL

tb_ms_group

  • group_id — varchar(50) — Primary key — NOT NULL
  • group_name — varchar(50) — NOT NULL

tb_ms_group_ authority

  • group_id — varchar(50) — Foreign key → tb_ms_group.group_id — NOT NULL
  • authority — varchar(50) — Foreign key → tb_ms_authority.authority — NOT NULL

tb_ms_group_member

  • user_id — varchar(50) — Foreign key → tb_ms_user.user_id — NOT NULL
  • group_id — varchar(50) — Foreign key → tb_ms_group.group_id — NOT NULL

tb_ms_site

  • site_id — varchar(4) — Primary key — NOT NULL
  • site_name — varchar(50) — NOT NULL

tb_ms_sol_site

  • sol_site_id — bigint — Primary key — NOT NULL — 정보등록 푸쉬용
  • site_id — varchar(4) — Foreign key → tb_ms_site.site_id — NOT NULL
  • sol_version — varchar(4) — Foreign key → tb_ms_sol_version.sol_version — NOT NULL
  • apply_date — datetime — NOT NULL
  • apply_contents — varchar(50)
  • apply_worker — varchar(50)
  • rgst_date — timestamp — NOT NULL
  • rgst_id — varchar(50) — NOT NULL
  • upd_date — timestamp — NOT NULL
  • upd_id — varchar(50) — NOT NULL

tb_ms_sol_version

  • sol_version — varchar(4) — Primary key — NOT NULL
  • sol_name — varchar(50) — NOT NULL — 솔루션 버젼 이름

tb_ms_user

  • user_id — varchar(50) — Primary key — NOT NULL
  • password — varchar(50) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • enabled — boolean — NOT NULL
  • rgst_date — timestamp — NOT NULL
  • rgst_id — varchar(50) — NOT NULL
  • upd_date — timestamp — NOT NULL
  • upd_id — varchar(50) — NOT NULL

tb_ms_user_authority

  • user_id — varchar(50) — Foreign key → tb_ms_user.user_id — NOT NULL
  • authority — varchar(50) — Foreign key → tb_ms_authority.authority — NOT NULL

tb_ms_user_login

  • series — varchar(64) — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → tb_ms_user.user_id — NOT NULL
  • token — varchar(64) — NOT NULL
  • last_used — timestamp — NOT NULL
  • last_push_sol_site_id — bigint