author

Tables (14)

account

  • account_id — varchar(50) — Primary key — NOT NULL
  • identity_no — varchar(20) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • email — varchar(255)
  • full_name — varchar(255) — NOT NULL
  • phone_number — varchar(50) — NOT NULL
  • org_id — varchar(50)
  • birth_date — date
  • is_active — tinyint(4) — NOT NULL
  • is_locked — tinyint(4) — NOT NULL
  • lock_reason — mediumtext
  • created_by — varchar(50) — NOT NULL
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • description — varchar(255)
  • is_admin_portal — tinyint(4)
  • sub — varchar(50) — OIDC subject cua IdP, bat bien

account_role

  • account_role_id — varchar(50) — Primary key — NOT NULL
  • account_id — varchar(50) — NOT NULL
  • organization_id — varchar(50)
  • app_id — varchar(50) — NOT NULL
  • is_active — tinyint(4) — NOT NULL
  • created_by — varchar(50) — NOT NULL
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • tree_code — varchar(255)
  • role_id (role_id2) — varchar(50) — Foreign key → role.role_id — NOT NULL
  • account_id (account_id2) — varchar(50) — Foreign key → account.account_id — NOT NULL

account_scope

  • account_scope_id — varchar(50) — Primary key — NOT NULL
  • account_id — varchar(50) — NOT NULL
  • organization_id — varchar(50)
  • app_id — varchar(50) — NOT NULL
  • is_active — tinyint(4) — NOT NULL
  • created_by — varchar(50) — NOT NULL
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • tree_code — varchar(255)
  • account_id (account_id2) — varchar(50) — Foreign key → account.account_id — NOT NULL

account_scope_role

  • account_scope_role_id — varchar(50) — Primary key — NOT NULL
  • account_scope_id — varchar(50)
  • role_id — varchar(50)
  • is_active — int(11)
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • role_id (role_id2) — varchar(50) — Foreign key → role.role_id — NOT NULL
  • account_scope_id (account_scope_id2) — varchar(50) — Foreign key → account_scope.account_scope_id — NOT NULL

action (Untitled)

  • action_id — varchar(50) — Primary key — NOT NULL
  • action_code — varchar(50)
  • name — varchar(50) — view||edit||add||delete

application

  • app_id — varchar(50) — Primary key — NOT NULL
  • app_code — varchar(100)
  • app_name — varchar(255)
  • description — mediumtext
  • is_active — tinyint(1) — NOT NULL
  • is_locked — tinyint(1) — NOT NULL
  • version — varchar(50)
  • version_info — varchar(500)
  • api_key — varchar(100)
  • icon — varchar(500)
  • created_by — varchar(50) — NOT NULL
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

menu_action (Untitled2)

  • menu_action_id — Primary key — NOT NULL
  • action_id — varchar(50) — Foreign key → action.action_id — NOT NULL
  • menu_config_id — varchar(50) — Foreign key → menu_config.menu_config_id — NOT NULL

menu_config

  • menu_config_id — varchar(50) — Primary key — NOT NULL
  • menu_code — varchar(255)
  • menu_name — varchar(255)
  • url — varchar(255)
  • menu_order — int(11)
  • last_modified_date — timestamp
  • application_id — varchar(50)
  • parent_id — varchar(50)
  • description — varchar(1000)
  • icon_menu — varchar(255)
  • status — tinyint(4)
  • is_active — tinyint(4)
  • org_id — varchar(50)
  • manage_department — varchar(50)
  • created_by — varchar(255)
  • created_date — timestamp
  • last_modified_by — varchar(255)
  • is_lock — tinyint(4)
  • visible — tinyint(4)
  • modified_date — timestamp
  • modified_by — varchar(255)

menu_policy

  • menu_policy_id — varchar(50) — Primary key — NOT NULL
  • role_id — varchar(50) — Foreign key → role.role_id — NOT NULL
  • menu_id (menu_config_id) — varchar(50) — Foreign key → menu_config.menu_config_id — NOT NULL — menu_config_id
  • org_id — varchar(50)
  • user_id — varchar(50)
  • processing_logic — tinyint(4)
  • is_active — tinyint(4)
  • created_by — varchar(255)
  • created_date — timestamp
  • modified_by — varchar(255)
  • modified_date — timestamp
  • policy_type — tinyint(4)
  • last_modified_by — varchar(255)
  • last_modified_date — timestamp

menu_policy_resource

  • menu_policy_resource_id — varchar(50) — Primary key — NOT NULL
  • menu_policy_id (menu_policy_id2) — varchar(50) — Foreign key → menu_policy.menu_policy_id — NOT NULL
  • role_id (role_id2) — varchar(50) — Foreign key → menu_policy.role_id — NOT NULL
  • resource_id — varchar(50)
  • is_active — tinyint(4)
  • created_by — varchar(255)
  • created_date — timestamp
  • modified_by — varchar(255)
  • modified_date — timestamp
  • last_modified_by — varchar(255)
  • last_modified_date — timestamp

menu_resource

  • menu_resource_id — varchar(50) — Primary key — NOT NULL
  • resource_id (resource_id2) — varchar(50) — Foreign key → resources.resource_id — NOT NULL
  • menu_id (menu_config_id) — varchar(50) — Foreign key → menu_config.menu_config_id — NOT NULL — menu_config_id
  • is_active — tinyint(4)
  • created_by — varchar(255)
  • created_date — timestamp
  • modified_by — varchar(255)
  • modified_date — timestamp
  • last_modified_by — varchar(255)
  • last_modified_date — timestamp

resources

  • resource_id — varchar(50) — Primary key — NOT NULL
  • menu_action_id — Foreign key → menu_action.menu_action_id — NOT NULL
  • menu_config_id — varchar(50) — Foreign key → menu_action.menu_config_id — NOT NULL
  • action_id (action_id2) — varchar(50) — Foreign key → menu_action.action_id — NOT NULL
  • resource_order — int(11)
  • status — int(11)
  • type — int(11)
  • type_ui — int(11)
  • created_date — timestamp
  • last_modified_date — timestamp
  • parent_id — varchar(50)
  • created_by — varchar(255) — NOT NULL
  • last_modified_by — varchar(255)
  • description — varchar(1000)
  • icon_menu — varchar(255)
  • resource_code — varchar(255)
  • resource_name — varchar(255)
  • url — varchar(255)
  • is_active — tinyint(4)
  • org_id — varchar(50)
  • manage_department — varchar(50)
  • modified_date — timestamp
  • modified_by — varchar(255)
  • is_lock — int(11)
  • method — varchar(10)
  • application_id — varchar(50)

role

  • role_id — varchar(50) — Primary key — NOT NULL
  • role_name — varchar(200) — NOT NULL
  • role_code — varchar(50) — NOT NULL
  • level — int(11)
  • description — text
  • is_lock — tinyint(4)
  • is_active — tinyint(4)
  • is_admin — tinyint(4)
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • app_id — varchar(50) — NOT NULL
  • can_self_assign — int(11)
  • tenant_id — varchar(255)
  • org_id — varchar(50)
  • manage_department — varchar(255)
  • modified_by — varchar(255)
  • modified_date — timestamp
  • status — tinyint(4)
  • role_level — varchar(255)

role_menu_action (Untitled3)

  • menu_action_id — Foreign key → menu_action.menu_action_id — NOT NULL
  • action_id — varchar(50) — Foreign key → menu_action.action_id — NOT NULL
  • menu_config_id — varchar(50) — Foreign key → menu_action.menu_config_id — NOT NULL
  • role_id — varchar(50) — Foreign key → role.role_id — NOT NULL