gambia.feste-ip.net / 127.0.0.1 / axiuss40_africa_patient_program_v2

There are no favorite tables.

New
axiuss40_africa
car_program
- car_program
- car_program_staging
illness_checker
- illness_checker
- illness_checker_staging
information_schema
mysql
performance_schema
school_management
task_manager
test

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		axiuss40_africa_patient_program_v2 alias_names
id : int(11)
medicine_id : int(11)
treatment_id : int(11)
title : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 ante_natal_cares
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 ask_price_to_pharmacies
id : int(11)
start_date : date
days : int(11)
months : int(11)
calculation_type : varchar(255)
medicine_id : int(11)
medicine_name : varchar(255)
total_transfer_amt : decimal(10,2)
current_stock : decimal(10,2)
drug_price_per_unit : decimal(10,2)
packing_size : decimal(10,2)
total_outgiving : decimal(10,2)
end_date : date
date : date

v		axiuss40_africa_patient_program_v2 available_drugs_saved_data
id : int(11)
date : date
days : int(11)
percentage : decimal(10,2)
calculation_type : varchar(255)
medicine_id : int(11)
medicine_name : varchar(255)
total_transfer_amt : decimal(10,2)
total_outgiving : decimal(10,2)
current_stock : decimal(10,2)
store_stock : decimal(10,2)
pharmacy_stock : decimal(10,2)
total_stock : decimal(10,2)
enough_months : decimal(10,2)
packing_size : decimal(10,2)
drug_price_per_unit : decimal(10,2)
created_at : datetime

v		axiuss40_africa_patient_program_v2 ci_sessions
id : varchar(40)
user_email : varchar(255)
ip_address : varchar(16)
user_agent : varchar(50)
timestamp : int(10) unsigned
data : mediumtext
browser : varchar(255)
version : varchar(255)
device : varchar(255)
platform : varchar(255)

v		axiuss40_africa_patient_program_v2 company_details
id : int(11)
name : varchar(255)
value : mediumtext
language_id : int(11)
addedOn : datetime
modifiedOn : datetime

v		axiuss40_africa_patient_program_v2 contents
id : int(11)
category_id : int(11)
title : varchar(255)
description : longtext
image : varchar(255)
status : int(11)
order_no : int(11)
deleted : int(11)
slug : varchar(255)
meta_title : varchar(255)
meta_key : varchar(255)
meta_description : varchar(255)
addedBy : int(11)
addedOn : datetime
modifiedOn : timestamp
modifiedBy : int(11)

v		axiuss40_africa_patient_program_v2 currencies
id : int(11)
name : varchar(255)
symbol : varchar(255)
exchange_rate : varchar(255)
status : varchar(10)
code : varchar(20)
exchange_rate_def : varchar(100)

v		axiuss40_africa_patient_program_v2 deliveries
id : int(11)
date : date
name_of_mother : varchar(255)
age_of_mother : int(11)
phone_no : varchar(255)
nationality : varchar(255)
village_id : int(11)
tribe_id : int(11)
ante_natal_care_ids : varchar(255)
post_natal_care_ids : varchar(255)
baby_number : int(11)
baby_gender : varchar(255)
baby_length : float
baby_weight : float
delivery_type : varchar(255)
is_multiple_birth : int(11)
multiple_birth_count : varchar(255)
newborn_condition : varchar(255)
employee_id : int(11)
is_bad_handwriting : int(11)
is_scanned_document : int(11)
is_verification_needed : int(11)
verification_text : varchar(255)
checked : int(11)
document_file : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 delivery_ante_natal_cares
delivery_id : int(11)
ante_natal_care_id : int(11)
sort_order : smallint(5) unsigned

v		axiuss40_africa_patient_program_v2 delivery_post_natal_cares
delivery_id : int(11)
post_natal_care_id : int(11)
sort_order : smallint(5) unsigned

v		axiuss40_africa_patient_program_v2 drugstores
id : int(11)
title : varchar(255)
checked : int(11)
small_pharamacy : int(11)
isDispensePharmacy : int(11)
isOutsideStore : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_inventories
id : int(11)
batch_id : int(11)
store_id : int(11)
medicine_id : int(11)
date : date
calculated : int(11)
counted : int(11)
expired : int(11)
available : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_purchases
id : int(11)
drug_store_id : int(11)
date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_purchase_files
id : int(11)
drug_store_id : int(11)
pharmacy_id : int(11)
date : date
file : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_purchase_items
id : int(11)
drugs_purchase_id : int(11)
drug_store_id : int(11)
medicine_id : int(11)
pharmacy_id : int(11)
quantity : int(11)
final_qty : int(11)
price : decimal(10,2)
date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_quotations
id : int(11)
drugs_quotation_date_id : int(11)
pharamacy_ids : varchar(255)
medicine_id : int(11)
quantity : int(11)
final_quantity : int(11)
checked : int(11)
price_per_qty : decimal(10,2)
quotation_date : date
price : decimal(10,2)
choose_pharmacy : int(11)
is_approved : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_quotation_dates
id : int(11)
drug_store_id : int(11)
date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_quotation_files
id : int(11)
drug_store_id : int(11)
pharmacy_id : int(11)
date : date
file : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_total_count
id : int(11)
drug_store_id : int(11)
medicine_id : int(11)
total : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drugs_transfers
id : int(11)
from_store : int(11)
to_store : int(11)
document : varchar(155)
transfer_date : date
DateOfReceipt : datetime
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp
done_by : varchar(255)
entered_by : varchar(255)
is_confirm : int(11)
confirm_file_name : varchar(255)

v		axiuss40_africa_patient_program_v2 drugs_transfers_medicine_details
id : int(11)
drug_transfer_id : int(11)
from_store_id : int(11)
to_store_id : int(11)
medicine_id : int(11)
amount : int(11)
transfer_date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 drug_inventory_batches
id : int(11)
store_id : int(11)
date : date
file_name : varchar(255)
addedBy : int(11)
addedOn : datetime
status : int(11)
deleted : int(11)
done_by : varchar(255)
entered_by : varchar(255)
is_confirm : int(11)
confirm_file_name : varchar(255)

v		axiuss40_africa_patient_program_v2 email_templates
id : int(10) unsigned
name : varchar(255)
email_template_key : varchar(255)
email_from : varchar(50)
email_subject : longtext
content : longtext
content_cn : longtext
email_subject_cn : varchar(255)
variables : longtext
sms_template : longtext
sms_send_status : enum('0','1')
status : tinyint(1)
modifiedDate : datetime
createdDate : datetime
addedBy : int(11)
modifiedBy : int(11)

v		axiuss40_africa_patient_program_v2 employees
id : int(11)
first_name : varchar(255)
sur_name : varchar(155)
employee_role_id : int(11)
email : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 employee_roles
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 family_planning_new_acceptors
family_planning_service_id : int(11)
new_acceptor_id : int(11)
sort_order : smallint(5) unsigned

v		axiuss40_africa_patient_program_v2 family_planning_revisits
family_planning_service_id : int(11)
revisit_id : int(11)
sort_order : smallint(5) unsigned

v		axiuss40_africa_patient_program_v2 family_planning_services
id : int(11)
date : date
name_of_patient : varchar(255)
age_of_patient : int(11)
phone_no : varchar(255)
gender : varchar(255)
nationality : varchar(255)
village_id : int(11)
tribe_id : int(11)
new_acceptor_ids : varchar(255)
revisit_ids : varchar(255)
employee_id : int(11)
is_counselled_only : int(11)
is_bad_handwriting : int(11)
is_scanned_document : int(11)
is_verification_needed : int(11)
verification_text : varchar(255)
checked : int(11)
document_file : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 folders
id : int(11)
parent_id : int(11)
name : varchar(255)
date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 folder_files
id : int(11)
folder_id : int(11)
file_original_name : varchar(255)
file_name : varchar(255)
user_id : int(11)
file_size : int(11)
extension : varchar(10)
type : varchar(15)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
deleted : int(11)
status : int(11)

v		axiuss40_africa_patient_program_v2 governmental_statistics_settings
id : int(11)
Name : text
ShortName : text
IsEnabledIllnesses : tinyint(4)
IllnessIdsStr : text
IsEnabledTreatments : tinyint(4)
TreatmentsIdsStr : text
UseAgeSettings : tinyint(4)
AgeType : int(11)
AgeFromOver : int(11)
FromAgeYears : int(11)
TillAgeYears : int(11)
UnderYears : int(11)
OverYears : int(11)
PatientTypeForStat : int(11)
UseReasonForDismissal : tinyint(4)
IsReferral : tinyint(4)
IsDeath : tinyint(4)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : datetime
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 illnesses
id : int(11)
title : varchar(255)
checked : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 illnesses_dosages
id : int(11)
treatment_id : int(11)
illness_id : int(11)
age : varchar(155)
age_from : varchar(155)
age_till : varchar(155)
duration_per_days : varchar(155)
duration_in_days : varchar(155)
total : varchar(155)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 item_categories
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 lab_types
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 languages
id : tinyint(4)
name : varchar(255)
short_form : varchar(20)
language_code : varchar(20)
text_direction : varchar(10)
status : tinyint(1)
deleted : int(11)
language_order : tinyint(4)
text_editor_lang : varchar(10)
flag_path : varchar(255)

v		axiuss40_africa_patient_program_v2 location_cities
id : mediumint(8) unsigned
name : varchar(255)
state_id : mediumint(8) unsigned
state_code : varchar(255)
country_id : mediumint(8) unsigned
country_code : char(2)
latitude : decimal(10,8)
longitude : decimal(11,8)
created_at : timestamp
updated_at : timestamp
flag : tinyint(1)
wikiDataId : varchar(255)

v		axiuss40_africa_patient_program_v2 location_countries
id : mediumint(8) unsigned
name : varchar(100)
iso3 : char(3)
iso2 : char(2)
phonecode : varchar(255)
capital : varchar(255)
currency : varchar(255)
currency_symbol : varchar(255)
tld : varchar(255)
native : varchar(255)
region : varchar(255)
subregion : varchar(255)
timezones : text
translations : text
latitude : decimal(10,8)
longitude : decimal(11,8)
emoji : varchar(191)
emojiU : varchar(191)
created_at : timestamp
updated_at : timestamp
status : tinyint(1)
wikiDataId : varchar(255)

v		axiuss40_africa_patient_program_v2 location_states
id : mediumint(8) unsigned
name : varchar(255)
country_id : mediumint(8) unsigned
country_code : char(2)
fips_code : varchar(255)
iso2 : varchar(255)
latitude : decimal(10,8)
longitude : decimal(11,8)
created_at : timestamp
updated_at : timestamp
flag : tinyint(1)
wikiDataId : varchar(255)

v		axiuss40_africa_patient_program_v2 location_villages
id : int(11)
name : varchar(255)
distance : float
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 login_attempts
id : int(10) unsigned
ip_address : varchar(45)
login : varchar(100)
time : int(10) unsigned

v		axiuss40_africa_patient_program_v2 login_records
id : int(11)
session_id : varchar(255)
user_email : varchar(255)
ip_address : varchar(16)
user_agent : varchar(50)
login_time : int(10) unsigned
logout_time : int(11)
browser : varchar(255)
version : varchar(255)
device : varchar(255)
platform : varchar(255)
mac_id : varchar(255)
modifiedOn : timestamp
user_id : int(11)

v		axiuss40_africa_patient_program_v2 medicines
id : int(11)
name : mediumtext
medicine_pack_type_id : int(11)
packing_size : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp
category_type : varchar(255)
monthly_required_quantity : int(11)

v		axiuss40_africa_patient_program_v2 medicine_pack_types
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 medicine_types
id : int(11)
title : varchar(50)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : timestamp
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 modules
id : int(11)
section : varchar(255)
name : varchar(100)
lang_names : longtext
alias : varchar(100)
order_no : float
is_url : int(11)
url : varchar(255)
parent_id : int(11)
description : longtext
icon : varchar(255)
permissions : varchar(255)
is_public : int(11)
addedBy : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
modifiedOn : timestamp
modifiedBy : varchar(100)

v		axiuss40_africa_patient_program_v2 new_acceptors
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 outside_purchase_drugs
id : int(11)
document : varchar(155)
transfer_date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 outside_purchase_drugs_details
id : int(11)
outside_purchase_drug_id : int(11)
medicine_id : int(11)
quantity : int(11)
price : int(11)
pharmacy_id : int(11)
transfer_date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 patient_files
id : int(11)
patient_file_folder_id : int(11)
patient_property_id : int(11)
file_orginal_name : varchar(255)
file_name : varchar(255)
file_size : varchar(255)
file_path : varchar(255)
extension : varchar(255)
type : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 patient_file_assigns
id : int(11)
patient_file_id : int(11)
user_id : int(11)
addedOn : timestamp

v		axiuss40_africa_patient_program_v2 patient_file_folders
id : int(11)
folder_name : varchar(255)
folder_path : varchar(255)
modifiedBy : int(11)
modifiedOn : timestamp
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)

v		axiuss40_africa_patient_program_v2 patient_numbers
id : int(11)
start_number : int(11)
end_number : int(11)
addedBy : int(11)
addedOn : datetime
modifiedBy : int(11)
modifiedOn : timestamp
date : date

v		axiuss40_africa_patient_program_v2 patient_properties
id : int(11)
time : time
date : date
patientNumber : int(11)
phone_no : varchar(255)
year : int(11)
month : int(11)
gender : varchar(255)
nationality : varchar(255)
village_id : int(11)
bpTop : int(11)
bpBottom : int(11)
temperature : decimal(10,2)
pulse : int(11)
illness_ids : varchar(255)
medicine_ids : varchar(255)
patientStatus : varchar(255)
patientType : varchar(255)
patientStatusForInpatient : int(11)
dateOfAdmission : date
dateOfDischarge : date
reasonOfDismisal : varchar(255)
HBResult : mediumtext
BFResult : mediumtext
WBCResult : mediumtext
UrineResult : mediumtext
BMResult : mediumtext
VDRLResult : mediumtext
HCGResult : mediumtext
SickleCellsResult : mediumtext
AFBResult : mediumtext
CustomResultName : mediumtext
CustomResult : mediumtext
badDocStatus : int(11)
employee_id : int(11)
is_bad_handwriting : int(11)
is_scanned_document : int(11)
is_verification_needed : int(11)
verification_text : varchar(255)
document_file : varchar(255)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : datetime
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 patient_property_illnesses
patient_property_id : int(11)
illness_id : int(11)

v		axiuss40_africa_patient_program_v2 patient_property_medicines
patient_property_id : int(11)
medicine_id : int(11)

v		axiuss40_africa_patient_program_v2 patient_property_tratment_details
id : int(11)
medicine_id : int(11)
per_day : int(11)
times : decimal(10,1)
total : decimal(10,1)
patient_property_item_id : int(11)

v		axiuss40_africa_patient_program_v2 patient_property_urine_lab_test_results
id : int(11)
urine_lab_test_type_id : int(11)
result : text
patient_property_item_id : int(11)

v		axiuss40_africa_patient_program_v2 pharmacies
id : int(11)
priority : int(11)
name : varchar(255)
address : varchar(255)
phone : varchar(255)
email : varchar(255)
contact_person_name : varchar(255)
contact_person_phone : varchar(255)
contact_person_email : varchar(255)
bank_name : varchar(255)
bank_account : varchar(255)
bank_iban : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 post_natal_cares
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 prices
id : int(11)
date : date
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 price_details
id : int(11)
price_id : int(11)
name : varchar(255)
type : varchar(255)
lab_type_id : int(11)
age_from : int(11)
age_till : int(11)
gambians_price : float
non_gambians_price : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 reports_dates
id : int(11)
user_id : int(11)
from_date : date
to_date : date

v		axiuss40_africa_patient_program_v2 report_word
id : int(11)
text : longtext
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 revisits
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 roles
id : int(11)
parent_id : int(11)
name : varchar(255)
description : varchar(255)
modifiedBy : varchar(16)
deleted : int(11)
addedBy : varchar(255)
addedOn : datetime
modifiedOn : timestamp
status : int(11)

v		axiuss40_africa_patient_program_v2 role_permissions
id : int(11)
role_id : int(11)
module_id : int(11)
parent_module_id : int(11)
section : varchar(255)
permission_add : int(11)
permission_edit : int(11)
permission_view : int(11)
permission_delete : int(11)
permission_status : int(11)
addedBy : int(11)
addedOn : datetime
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 settings
id : int(11)
name : varchar(255)
value : mediumtext
language_id : int(11)
addedOn : datetime
modifiedOn : datetime

v		axiuss40_africa_patient_program_v2 treatments
id : int(11)
medicine_id : int(11)
packsize : varchar(155)
form : varchar(155)
strength : varchar(155)
strength_in : varchar(155)
male : varchar(155)
female : varchar(155)
breast_feeding : varchar(155)
pregnant : varchar(155)
from_month : varchar(155)
till_month : varchar(155)
only_kids : varchar(155)
kid_year_from : varchar(155)
kid_month_from : varchar(155)
kid_year_till : varchar(155)
kid_month_till : varchar(155)
belongs_to : int(11)
alias_names : varchar(155)
illnesses : varchar(155)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp
max_dosage : int(11)

v		axiuss40_africa_patient_program_v2 treatment_forms
id : int(11)
name : varchar(50)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : timestamp
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 treatment_illnesses
id : int(11)
treatment_id : int(11)
illness : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 treatment_ins
id : int(11)
name : varchar(50)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : timestamp
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 tribes
id : int(11)
name : varchar(255)
checked : int(11)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 uploads
id : int(11)
file_original_name : varchar(255)
file_name : varchar(255)
user_id : int(11)
file_size : int(11)
extension : varchar(10)
type : varchar(15)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		axiuss40_africa_patient_program_v2 urine_lab_test_types
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 users
id : int(11)
parent_id : int(11)
role_ids : varchar(255)
login_id : varchar(255)
password : varchar(255)
is_online : int(11)
is_verified : int(11)
is_admin_verified : int(11)
is_first_login : int(11)
otp : varchar(255)
device_type : varchar(255)
ios_device_id : varchar(255)
android_device_id : varchar(255)
web_token : longtext
login_type : varchar(255)
addedOn : datetime
modifiedOn : timestamp
addedBy : varchar(255)
modifiedBy : varchar(255)
status : int(11)
deleted : int(11)
login_language : text

v		axiuss40_africa_patient_program_v2 user_address_books
id : int(11)
user_id : int(11)
is_favourite : int(11)
name : varchar(255)
phone_no : varchar(255)
address : varchar(255)
area : varchar(255)
lat : varchar(255)
lng : varchar(255)
address_type : varchar(255)
is_gift : int(11)
status : int(11)
deleted : int(11)
addedBy : int(11)
modifiedBy : int(11)
addedOn : datetime
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 user_profiles
id : int(11)
parent_id : int(11)
user_id : int(11)
full_name : varchar(255)
fname : varchar(255)
lname : varchar(255)
email : varchar(255)
phone_code : varchar(255)
phone_no : varchar(255)
profile_image : varchar(255)
gender : varchar(16)
dob : date
about : longtext
landmark : varchar(255)
address : varchar(255)
lat : varchar(255)
lng : varchar(255)
state_id : varchar(16)
country_id : varchar(255)
city_id : varchar(255)
pincode : varchar(255)
addedOn : datetime
modifiedOn : timestamp
modifiedBy : varchar(255)

v		axiuss40_africa_patient_program_v2 user_schedules
id : int(11)
user_id : int(11)
day : int(11)
day_name : varchar(255)
time_from : time
time_to : time
type : varchar(255)
modifiedOn : timestamp

v		axiuss40_africa_patient_program_v2 user_settings
id : int(11)
user_id : int(11)
time_zone : varchar(255)
language_id : int(11)
multifactor_authenticate : int(11)
google_auth_code : varchar(255)
authenticate_using_otp : int(11)
otp_phone : varchar(255)
otp : varchar(255)
authenticate_using_google : int(11)
modifiedOn : timestamp
modifiedBy : int(11)

v		axiuss40_africa_patient_program_v2 warehouses
id : int(11)
name : varchar(255)
status : int(11)
deleted : int(11)
addedOn : datetime
addedBy : int(11)
modifiedBy : int(11)
modifiedOn : timestamp

Create relationship
FOREIGN KEY
on delete
on update