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