- Thread Author
- #1
Breachachu | Telecommunications Regulatory Authority Database UAE [2024]
Telecommunications Regulatory Authority Database UAE [2024]
File Information
Format: SQL
Country: United Arab Emirates
Tables: 72
Columns: Up to 35+ per table
Tables Included
1. **users**: Stores user data, including roles, credentials, and statuses
- Columns: `id`, `name`, `last_name`, `email`, `mobile`, `password`, `is_super_admin`, `status`, etc.
2. **user_roles**: Maps user IDs to specific roles
- Columns: `id`, `user_id`, `role_id`, `created_at`, `updated_at`
3. **user_documents**: Tracks user-uploaded documents
- Columns: `id`, `user_id`, `document_type_id`, `expiry_date`, `status`, etc.
4. **strategy_plans**: Contains organizational strategic plans and associated KPIs
- Columns: `id`, `kpi_id`, `start_date`, `end_date`, `target_score`, etc.
5. **suppliers**: Information about suppliers registered with the TRA
- Columns: `id`, `title`, `address`, `email`, `industry_type_id`, `status`, etc.
6. **audit_closing_meeting_users**: Tracks user attendance for audit meetings
- Columns: `id`, `audit_id`, `user_id`, `is_present`, etc.
Unique Features
- Detailed user management system, including roles, competencies, and KPIs
- Integration of strategic plans with defined targets and outcomes
- Comprehensive supplier database for monitoring services and compliance
Potential Applications
- Manage and analyze user roles, documents, and competencies
- Track and evaluate organizational strategy and KPI performance
- Ensure compliance and supplier verification processes
Download:
Telecommunications Regulatory Authority Database UAE [2024]
File Information
Format: SQL
Country: United Arab Emirates
Tables: 72
Columns: Up to 35+ per table
Tables Included
1. **users**: Stores user data, including roles, credentials, and statuses
- Columns: `id`, `name`, `last_name`, `email`, `mobile`, `password`, `is_super_admin`, `status`, etc.
2. **user_roles**: Maps user IDs to specific roles
- Columns: `id`, `user_id`, `role_id`, `created_at`, `updated_at`
3. **user_documents**: Tracks user-uploaded documents
- Columns: `id`, `user_id`, `document_type_id`, `expiry_date`, `status`, etc.
4. **strategy_plans**: Contains organizational strategic plans and associated KPIs
- Columns: `id`, `kpi_id`, `start_date`, `end_date`, `target_score`, etc.
5. **suppliers**: Information about suppliers registered with the TRA
- Columns: `id`, `title`, `address`, `email`, `industry_type_id`, `status`, etc.
6. **audit_closing_meeting_users**: Tracks user attendance for audit meetings
- Columns: `id`, `audit_id`, `user_id`, `is_present`, etc.
Unique Features
- Detailed user management system, including roles, competencies, and KPIs
- Integration of strategic plans with defined targets and outcomes
- Comprehensive supplier database for monitoring services and compliance
Potential Applications
- Manage and analyze user roles, documents, and competencies
- Track and evaluate organizational strategy and KPI performance
- Ensure compliance and supplier verification processes
Download: