hr
Tables (16)
SYS_ACTION
- SYS_ACTION_ID — BIGINT — Primary key — NOT NULL
- CODE — VARCHAR(50)
- NAME — VARCHAR(200)
- DESCRIPTION — VARCHAR(500)
SYS_DATA_SCOPE
- SYS_DATA_SCOPE_ID — BIGINT — Primary key — NOT NULL
- CODE — VARCHAR(100) — NOT NULL
- NAME — VARCHAR(200) — NOT NULL
- SCOPE_TYPE — VARCHAR(50) — NOT NULL
- DESCRIPTION — VARCHAR(500)
- STATUS — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
- MODIFIED_DATE — DATETIME
- MODIFIED_BY — VARCHAR(50)
SYS_DATA_SCOPE_DETAIL
- SYS_DATA_SCOPE_DETAIL_ID — BIGINT — Primary key — NOT NULL
- SYS_DATA_SCOPE_ID — BIGINT — Foreign key → SYS_DATA_SCOPE.SYS_DATA_SCOPE_ID — NOT NULL
- TARGET_TYPE — VARCHAR(50) — NOT NULL
- TARGET_ID — BIGINT — NOT NULL
- IS_DEFAULT — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
SYS_PERMISSION
- SYS_PERMISSION_ID — BIGINT — Primary key — NOT NULL
- SYS_RESOURCE_ID — BIGINT — Foreign key → SYS_RESOURCE.SYS_RESOURCE_ID — NOT NULL
- SYS_ACTION_ID — BIGINT — Foreign key → SYS_ACTION.SYS_ACTION_ID — NOT NULL
- CODE — VARCHAR(200)
- NAME — VARCHAR(500)
SYS_PERMISSION_GROUP
- SYS_PERMISSION_GROUP_ID — BIGINT — Primary key — NOT NULL
- CODE — VARCHAR(100) — NOT NULL
- NAME — VARCHAR(200) — NOT NULL
- DESCRIPTION — VARCHAR(500)
- STATUS — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
- MODIFIED_DATE — DATETIME
- MODIFIED_BY — VARCHAR(50)
SYS_PERMISSION_GROUP_PERMISSION
- SYS_PERMISSION_GROUP_ID — BIGINT — Foreign key → SYS_PERMISSION_GROUP.SYS_PERMISSION_GROUP_ID — NOT NULL
- SYS_PERMISSION_ID — BIGINT — Foreign key — NOT NULL
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
SYS_RESOURCE
- SYS_RESOURCE_ID — BIGINT — Primary key — NOT NULL
- CODE — VARCHAR(50)
- NAME — VARCHAR(200)
- DESCRIPTION — VARCHAR(500)
- SYS_RESOURCE_NEW_ID — BIGINT
- MENU_ID — BIGINT
SYS_ROLE
- SYS_ROLE_ID — BIGINT — Primary key — NOT NULL
- CODE — VARCHAR(50)
- NAME — VARCHAR(200)
- DESCRIPTION — VARCHAR(500)
- NEW_ID — BIGINT
SYS_ROLE_MENU
- SYS_MENU_ID — BIGINT — Primary key — NOT NULL
- SYS_ROLE_ID — BIGINT — Foreign key → SYS_ROLE.SYS_ROLE_ID — NOT NULL
- IS_DEFAULT — BIGINT
- CREATED_DATE — TIMESTAMP
- CREATED_BY — VARCHAR(50)
- MODIFIED_DATE — TIMESTAMP
- MODIFIED_BY — VARCHAR(50)
SYS_ROLE_PERMISSION
- SYS_PERMISSION_ID — BIGINT — Foreign key → SYS_PERMISSION.SYS_PERMISSION_ID — NOT NULL
- SYS_ROLE_ID — BIGINT — Foreign key → SYS_ROLE.SYS_ROLE_ID — NOT NULL
- CREATED_DATE — TIMESTAMP
- CREATED_BY — VARCHAR(50)
- MODIFIED_DATE — TIMESTAMP
- MODIFIED_BY — VARCHAR(50)
SYS_ROLE_PERMISSION_GROUP
- SYS_ROLE_ID — BIGINT — Foreign key — NOT NULL
- SYS_PERMISSION_GROUP_ID — BIGINT — Foreign key → SYS_PERMISSION_GROUP.SYS_PERMISSION_GROUP_ID — NOT NULL
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
SYS_USER
- SYS_USER_ID — BIGINT — Primary key — NOT NULL
- EMPLOYEE_CODE — VARCHAR(100)
- USER_NAME — VARCHAR(100)
- FULL_NAME — VARCHAR(200)
- EMAIL — VARCHAR(200)
- STATUS — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
SYS_USER_PERMISSION
- SYS_USER_PERMISSION_ID — BIGINT — Primary key — NOT NULL
- EMPLOYEE_CODE — VARCHAR(100)
- SYS_PERMISSION_ID — BIGINT — Foreign key → SYS_PERMISSION.SYS_PERMISSION_ID — NOT NULL
SYS_USER_ROLE
- SYS_USER_ROLE_ID — BIGINT — Primary key — NOT NULL
- EMPLOYEE_CODE — VARCHAR(100)
- SYS_ROLE_ID — BIGINT — Foreign key → SYS_ROLE.SYS_ROLE_ID — NOT NULL
- IS_ACTIVE — TINYINT
- IS_ALLOW_GRANTED — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)
SYS_USER_ROLE_DATA
- DOMAIN_DATA_ID — BIGINT — Primary key — NOT NULL
- SYS_USER_ROLE_ID — BIGINT — Foreign key → SYS_USER_ROLE.SYS_USER_ROLE_ID — NOT NULL
- IS_DEFAULT — BIGINT
SYS_USER_ROLE_SCOPE
- SYS_USER_ROLE_ID — BIGINT — Foreign key — NOT NULL
- SYS_DATA_SCOPE_ID — BIGINT — Foreign key → SYS_DATA_SCOPE.SYS_DATA_SCOPE_ID — NOT NULL
- IS_DEFAULT — TINYINT
- CREATED_DATE — DATETIME
- CREATED_BY — VARCHAR(50)