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