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