Database Structure Manager
Data queries disabled. Structure management only.
Tables
Table
Actions
ad_campaigns
Drop
ad_requests
Drop
admin_salary
Drop
admins
Drop
ads_logs
Drop
all_employees_unified
Drop
approval_log
Drop
attendance_correction_requests
Drop
attendance_requests
Drop
bug_comments
Drop
bug_projects
Drop
bugs
Drop
campaign_completion
Drop
campaign_updates
Drop
client_progress
Drop
clients
Drop
crew_project_achievement_map
Drop
crew_project_actions
Drop
crew_project_counter
Drop
crew_project_files
Drop
crew_projects
Drop
demo_users
Drop
design_attendance_requests
Drop
design_behavior_kpi
Drop
design_behaviour_kpi
Drop
design_employee_attendance
Drop
design_employee_entry_times
Drop
design_employee_halfday
Drop
design_employee_late_log
Drop
design_employee_leave_requests
Drop
design_employees
Drop
design_employees_login_logs
Drop
design_employees_logout_logs
Drop
design_entry_time_overrides
Drop
design_entry_time_permanent
Drop
design_leave_messages
Drop
design_manager_entry_time_overrides
Drop
design_manager_entry_time_permanent
Drop
design_manager_halfday
Drop
design_manager_late_log
Drop
design_manager_leave_messages
Drop
design_manager_leaves
Drop
design_objective_kpi
Drop
design_payment_history
Drop
design_proj
Drop
design_quality_kpi
Drop
designer_files
Drop
designer_kpi
Drop
designer_task_edit_logs
Drop
designer_task_file_logs
Drop
designer_task_files
Drop
designer_task_revisions
Drop
designer_tasks
Drop
dev_proj
Drop
dev_project_assets
Drop
dev_project_assignments
Drop
dev_project_status_logs
Drop
dev_project_tasks
Drop
dev_projects
Drop
dev_team_members
Drop
development_attendance_requests
Drop
development_employee_attendance
Drop
development_employee_entry_times
Drop
development_employee_halfday
Drop
development_employee_late_log
Drop
development_employee_leave_requests
Drop
development_employees
Drop
development_employees_login_logs
Drop
development_employees_logout_logs
Drop
development_entry_time_overrides
Drop
development_entry_time_permanent
Drop
development_leave_messages
Drop
development_manager_entry_time_overrides
Drop
development_manager_entry_time_permanent
Drop
development_manager_halfday
Drop
development_manager_late_log
Drop
development_manager_leave_messages
Drop
development_manager_leaves
Drop
development_tasks
Drop
device_challenges
Drop
device_security_logs
Drop
employee_devices
Drop
employee_individual_targets
Drop
employee_leave_requests
Drop
employee_shift_settings
Drop
employee_targets
Drop
exchange_rates
Drop
expense_categories
Drop
expenses
Drop
hr_login_logs
Drop
hr_manager
Drop
invoice_counter
Drop
invoice_custom_fields
Drop
invoice_extra_charges
Drop
invoice_items
Drop
invoice_payments
Drop
invoice_sections
Drop
invoice_settings
Drop
invoice_templates
Drop
invoices
Drop
jg_invoices
Drop
jg_team_members
Drop
jg_team_target_history
Drop
jg_teams_sales
Drop
jg_v_member_payments
Drop
jgsu_team_logs
Drop
jgsu_team_members
Drop
jgsu_team_targets
Drop
jgsu_teams
Drop
kpi_attendance
Drop
kpi_behavior
Drop
kpi_project
Drop
kpi_punctuality
Drop
leave_messages
Drop
mail_accounts
Drop
mail_preferences
Drop
manager1_attendance
Drop
manager2_attendance
Drop
manager3_attendance
Drop
manager4_attendance
Drop
manager_attendance
Drop
manager_attendance_requests
Drop
manager_login_logs
Drop
manager_pending_tasks
Drop
managers
Drop
marketing_ads_audit_log
Drop
marketing_ads_daily
Drop
marketing_ads_proofs
Drop
marketing_behaviour_kpi
Drop
marketing_campaign_budgets
Drop
marketing_campaigns
Drop
marketing_conversions
Drop
marketing_employee_attendance
Drop
marketing_employee_entry_times
Drop
marketing_employee_halfday
Drop
marketing_employee_late_log
Drop
marketing_employee_leave_requests
Drop
marketing_employees
Drop
marketing_employees_login_logs
Drop
marketing_employees_logout_logs
Drop
marketing_entry_time_overrides
Drop
marketing_entry_time_permanent
Drop
marketing_kpi_monthly
Drop
marketing_lead_contacts
Drop
marketing_leads
Drop
marketing_manager_entry_time_overrides
Drop
marketing_manager_entry_time_permanent
Drop
marketing_manager_halfday
Drop
marketing_manager_late_log
Drop
marketing_manager_leave_messages
Drop
marketing_manager_leaves
Drop
marketing_monthly_budget
Drop
marketing_whatsapp_logs
Drop
member_monthly_archive
Drop
member_sales_detail
Drop
monthly_budget
Drop
monthly_targets
Drop
payment_records
Drop
project_achievement_map
Drop
project_actions
Drop
project_counter
Drop
project_files
Drop
projects
Drop
salary_records
Drop
sale_quality_kpi
Drop
sales_behavior_kpi
Drop
sales_behaviour_kpi
Drop
sales_crew_employee_attendance
Drop
sales_crew_employee_entry_times
Drop
sales_crew_employee_late_log
Drop
sales_crew_employees
Drop
sales_crew_employees_login_logs
Drop
sales_crew_employees_logout_logs
Drop
sales_crew_entry_time_overrides
Drop
sales_crew_entry_time_permanent
Drop
sales_employee_attendance
Drop
sales_employee_entry_times
Drop
sales_employee_late_log
Drop
sales_employees
Drop
sales_employees_login_logs
Drop
sales_employees_logout_logs
Drop
sales_entry_time_overrides
Drop
sales_entry_time_permanent
Drop
sales_manager_entry_time_overrides
Drop
sales_manager_entry_time_permanent
Drop
sales_manager_halfday
Drop
sales_manager_late_log
Drop
sales_manager_leave_messages
Drop
sales_manager_leaves
Drop
sales_objective_kpi
Drop
sales_quality_kpi
Drop
sales_quality_kpi_config
Drop
sales_targets
Drop
target_history
Drop
task_activity_logs
Drop
task_attachments
Drop
task_edit_logs
Drop
team_member_targets
Drop
team_member_transfers
Drop
team_members
Drop
team_monthly_archive
Drop
team_monthly_targets
Drop
team_payment_breakdown
Drop
team_sales_summary
Drop
team_shuffle_logs
Drop
teams
Drop
teams_deleted_archive
Drop
teams_deleted_members_archive
Drop
teams_sales
Drop
v_design_entry_time
Drop
v_development_entry_time
Drop
v_marketing_entry_time
Drop
v_sales_entry_time
Drop
video_task_updates
Drop
video_tasks
Drop
Create New Table
Create
Table: marketing_manager_leave_messages
Columns
Run SQL
Columns
Column
Type
Actions
id
int(11)
Drop
leave_id
int(11)
Drop
department
varchar(50)
Drop
sender
enum('Manager','HR')
Drop
message
varchar(25)
Drop
created_at
datetime
Drop
Add Column
Add
Modify Column
Update
Run SQL (structure only)
Run Query
Allowed only: ALTER, CREATE, DROP, TRUNCATE, RENAME