abcd

Tables (10)

SYS_ACTION

  • SYS_ACTION_ID — BIGINT — Primary key — NOT NULL
  • CODE — VARCHAR(50)
  • NAME — VARCHAR(200)
  • DESCRIPTION — VARCHAR(500)

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 → SYS_PERMISSION.SYS_PERMISSION_ID — 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
  • STATUS — TINYINT
  • CREATED_DATE — DATETIME
  • CREATED_BY — VARCHAR(50)
  • MODIFIED_DATE — DATETIME
  • MODIFIED_BY — VARCHAR(50)

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 — TINYINT
  • CREATED_DATE — TIMESTAMP
  • CREATED_BY — VARCHAR(50)
  • MODIFIED_DATE — TIMESTAMP
  • MODIFIED_BY — VARCHAR(50)

SYS_ROLE_PERMISSION_GROUP

  • SYS_ROLE_ID — BIGINT — Foreign key → SYS_ROLE.SYS_ROLE_ID — 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_ROLE

  • SYS_USER_ROLE_ID — BIGINT — Primary key — NOT NULL
  • SYS_USER_ID — BIGINT — Foreign key → SYS_USER.SYS_USER_ID
  • 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)