Recent
`axiuss40_africa_money_program`.`uploads`
`axiuss40_africa_patient_program_bk`.`treatment_classifications`
`axiuss40_africa_patient_program_bk`.`prices`
`axiuss40_africa_money_program`.`booking_histories`
`axiuss40_africa_patient_program_bk`.`employees`
`axiuss40_africa_money_program`.`user_schedules`
`axiuss40_africa_money_program`.`login_records`
`axiuss40_africa_money_program`.`booking_materials`
`axiuss40_africa_patient_program_bk`.`treatment_application_aliases`
`axiuss40_africa_patient_program_bk`.`plan_inventorys`
Favorites
There are no favorite tables.
New
axiuss40_africa
charity_program
axiuss40_africa_charity_program
axiuss40_africa_charity_program_staging
money_program
axiuss40_africa_money_program
axiuss40_africa_money_program_bk
axiuss40_africa_money_program_private
axiuss40_africa_money_program_private_german
axiuss40_africa_money_program_rdi
axiuss40_africa_money_program_staging
patient_program
axiuss40_africa_patient_program
axiuss40_africa_patient_program_bk
axiuss40_africa_patient_program_staging
axiuss40_africa_patient_program_staging_old
personal_program
axiuss40_africa_personal_program
axiuss40_africa_personal_program_bk
axiuss40_africa_personal_program_school
axiuss40_africa_personal_program_staging
information_schema
mysql
performance_schema
task_manager
task_manager
task_manager_staging
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: axiuss40_africa_charity_program
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`currency_id`
`accounts`.`balance`
`accounts`.`activation_date`
`accounts`.`is_bank_statement_available`
`accounts`.`account_type`
`accounts`.`is_obsolute_account`
`accounts`.`iban`
`accounts`.`bank_name`
`accounts`.`status`
`accounts`.`deleted`
`accounts`.`addedOn`
`accounts`.`addedBy`
`accounts`.`modifiedBy`
`accounts`.`modifiedOn`
`anreden_salutation`.*
`anreden_salutation`.`id`
`anreden_salutation`.`Bezeichnung_Designation`
`anreden_salutation`.`Gender`
`anreden_salutation`.`Category`
`anreden_salutation`.`status`
`anreden_salutation`.`deleted`
`anreden_salutation`.`addedOn`
`anreden_salutation`.`addedBy`
`anreden_salutation`.`modifiedBy`
`anreden_salutation`.`modifiedOn`
`bank_statements`.*
`bank_statements`.`id`
`bank_statements`.`account_id`
`bank_statements`.`name`
`bank_statements`.`date_from`
`bank_statements`.`date_to`
`bank_statements`.`incoming_balance`
`bank_statements`.`outgoing_balance`
`bank_statements`.`document_file_ext`
`bank_statements`.`document_file`
`bank_statements`.`status`
`bank_statements`.`deleted`
`bank_statements`.`addedOn`
`bank_statements`.`addedBy`
`bank_statements`.`modifiedBy`
`bank_statements`.`modifiedOn`
`banks_for_check`.*
`banks_for_check`.`id`
`banks_for_check`.`BLZ`
`banks_for_check`.`Name`
`banks_for_check`.`Address`
`banks_for_check`.`Name1`
`banks_for_check`.`BIC`
`banks_for_check`.`status`
`banks_for_check`.`deleted`
`banks_for_check`.`addedOn`
`banks_for_check`.`addedBy`
`banks_for_check`.`modifiedBy`
`banks_for_check`.`modifiedOn`
`bereiche_areas`.*
`bereiche_areas`.`id`
`bereiche_areas`.`Bezeichnung_Designation`
`bereiche_areas`.`SortIndex`
`bereiche_areas`.`status`
`bereiche_areas`.`deleted`
`bereiche_areas`.`addedOn`
`bereiche_areas`.`addedBy`
`bereiche_areas`.`modifiedBy`
`bereiche_areas`.`modifiedOn`
`booking_histories`.*
`booking_histories`.`id`
`booking_histories`.`booking_id`
`booking_histories`.`action`
`booking_histories`.`account_id`
`booking_histories`.`transfer_account_id`
`booking_histories`.`type`
`booking_histories`.`number`
`booking_histories`.`date`
`booking_histories`.`payee`
`booking_histories`.`amount`
`booking_histories`.`category_id`
`booking_histories`.`sub_category_id`
`booking_histories`.`sub_sub_category_id`
`booking_histories`.`info`
`booking_histories`.`document`
`booking_histories`.`delete_reason`
`booking_histories`.`addedOn`
`booking_histories`.`addedBy`
`booking_histories`.`modifiedBy`
`booking_histories`.`modifiedOn`
`booking_materials`.*
`booking_materials`.`id`
`booking_materials`.`booking_id`
`booking_materials`.`material`
`booking_materials`.`qty`
`booking_materials`.`split_amount`
`booking_materials`.`per_qty_price`
`booking_materials`.`package`
`booking_materials`.`packageSize`
`booking_materials`.`packageValue`
`booking_materials`.`project`
`booking_materials`.`info`
`booking_materials`.`purpose`
`booking_materials`.`status`
`booking_materials`.`deleted`
`booking_materials`.`addedOn`
`booking_materials`.`addedBy`
`booking_materials`.`modifiedBy`
`booking_materials`.`modifiedOn`
`booking_pictures`.*
`booking_pictures`.`id`
`booking_pictures`.`TransactionID`
`booking_pictures`.`Picture`
`booking_splits`.*
`booking_splits`.`id`
`booking_splits`.`booking_id`
`booking_splits`.`cat_id`
`booking_splits`.`sub_cat_id`
`booking_splits`.`sub_sub_cat_id`
`booking_splits`.`split_amount`
`booking_splits`.`status`
`booking_splits`.`deleted`
`booking_splits`.`addedOn`
`booking_splits`.`addedBy`
`booking_splits`.`modifiedBy`
`booking_splits`.`modifiedOn`
`bookings`.*
`bookings`.`id`
`bookings`.`account_id`
`bookings`.`transfer_account_id`
`bookings`.`type`
`bookings`.`number`
`bookings`.`date`
`bookings`.`payee`
`bookings`.`MemberID`
`bookings`.`amount`
`bookings`.`amount2`
`bookings`.`exchange_rate`
`bookings`.`category_id`
`bookings`.`sub_category_id`
`bookings`.`sub_sub_category_id`
`bookings`.`info`
`bookings`.`document`
`bookings`.`document_file`
`bookings`.`status`
`bookings`.`deleted`
`bookings`.`addedOn`
`bookings`.`addedBy`
`bookings`.`modifiedBy`
`bookings`.`modifiedOn`
`bookings`.`TransactionID`
`bookings`.`IBAN`
`bookings`.`is_back_from_bank`
`bookings`.`back_from_bank_payee`
`brief_anredens`.*
`brief_anredens`.`id`
`brief_anredens`.`Bezeichnung_Designation`
`brief_anredens`.`Gender`
`brief_anredens`.`Category`
`brief_anredens`.`status`
`brief_anredens`.`deleted`
`brief_anredens`.`addedOn`
`brief_anredens`.`addedBy`
`brief_anredens`.`modifiedBy`
`brief_anredens`.`modifiedOn`
`categories`.*
`categories`.`id`
`categories`.`CatID`
`categories`.`SubcatID`
`categories`.`SubSubCatID`
`categories`.`name`
`categories`.`type`
`categories`.`parent_id`
`categories`.`status`
`categories`.`status2`
`categories`.`deleted`
`categories`.`addedOn`
`categories`.`addedBy`
`categories`.`modifiedBy`
`categories`.`modifiedOn`
`certificate_templates`.*
`certificate_templates`.`id`
`certificate_templates`.`name`
`certificate_templates`.`email_template_key`
`certificate_templates`.`email_subject`
`certificate_templates`.`content`
`certificate_templates`.`status`
`certificate_templates`.`deleted`
`certificate_templates`.`modifiedDate`
`certificate_templates`.`createdDate`
`certificate_templates`.`addedBy`
`certificate_templates`.`modifiedBy`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`deposits`.*
`deposits`.`id`
`deposits`.`number`
`deposits`.`deposit_date`
`deposits`.`pay_from`
`deposits`.`amount`
`deposits`.`info`
`deposits`.`document`
`deposits`.`status`
`deposits`.`deleted`
`deposits`.`addedOn`
`deposits`.`addedBy`
`deposits`.`modifiedBy`
`deposits`.`modifiedOn`
`deposits_splits`.*
`deposits_splits`.`id`
`deposits_splits`.`deposit_id`
`deposits_splits`.`cat_id`
`deposits_splits`.`sub_cat_id`
`deposits_splits`.`sub_sub_cat_id`
`deposits_splits`.`split_amount`
`deposits_splits`.`status`
`deposits_splits`.`deleted`
`deposits_splits`.`addedOn`
`deposits_splits`.`addedBy`
`deposits_splits`.`modifiedBy`
`deposits_splits`.`modifiedOn`
`donation_boxes`.*
`donation_boxes`.`id`
`donation_boxes`.`OwnerID`
`donation_boxes`.`BoxesCount`
`donation_boxes`.`FromDate`
`donation_boxes`.`TillDate`
`donation_boxes`.`Weeks`
`donation_boxes`.`PlacedDate`
`donation_boxes`.`Amount`
`donation_boxes`.`status`
`donation_boxes`.`deleted`
`donation_boxes`.`addedOn`
`donation_boxes`.`addedBy`
`donation_boxes`.`modifiedBy`
`donation_boxes`.`modifiedOn`
`donation_in_kinds`.*
`donation_in_kinds`.`id`
`donation_in_kinds`.`OwnerID`
`donation_in_kinds`.`Date`
`donation_in_kinds`.`Article`
`donation_in_kinds`.`Quantity`
`donation_in_kinds`.`Sum`
`donation_in_kinds`.`File`
`donation_in_kinds`.`File_Ext`
`donation_in_kinds`.`File_Name`
`donation_in_kinds`.`details`
`donation_in_kinds`.`details_check`
`donation_in_kinds`.`status`
`donation_in_kinds`.`deleted`
`donation_in_kinds`.`addedOn`
`donation_in_kinds`.`addedBy`
`donation_in_kinds`.`modifiedBy`
`donation_in_kinds`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`letter_sender_object_items`.*
`letter_sender_object_items`.`id`
`letter_sender_object_items`.`OwnerID`
`letter_sender_object_items`.`year`
`letter_sender_object_items`.`send`
`letter_sender_object_items`.`SendStatus`
`letter_sender_object_items`.`donation_receipt_file`
`letter_sender_object_items`.`donation_receipt_filename`
`letter_sender_object_items`.`donation_in_Kind_receipt_file`
`letter_sender_object_items`.`donation_in_Kind_receipt_filename`
`letter_sender_object_items`.`status`
`letter_sender_object_items`.`deleted`
`letter_sender_object_items`.`addedOn`
`letter_sender_object_items`.`addedBy`
`letter_sender_object_items`.`modifiedBy`
`letter_sender_object_items`.`modifiedOn`
`list_function_columns`.*
`list_function_columns`.`id`
`list_function_columns`.`columns`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`materials`.*
`materials`.`id`
`materials`.`name`
`materials`.`status`
`materials`.`deleted`
`materials`.`addedOn`
`materials`.`addedBy`
`materials`.`modifiedBy`
`materials`.`modifiedOn`
`member_bank`.*
`member_bank`.`id`
`member_bank`.`MemberID`
`member_bank`.`BankName`
`member_bank`.`BLZ_BankCode`
`member_bank`.`Konto_AccountNumber`
`member_bank`.`IBAN`
`member_bank`.`LAEinzug`
`member_bank`.`IssuedOn`
`member_bank`.`SequenceType`
`member_bank`.`Mandatsreferenz`
`member_bank`.`BIC`
`member_bank`.`status`
`member_bank`.`deleted`
`member_bank`.`addedOn`
`member_bank`.`addedBy`
`member_bank`.`modifiedBy`
`member_bank`.`modifiedOn`
`member_ibans`.*
`member_ibans`.`id`
`member_ibans`.`OwnerID`
`member_ibans`.`IBAN`
`member_ibans`.`Bei`
`member_ibans`.`BIC`
`member_ibans`.`status`
`member_ibans`.`deleted`
`member_ibans`.`addedOn`
`member_ibans`.`addedBy`
`member_ibans`.`modifiedBy`
`member_ibans`.`modifiedOn`
`member_payment_info`.*
`member_payment_info`.`id`
`member_payment_info`.`OwnerID`
`member_payment_info`.`FromDate`
`member_payment_info`.`TillDate`
`member_payment_info`.`Type`
`member_payment_info`.`PayByMonth`
`member_payment_info`.`NotIBANCorrectAmount`
`member_payment_info`.`PayPeriodType`
`member_payment_info`.`PayBedType`
`member_payment_info`.`FirstMonth`
`member_payment_info`.`FirstMonthNotIBANCorrect`
`member_payment_info`.`FirstMonthSEPAError`
`member_payment_info`.`ClientBankName`
`member_payment_info`.`NotIBANCorrectDate`
`member_payment_info`.`CanTakeClientMoney`
`member_payment_info`.`ClientBLZ`
`member_payment_info`.`IsNotIBANCorrect`
`member_payment_info`.`ClientBIC`
`member_payment_info`.`IsSEPAError`
`member_payment_info`.`StartFile`
`member_payment_info`.`ClientAccountNumber`
`member_payment_info`.`StartExt`
`member_payment_info`.`FinishExt`
`member_payment_info`.`FinishFile`
`member_payment_info`.`OurAccountID`
`member_payment_info`.`OurBankID`
`member_payment_info`.`IssuedOn`
`member_payment_info`.`SequenceType`
`member_payment_info`.`Mandatsreferenz`
`member_payment_info`.`status`
`member_payment_info`.`deleted`
`member_payment_info`.`addedOn`
`member_payment_info`.`addedBy`
`member_payment_info`.`modifiedBy`
`member_payment_info`.`modifiedOn`
`member_rechnungs_invoices`.*
`member_rechnungs_invoices`.`id`
`member_rechnungs_invoices`.`MemberID`
`member_rechnungs_invoices`.`JahrMonat`
`member_rechnungs_invoices`.`Rechnungsnummer`
`member_rechnungs_invoices`.`BankName`
`member_rechnungs_invoices`.`IBAN`
`member_rechnungs_invoices`.`BIC`
`member_rechnungs_invoices`.`Mandatsreferenz`
`member_rechnungs_invoices`.`Betrag_Amount`
`member_rechnungs_invoices`.`IssuedOn`
`member_rechnungs_invoices`.`SEPAExportTime`
`member_rechnungs_invoices`.`FileName`
`member_rechnungs_invoices`.`BenutzerIDneu`
`member_rechnungs_invoices`.`Type`
`member_rechnungs_invoices`.`Purpose`
`member_rechnungs_invoices`.`status`
`member_rechnungs_invoices`.`deleted`
`member_rechnungs_invoices`.`addedOn`
`member_rechnungs_invoices`.`addedBy`
`member_rechnungs_invoices`.`modifiedBy`
`member_rechnungs_invoices`.`modifiedOn`
`member_settings`.*
`member_settings`.`id`
`member_settings`.`member_status`
`member_settings`.`member_areas`
`member_settings`.`member_types`
`members`.*
`members`.`id`
`members`.`company`
`members`.`salutation`
`members`.`briefanrede`
`members`.`title`
`members`.`dateOfBirth`
`members`.`firstname`
`members`.`surname`
`members`.`addressBlock`
`members`.`street`
`members`.`postcode`
`members`.`city`
`members`.`telephoneNo`
`members`.`mobileNo`
`members`.`email`
`members`.`areas`
`members`.`notNeedMoreInforming`
`members`.`noEmailCheck`
`members`.`emailCheckedDate`
`members`.`MemberType`
`members`.`MemberFinalType`
`members`.`BearbeitungsStatus`
`members`.`BriefSex`
`members`.`MoneyPayerID`
`members`.`CountOfBed`
`members`.`NewsletterLanguage`
`members`.`StartExt`
`members`.`StartFile`
`members`.`TillDate`
`members`.`FromDate`
`members`.`FinishFile`
`members`.`FinishExt`
`members`.`StillToEdit`
`members`.`BankInfoForStiillToEdit`
`members`.`status`
`members`.`deleted`
`members`.`addedOn`
`members`.`addedBy`
`members`.`modifiedBy`
`members`.`modifiedOn`
`members_accounts`.*
`members_accounts`.`id`
`members_accounts`.`Date`
`members_accounts`.`Name`
`members_accounts`.`IsCashBox`
`members_accounts`.`CurrencyID`
`members_accounts`.`BankID`
`members_accounts`.`SectionID`
`members_accounts`.`AccountNumber`
`members_accounts`.`TransactionID`
`members_accounts`.`IsBankStatements`
`members_accounts`.`IsManualStatements`
`members_accounts`.`IsForeignCurrencyAccount`
`members_accounts`.`NotCheckFortStatus`
`members_accounts`.`IsSepaAccount`
`members_accounts`.`EmailForSepa`
`members_accounts`.`status`
`members_accounts`.`deleted`
`members_accounts`.`addedOn`
`members_accounts`.`addedBy`
`members_accounts`.`modifiedBy`
`members_accounts`.`modifiedOn`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`payees`.*
`payees`.`id`
`payees`.`name`
`payees`.`company_group_ids`
`payees`.`status`
`payees`.`deleted`
`payees`.`addedOn`
`payees`.`addedBy`
`payees`.`modifiedBy`
`payees`.`modifiedOn`
`payees`.`member_id`
`payment_control_dates`.*
`payment_control_dates`.`id`
`payment_control_dates`.`user_id`
`payment_control_dates`.`month_from`
`payment_control_dates`.`year_from`
`payment_control_dates`.`month_to`
`payment_control_dates`.`year_to`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`sepa_settings`.*
`sepa_settings`.`id`
`sepa_settings`.`date`
`sepa_settings`.`Purpose`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`volunteers`.*
`volunteers`.`id`
`volunteers`.`OwnerID`
`volunteers`.`volunteer_type`
`volunteers`.`volunteer_from`
`volunteers`.`volunteer_till`
`volunteers`.`status`
`volunteers`.`deleted`
`volunteers`.`addedOn`
`volunteers`.`addedBy`
`volunteers`.`modifiedBy`
`volunteers`.`modifiedOn`
`withdrawal_splits`.*
`withdrawal_splits`.`id`
`withdrawal_splits`.`withdrawal_id`
`withdrawal_splits`.`cat_id`
`withdrawal_splits`.`sub_cat_id`
`withdrawal_splits`.`sub_sub_cat_id`
`withdrawal_splits`.`split_amount`
`withdrawal_splits`.`status`
`withdrawal_splits`.`deleted`
`withdrawal_splits`.`addedOn`
`withdrawal_splits`.`addedBy`
`withdrawal_splits`.`modifiedBy`
`withdrawal_splits`.`modifiedOn`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`number`
`withdrawals`.`date`
`withdrawals`.`pay_to`
`withdrawals`.`amount`
`withdrawals`.`info`
`withdrawals`.`document`
`withdrawals`.`status`
`withdrawals`.`deleted`
`withdrawals`.`addedOn`
`withdrawals`.`addedBy`
`withdrawals`.`modifiedBy`
`withdrawals`.`modifiedOn`
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`currency_id`
`accounts`.`balance`
`accounts`.`activation_date`
`accounts`.`is_bank_statement_available`
`accounts`.`account_type`
`accounts`.`is_obsolute_account`
`accounts`.`iban`
`accounts`.`bank_name`
`accounts`.`status`
`accounts`.`deleted`
`accounts`.`addedOn`
`accounts`.`addedBy`
`accounts`.`modifiedBy`
`accounts`.`modifiedOn`
`anreden_salutation`.*
`anreden_salutation`.`id`
`anreden_salutation`.`Bezeichnung_Designation`
`anreden_salutation`.`Gender`
`anreden_salutation`.`Category`
`anreden_salutation`.`status`
`anreden_salutation`.`deleted`
`anreden_salutation`.`addedOn`
`anreden_salutation`.`addedBy`
`anreden_salutation`.`modifiedBy`
`anreden_salutation`.`modifiedOn`
`bank_statements`.*
`bank_statements`.`id`
`bank_statements`.`account_id`
`bank_statements`.`name`
`bank_statements`.`date_from`
`bank_statements`.`date_to`
`bank_statements`.`incoming_balance`
`bank_statements`.`outgoing_balance`
`bank_statements`.`document_file_ext`
`bank_statements`.`document_file`
`bank_statements`.`status`
`bank_statements`.`deleted`
`bank_statements`.`addedOn`
`bank_statements`.`addedBy`
`bank_statements`.`modifiedBy`
`bank_statements`.`modifiedOn`
`banks_for_check`.*
`banks_for_check`.`id`
`banks_for_check`.`BLZ`
`banks_for_check`.`Name`
`banks_for_check`.`Address`
`banks_for_check`.`Name1`
`banks_for_check`.`BIC`
`banks_for_check`.`status`
`banks_for_check`.`deleted`
`banks_for_check`.`addedOn`
`banks_for_check`.`addedBy`
`banks_for_check`.`modifiedBy`
`banks_for_check`.`modifiedOn`
`bereiche_areas`.*
`bereiche_areas`.`id`
`bereiche_areas`.`Bezeichnung_Designation`
`bereiche_areas`.`SortIndex`
`bereiche_areas`.`status`
`bereiche_areas`.`deleted`
`bereiche_areas`.`addedOn`
`bereiche_areas`.`addedBy`
`bereiche_areas`.`modifiedBy`
`bereiche_areas`.`modifiedOn`
`booking_histories`.*
`booking_histories`.`id`
`booking_histories`.`booking_id`
`booking_histories`.`action`
`booking_histories`.`account_id`
`booking_histories`.`transfer_account_id`
`booking_histories`.`type`
`booking_histories`.`number`
`booking_histories`.`date`
`booking_histories`.`payee`
`booking_histories`.`amount`
`booking_histories`.`category_id`
`booking_histories`.`sub_category_id`
`booking_histories`.`sub_sub_category_id`
`booking_histories`.`info`
`booking_histories`.`document`
`booking_histories`.`delete_reason`
`booking_histories`.`addedOn`
`booking_histories`.`addedBy`
`booking_histories`.`modifiedBy`
`booking_histories`.`modifiedOn`
`booking_materials`.*
`booking_materials`.`id`
`booking_materials`.`booking_id`
`booking_materials`.`material`
`booking_materials`.`qty`
`booking_materials`.`split_amount`
`booking_materials`.`per_qty_price`
`booking_materials`.`package`
`booking_materials`.`packageSize`
`booking_materials`.`packageValue`
`booking_materials`.`project`
`booking_materials`.`info`
`booking_materials`.`purpose`
`booking_materials`.`status`
`booking_materials`.`deleted`
`booking_materials`.`addedOn`
`booking_materials`.`addedBy`
`booking_materials`.`modifiedBy`
`booking_materials`.`modifiedOn`
`booking_pictures`.*
`booking_pictures`.`id`
`booking_pictures`.`TransactionID`
`booking_pictures`.`Picture`
`booking_splits`.*
`booking_splits`.`id`
`booking_splits`.`booking_id`
`booking_splits`.`cat_id`
`booking_splits`.`sub_cat_id`
`booking_splits`.`sub_sub_cat_id`
`booking_splits`.`split_amount`
`booking_splits`.`status`
`booking_splits`.`deleted`
`booking_splits`.`addedOn`
`booking_splits`.`addedBy`
`booking_splits`.`modifiedBy`
`booking_splits`.`modifiedOn`
`bookings`.*
`bookings`.`id`
`bookings`.`account_id`
`bookings`.`transfer_account_id`
`bookings`.`type`
`bookings`.`number`
`bookings`.`date`
`bookings`.`payee`
`bookings`.`MemberID`
`bookings`.`amount`
`bookings`.`amount2`
`bookings`.`exchange_rate`
`bookings`.`category_id`
`bookings`.`sub_category_id`
`bookings`.`sub_sub_category_id`
`bookings`.`info`
`bookings`.`document`
`bookings`.`document_file`
`bookings`.`status`
`bookings`.`deleted`
`bookings`.`addedOn`
`bookings`.`addedBy`
`bookings`.`modifiedBy`
`bookings`.`modifiedOn`
`bookings`.`TransactionID`
`bookings`.`IBAN`
`bookings`.`is_back_from_bank`
`bookings`.`back_from_bank_payee`
`brief_anredens`.*
`brief_anredens`.`id`
`brief_anredens`.`Bezeichnung_Designation`
`brief_anredens`.`Gender`
`brief_anredens`.`Category`
`brief_anredens`.`status`
`brief_anredens`.`deleted`
`brief_anredens`.`addedOn`
`brief_anredens`.`addedBy`
`brief_anredens`.`modifiedBy`
`brief_anredens`.`modifiedOn`
`categories`.*
`categories`.`id`
`categories`.`CatID`
`categories`.`SubcatID`
`categories`.`SubSubCatID`
`categories`.`name`
`categories`.`type`
`categories`.`parent_id`
`categories`.`status`
`categories`.`status2`
`categories`.`deleted`
`categories`.`addedOn`
`categories`.`addedBy`
`categories`.`modifiedBy`
`categories`.`modifiedOn`
`certificate_templates`.*
`certificate_templates`.`id`
`certificate_templates`.`name`
`certificate_templates`.`email_template_key`
`certificate_templates`.`email_subject`
`certificate_templates`.`content`
`certificate_templates`.`status`
`certificate_templates`.`deleted`
`certificate_templates`.`modifiedDate`
`certificate_templates`.`createdDate`
`certificate_templates`.`addedBy`
`certificate_templates`.`modifiedBy`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`deposits`.*
`deposits`.`id`
`deposits`.`number`
`deposits`.`deposit_date`
`deposits`.`pay_from`
`deposits`.`amount`
`deposits`.`info`
`deposits`.`document`
`deposits`.`status`
`deposits`.`deleted`
`deposits`.`addedOn`
`deposits`.`addedBy`
`deposits`.`modifiedBy`
`deposits`.`modifiedOn`
`deposits_splits`.*
`deposits_splits`.`id`
`deposits_splits`.`deposit_id`
`deposits_splits`.`cat_id`
`deposits_splits`.`sub_cat_id`
`deposits_splits`.`sub_sub_cat_id`
`deposits_splits`.`split_amount`
`deposits_splits`.`status`
`deposits_splits`.`deleted`
`deposits_splits`.`addedOn`
`deposits_splits`.`addedBy`
`deposits_splits`.`modifiedBy`
`deposits_splits`.`modifiedOn`
`donation_boxes`.*
`donation_boxes`.`id`
`donation_boxes`.`OwnerID`
`donation_boxes`.`BoxesCount`
`donation_boxes`.`FromDate`
`donation_boxes`.`TillDate`
`donation_boxes`.`Weeks`
`donation_boxes`.`PlacedDate`
`donation_boxes`.`Amount`
`donation_boxes`.`status`
`donation_boxes`.`deleted`
`donation_boxes`.`addedOn`
`donation_boxes`.`addedBy`
`donation_boxes`.`modifiedBy`
`donation_boxes`.`modifiedOn`
`donation_in_kinds`.*
`donation_in_kinds`.`id`
`donation_in_kinds`.`OwnerID`
`donation_in_kinds`.`Date`
`donation_in_kinds`.`Article`
`donation_in_kinds`.`Quantity`
`donation_in_kinds`.`Sum`
`donation_in_kinds`.`File`
`donation_in_kinds`.`File_Ext`
`donation_in_kinds`.`File_Name`
`donation_in_kinds`.`details`
`donation_in_kinds`.`details_check`
`donation_in_kinds`.`status`
`donation_in_kinds`.`deleted`
`donation_in_kinds`.`addedOn`
`donation_in_kinds`.`addedBy`
`donation_in_kinds`.`modifiedBy`
`donation_in_kinds`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`letter_sender_object_items`.*
`letter_sender_object_items`.`id`
`letter_sender_object_items`.`OwnerID`
`letter_sender_object_items`.`year`
`letter_sender_object_items`.`send`
`letter_sender_object_items`.`SendStatus`
`letter_sender_object_items`.`donation_receipt_file`
`letter_sender_object_items`.`donation_receipt_filename`
`letter_sender_object_items`.`donation_in_Kind_receipt_file`
`letter_sender_object_items`.`donation_in_Kind_receipt_filename`
`letter_sender_object_items`.`status`
`letter_sender_object_items`.`deleted`
`letter_sender_object_items`.`addedOn`
`letter_sender_object_items`.`addedBy`
`letter_sender_object_items`.`modifiedBy`
`letter_sender_object_items`.`modifiedOn`
`list_function_columns`.*
`list_function_columns`.`id`
`list_function_columns`.`columns`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`materials`.*
`materials`.`id`
`materials`.`name`
`materials`.`status`
`materials`.`deleted`
`materials`.`addedOn`
`materials`.`addedBy`
`materials`.`modifiedBy`
`materials`.`modifiedOn`
`member_bank`.*
`member_bank`.`id`
`member_bank`.`MemberID`
`member_bank`.`BankName`
`member_bank`.`BLZ_BankCode`
`member_bank`.`Konto_AccountNumber`
`member_bank`.`IBAN`
`member_bank`.`LAEinzug`
`member_bank`.`IssuedOn`
`member_bank`.`SequenceType`
`member_bank`.`Mandatsreferenz`
`member_bank`.`BIC`
`member_bank`.`status`
`member_bank`.`deleted`
`member_bank`.`addedOn`
`member_bank`.`addedBy`
`member_bank`.`modifiedBy`
`member_bank`.`modifiedOn`
`member_ibans`.*
`member_ibans`.`id`
`member_ibans`.`OwnerID`
`member_ibans`.`IBAN`
`member_ibans`.`Bei`
`member_ibans`.`BIC`
`member_ibans`.`status`
`member_ibans`.`deleted`
`member_ibans`.`addedOn`
`member_ibans`.`addedBy`
`member_ibans`.`modifiedBy`
`member_ibans`.`modifiedOn`
`member_payment_info`.*
`member_payment_info`.`id`
`member_payment_info`.`OwnerID`
`member_payment_info`.`FromDate`
`member_payment_info`.`TillDate`
`member_payment_info`.`Type`
`member_payment_info`.`PayByMonth`
`member_payment_info`.`NotIBANCorrectAmount`
`member_payment_info`.`PayPeriodType`
`member_payment_info`.`PayBedType`
`member_payment_info`.`FirstMonth`
`member_payment_info`.`FirstMonthNotIBANCorrect`
`member_payment_info`.`FirstMonthSEPAError`
`member_payment_info`.`ClientBankName`
`member_payment_info`.`NotIBANCorrectDate`
`member_payment_info`.`CanTakeClientMoney`
`member_payment_info`.`ClientBLZ`
`member_payment_info`.`IsNotIBANCorrect`
`member_payment_info`.`ClientBIC`
`member_payment_info`.`IsSEPAError`
`member_payment_info`.`StartFile`
`member_payment_info`.`ClientAccountNumber`
`member_payment_info`.`StartExt`
`member_payment_info`.`FinishExt`
`member_payment_info`.`FinishFile`
`member_payment_info`.`OurAccountID`
`member_payment_info`.`OurBankID`
`member_payment_info`.`IssuedOn`
`member_payment_info`.`SequenceType`
`member_payment_info`.`Mandatsreferenz`
`member_payment_info`.`status`
`member_payment_info`.`deleted`
`member_payment_info`.`addedOn`
`member_payment_info`.`addedBy`
`member_payment_info`.`modifiedBy`
`member_payment_info`.`modifiedOn`
`member_rechnungs_invoices`.*
`member_rechnungs_invoices`.`id`
`member_rechnungs_invoices`.`MemberID`
`member_rechnungs_invoices`.`JahrMonat`
`member_rechnungs_invoices`.`Rechnungsnummer`
`member_rechnungs_invoices`.`BankName`
`member_rechnungs_invoices`.`IBAN`
`member_rechnungs_invoices`.`BIC`
`member_rechnungs_invoices`.`Mandatsreferenz`
`member_rechnungs_invoices`.`Betrag_Amount`
`member_rechnungs_invoices`.`IssuedOn`
`member_rechnungs_invoices`.`SEPAExportTime`
`member_rechnungs_invoices`.`FileName`
`member_rechnungs_invoices`.`BenutzerIDneu`
`member_rechnungs_invoices`.`Type`
`member_rechnungs_invoices`.`Purpose`
`member_rechnungs_invoices`.`status`
`member_rechnungs_invoices`.`deleted`
`member_rechnungs_invoices`.`addedOn`
`member_rechnungs_invoices`.`addedBy`
`member_rechnungs_invoices`.`modifiedBy`
`member_rechnungs_invoices`.`modifiedOn`
`member_settings`.*
`member_settings`.`id`
`member_settings`.`member_status`
`member_settings`.`member_areas`
`member_settings`.`member_types`
`members`.*
`members`.`id`
`members`.`company`
`members`.`salutation`
`members`.`briefanrede`
`members`.`title`
`members`.`dateOfBirth`
`members`.`firstname`
`members`.`surname`
`members`.`addressBlock`
`members`.`street`
`members`.`postcode`
`members`.`city`
`members`.`telephoneNo`
`members`.`mobileNo`
`members`.`email`
`members`.`areas`
`members`.`notNeedMoreInforming`
`members`.`noEmailCheck`
`members`.`emailCheckedDate`
`members`.`MemberType`
`members`.`MemberFinalType`
`members`.`BearbeitungsStatus`
`members`.`BriefSex`
`members`.`MoneyPayerID`
`members`.`CountOfBed`
`members`.`NewsletterLanguage`
`members`.`StartExt`
`members`.`StartFile`
`members`.`TillDate`
`members`.`FromDate`
`members`.`FinishFile`
`members`.`FinishExt`
`members`.`StillToEdit`
`members`.`BankInfoForStiillToEdit`
`members`.`status`
`members`.`deleted`
`members`.`addedOn`
`members`.`addedBy`
`members`.`modifiedBy`
`members`.`modifiedOn`
`members_accounts`.*
`members_accounts`.`id`
`members_accounts`.`Date`
`members_accounts`.`Name`
`members_accounts`.`IsCashBox`
`members_accounts`.`CurrencyID`
`members_accounts`.`BankID`
`members_accounts`.`SectionID`
`members_accounts`.`AccountNumber`
`members_accounts`.`TransactionID`
`members_accounts`.`IsBankStatements`
`members_accounts`.`IsManualStatements`
`members_accounts`.`IsForeignCurrencyAccount`
`members_accounts`.`NotCheckFortStatus`
`members_accounts`.`IsSepaAccount`
`members_accounts`.`EmailForSepa`
`members_accounts`.`status`
`members_accounts`.`deleted`
`members_accounts`.`addedOn`
`members_accounts`.`addedBy`
`members_accounts`.`modifiedBy`
`members_accounts`.`modifiedOn`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`payees`.*
`payees`.`id`
`payees`.`name`
`payees`.`company_group_ids`
`payees`.`status`
`payees`.`deleted`
`payees`.`addedOn`
`payees`.`addedBy`
`payees`.`modifiedBy`
`payees`.`modifiedOn`
`payees`.`member_id`
`payment_control_dates`.*
`payment_control_dates`.`id`
`payment_control_dates`.`user_id`
`payment_control_dates`.`month_from`
`payment_control_dates`.`year_from`
`payment_control_dates`.`month_to`
`payment_control_dates`.`year_to`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`sepa_settings`.*
`sepa_settings`.`id`
`sepa_settings`.`date`
`sepa_settings`.`Purpose`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`volunteers`.*
`volunteers`.`id`
`volunteers`.`OwnerID`
`volunteers`.`volunteer_type`
`volunteers`.`volunteer_from`
`volunteers`.`volunteer_till`
`volunteers`.`status`
`volunteers`.`deleted`
`volunteers`.`addedOn`
`volunteers`.`addedBy`
`volunteers`.`modifiedBy`
`volunteers`.`modifiedOn`
`withdrawal_splits`.*
`withdrawal_splits`.`id`
`withdrawal_splits`.`withdrawal_id`
`withdrawal_splits`.`cat_id`
`withdrawal_splits`.`sub_cat_id`
`withdrawal_splits`.`sub_sub_cat_id`
`withdrawal_splits`.`split_amount`
`withdrawal_splits`.`status`
`withdrawal_splits`.`deleted`
`withdrawal_splits`.`addedOn`
`withdrawal_splits`.`addedBy`
`withdrawal_splits`.`modifiedBy`
`withdrawal_splits`.`modifiedOn`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`number`
`withdrawals`.`date`
`withdrawals`.`pay_to`
`withdrawals`.`amount`
`withdrawals`.`info`
`withdrawals`.`document`
`withdrawals`.`status`
`withdrawals`.`deleted`
`withdrawals`.`addedOn`
`withdrawals`.`addedBy`
`withdrawals`.`modifiedBy`
`withdrawals`.`modifiedOn`
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`currency_id`
`accounts`.`balance`
`accounts`.`activation_date`
`accounts`.`is_bank_statement_available`
`accounts`.`account_type`
`accounts`.`is_obsolute_account`
`accounts`.`iban`
`accounts`.`bank_name`
`accounts`.`status`
`accounts`.`deleted`
`accounts`.`addedOn`
`accounts`.`addedBy`
`accounts`.`modifiedBy`
`accounts`.`modifiedOn`
`anreden_salutation`.*
`anreden_salutation`.`id`
`anreden_salutation`.`Bezeichnung_Designation`
`anreden_salutation`.`Gender`
`anreden_salutation`.`Category`
`anreden_salutation`.`status`
`anreden_salutation`.`deleted`
`anreden_salutation`.`addedOn`
`anreden_salutation`.`addedBy`
`anreden_salutation`.`modifiedBy`
`anreden_salutation`.`modifiedOn`
`bank_statements`.*
`bank_statements`.`id`
`bank_statements`.`account_id`
`bank_statements`.`name`
`bank_statements`.`date_from`
`bank_statements`.`date_to`
`bank_statements`.`incoming_balance`
`bank_statements`.`outgoing_balance`
`bank_statements`.`document_file_ext`
`bank_statements`.`document_file`
`bank_statements`.`status`
`bank_statements`.`deleted`
`bank_statements`.`addedOn`
`bank_statements`.`addedBy`
`bank_statements`.`modifiedBy`
`bank_statements`.`modifiedOn`
`banks_for_check`.*
`banks_for_check`.`id`
`banks_for_check`.`BLZ`
`banks_for_check`.`Name`
`banks_for_check`.`Address`
`banks_for_check`.`Name1`
`banks_for_check`.`BIC`
`banks_for_check`.`status`
`banks_for_check`.`deleted`
`banks_for_check`.`addedOn`
`banks_for_check`.`addedBy`
`banks_for_check`.`modifiedBy`
`banks_for_check`.`modifiedOn`
`bereiche_areas`.*
`bereiche_areas`.`id`
`bereiche_areas`.`Bezeichnung_Designation`
`bereiche_areas`.`SortIndex`
`bereiche_areas`.`status`
`bereiche_areas`.`deleted`
`bereiche_areas`.`addedOn`
`bereiche_areas`.`addedBy`
`bereiche_areas`.`modifiedBy`
`bereiche_areas`.`modifiedOn`
`booking_histories`.*
`booking_histories`.`id`
`booking_histories`.`booking_id`
`booking_histories`.`action`
`booking_histories`.`account_id`
`booking_histories`.`transfer_account_id`
`booking_histories`.`type`
`booking_histories`.`number`
`booking_histories`.`date`
`booking_histories`.`payee`
`booking_histories`.`amount`
`booking_histories`.`category_id`
`booking_histories`.`sub_category_id`
`booking_histories`.`sub_sub_category_id`
`booking_histories`.`info`
`booking_histories`.`document`
`booking_histories`.`delete_reason`
`booking_histories`.`addedOn`
`booking_histories`.`addedBy`
`booking_histories`.`modifiedBy`
`booking_histories`.`modifiedOn`
`booking_materials`.*
`booking_materials`.`id`
`booking_materials`.`booking_id`
`booking_materials`.`material`
`booking_materials`.`qty`
`booking_materials`.`split_amount`
`booking_materials`.`per_qty_price`
`booking_materials`.`package`
`booking_materials`.`packageSize`
`booking_materials`.`packageValue`
`booking_materials`.`project`
`booking_materials`.`info`
`booking_materials`.`purpose`
`booking_materials`.`status`
`booking_materials`.`deleted`
`booking_materials`.`addedOn`
`booking_materials`.`addedBy`
`booking_materials`.`modifiedBy`
`booking_materials`.`modifiedOn`
`booking_pictures`.*
`booking_pictures`.`id`
`booking_pictures`.`TransactionID`
`booking_pictures`.`Picture`
`booking_splits`.*
`booking_splits`.`id`
`booking_splits`.`booking_id`
`booking_splits`.`cat_id`
`booking_splits`.`sub_cat_id`
`booking_splits`.`sub_sub_cat_id`
`booking_splits`.`split_amount`
`booking_splits`.`status`
`booking_splits`.`deleted`
`booking_splits`.`addedOn`
`booking_splits`.`addedBy`
`booking_splits`.`modifiedBy`
`booking_splits`.`modifiedOn`
`bookings`.*
`bookings`.`id`
`bookings`.`account_id`
`bookings`.`transfer_account_id`
`bookings`.`type`
`bookings`.`number`
`bookings`.`date`
`bookings`.`payee`
`bookings`.`MemberID`
`bookings`.`amount`
`bookings`.`amount2`
`bookings`.`exchange_rate`
`bookings`.`category_id`
`bookings`.`sub_category_id`
`bookings`.`sub_sub_category_id`
`bookings`.`info`
`bookings`.`document`
`bookings`.`document_file`
`bookings`.`status`
`bookings`.`deleted`
`bookings`.`addedOn`
`bookings`.`addedBy`
`bookings`.`modifiedBy`
`bookings`.`modifiedOn`
`bookings`.`TransactionID`
`bookings`.`IBAN`
`bookings`.`is_back_from_bank`
`bookings`.`back_from_bank_payee`
`brief_anredens`.*
`brief_anredens`.`id`
`brief_anredens`.`Bezeichnung_Designation`
`brief_anredens`.`Gender`
`brief_anredens`.`Category`
`brief_anredens`.`status`
`brief_anredens`.`deleted`
`brief_anredens`.`addedOn`
`brief_anredens`.`addedBy`
`brief_anredens`.`modifiedBy`
`brief_anredens`.`modifiedOn`
`categories`.*
`categories`.`id`
`categories`.`CatID`
`categories`.`SubcatID`
`categories`.`SubSubCatID`
`categories`.`name`
`categories`.`type`
`categories`.`parent_id`
`categories`.`status`
`categories`.`status2`
`categories`.`deleted`
`categories`.`addedOn`
`categories`.`addedBy`
`categories`.`modifiedBy`
`categories`.`modifiedOn`
`certificate_templates`.*
`certificate_templates`.`id`
`certificate_templates`.`name`
`certificate_templates`.`email_template_key`
`certificate_templates`.`email_subject`
`certificate_templates`.`content`
`certificate_templates`.`status`
`certificate_templates`.`deleted`
`certificate_templates`.`modifiedDate`
`certificate_templates`.`createdDate`
`certificate_templates`.`addedBy`
`certificate_templates`.`modifiedBy`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`deposits`.*
`deposits`.`id`
`deposits`.`number`
`deposits`.`deposit_date`
`deposits`.`pay_from`
`deposits`.`amount`
`deposits`.`info`
`deposits`.`document`
`deposits`.`status`
`deposits`.`deleted`
`deposits`.`addedOn`
`deposits`.`addedBy`
`deposits`.`modifiedBy`
`deposits`.`modifiedOn`
`deposits_splits`.*
`deposits_splits`.`id`
`deposits_splits`.`deposit_id`
`deposits_splits`.`cat_id`
`deposits_splits`.`sub_cat_id`
`deposits_splits`.`sub_sub_cat_id`
`deposits_splits`.`split_amount`
`deposits_splits`.`status`
`deposits_splits`.`deleted`
`deposits_splits`.`addedOn`
`deposits_splits`.`addedBy`
`deposits_splits`.`modifiedBy`
`deposits_splits`.`modifiedOn`
`donation_boxes`.*
`donation_boxes`.`id`
`donation_boxes`.`OwnerID`
`donation_boxes`.`BoxesCount`
`donation_boxes`.`FromDate`
`donation_boxes`.`TillDate`
`donation_boxes`.`Weeks`
`donation_boxes`.`PlacedDate`
`donation_boxes`.`Amount`
`donation_boxes`.`status`
`donation_boxes`.`deleted`
`donation_boxes`.`addedOn`
`donation_boxes`.`addedBy`
`donation_boxes`.`modifiedBy`
`donation_boxes`.`modifiedOn`
`donation_in_kinds`.*
`donation_in_kinds`.`id`
`donation_in_kinds`.`OwnerID`
`donation_in_kinds`.`Date`
`donation_in_kinds`.`Article`
`donation_in_kinds`.`Quantity`
`donation_in_kinds`.`Sum`
`donation_in_kinds`.`File`
`donation_in_kinds`.`File_Ext`
`donation_in_kinds`.`File_Name`
`donation_in_kinds`.`details`
`donation_in_kinds`.`details_check`
`donation_in_kinds`.`status`
`donation_in_kinds`.`deleted`
`donation_in_kinds`.`addedOn`
`donation_in_kinds`.`addedBy`
`donation_in_kinds`.`modifiedBy`
`donation_in_kinds`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`letter_sender_object_items`.*
`letter_sender_object_items`.`id`
`letter_sender_object_items`.`OwnerID`
`letter_sender_object_items`.`year`
`letter_sender_object_items`.`send`
`letter_sender_object_items`.`SendStatus`
`letter_sender_object_items`.`donation_receipt_file`
`letter_sender_object_items`.`donation_receipt_filename`
`letter_sender_object_items`.`donation_in_Kind_receipt_file`
`letter_sender_object_items`.`donation_in_Kind_receipt_filename`
`letter_sender_object_items`.`status`
`letter_sender_object_items`.`deleted`
`letter_sender_object_items`.`addedOn`
`letter_sender_object_items`.`addedBy`
`letter_sender_object_items`.`modifiedBy`
`letter_sender_object_items`.`modifiedOn`
`list_function_columns`.*
`list_function_columns`.`id`
`list_function_columns`.`columns`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`materials`.*
`materials`.`id`
`materials`.`name`
`materials`.`status`
`materials`.`deleted`
`materials`.`addedOn`
`materials`.`addedBy`
`materials`.`modifiedBy`
`materials`.`modifiedOn`
`member_bank`.*
`member_bank`.`id`
`member_bank`.`MemberID`
`member_bank`.`BankName`
`member_bank`.`BLZ_BankCode`
`member_bank`.`Konto_AccountNumber`
`member_bank`.`IBAN`
`member_bank`.`LAEinzug`
`member_bank`.`IssuedOn`
`member_bank`.`SequenceType`
`member_bank`.`Mandatsreferenz`
`member_bank`.`BIC`
`member_bank`.`status`
`member_bank`.`deleted`
`member_bank`.`addedOn`
`member_bank`.`addedBy`
`member_bank`.`modifiedBy`
`member_bank`.`modifiedOn`
`member_ibans`.*
`member_ibans`.`id`
`member_ibans`.`OwnerID`
`member_ibans`.`IBAN`
`member_ibans`.`Bei`
`member_ibans`.`BIC`
`member_ibans`.`status`
`member_ibans`.`deleted`
`member_ibans`.`addedOn`
`member_ibans`.`addedBy`
`member_ibans`.`modifiedBy`
`member_ibans`.`modifiedOn`
`member_payment_info`.*
`member_payment_info`.`id`
`member_payment_info`.`OwnerID`
`member_payment_info`.`FromDate`
`member_payment_info`.`TillDate`
`member_payment_info`.`Type`
`member_payment_info`.`PayByMonth`
`member_payment_info`.`NotIBANCorrectAmount`
`member_payment_info`.`PayPeriodType`
`member_payment_info`.`PayBedType`
`member_payment_info`.`FirstMonth`
`member_payment_info`.`FirstMonthNotIBANCorrect`
`member_payment_info`.`FirstMonthSEPAError`
`member_payment_info`.`ClientBankName`
`member_payment_info`.`NotIBANCorrectDate`
`member_payment_info`.`CanTakeClientMoney`
`member_payment_info`.`ClientBLZ`
`member_payment_info`.`IsNotIBANCorrect`
`member_payment_info`.`ClientBIC`
`member_payment_info`.`IsSEPAError`
`member_payment_info`.`StartFile`
`member_payment_info`.`ClientAccountNumber`
`member_payment_info`.`StartExt`
`member_payment_info`.`FinishExt`
`member_payment_info`.`FinishFile`
`member_payment_info`.`OurAccountID`
`member_payment_info`.`OurBankID`
`member_payment_info`.`IssuedOn`
`member_payment_info`.`SequenceType`
`member_payment_info`.`Mandatsreferenz`
`member_payment_info`.`status`
`member_payment_info`.`deleted`
`member_payment_info`.`addedOn`
`member_payment_info`.`addedBy`
`member_payment_info`.`modifiedBy`
`member_payment_info`.`modifiedOn`
`member_rechnungs_invoices`.*
`member_rechnungs_invoices`.`id`
`member_rechnungs_invoices`.`MemberID`
`member_rechnungs_invoices`.`JahrMonat`
`member_rechnungs_invoices`.`Rechnungsnummer`
`member_rechnungs_invoices`.`BankName`
`member_rechnungs_invoices`.`IBAN`
`member_rechnungs_invoices`.`BIC`
`member_rechnungs_invoices`.`Mandatsreferenz`
`member_rechnungs_invoices`.`Betrag_Amount`
`member_rechnungs_invoices`.`IssuedOn`
`member_rechnungs_invoices`.`SEPAExportTime`
`member_rechnungs_invoices`.`FileName`
`member_rechnungs_invoices`.`BenutzerIDneu`
`member_rechnungs_invoices`.`Type`
`member_rechnungs_invoices`.`Purpose`
`member_rechnungs_invoices`.`status`
`member_rechnungs_invoices`.`deleted`
`member_rechnungs_invoices`.`addedOn`
`member_rechnungs_invoices`.`addedBy`
`member_rechnungs_invoices`.`modifiedBy`
`member_rechnungs_invoices`.`modifiedOn`
`member_settings`.*
`member_settings`.`id`
`member_settings`.`member_status`
`member_settings`.`member_areas`
`member_settings`.`member_types`
`members`.*
`members`.`id`
`members`.`company`
`members`.`salutation`
`members`.`briefanrede`
`members`.`title`
`members`.`dateOfBirth`
`members`.`firstname`
`members`.`surname`
`members`.`addressBlock`
`members`.`street`
`members`.`postcode`
`members`.`city`
`members`.`telephoneNo`
`members`.`mobileNo`
`members`.`email`
`members`.`areas`
`members`.`notNeedMoreInforming`
`members`.`noEmailCheck`
`members`.`emailCheckedDate`
`members`.`MemberType`
`members`.`MemberFinalType`
`members`.`BearbeitungsStatus`
`members`.`BriefSex`
`members`.`MoneyPayerID`
`members`.`CountOfBed`
`members`.`NewsletterLanguage`
`members`.`StartExt`
`members`.`StartFile`
`members`.`TillDate`
`members`.`FromDate`
`members`.`FinishFile`
`members`.`FinishExt`
`members`.`StillToEdit`
`members`.`BankInfoForStiillToEdit`
`members`.`status`
`members`.`deleted`
`members`.`addedOn`
`members`.`addedBy`
`members`.`modifiedBy`
`members`.`modifiedOn`
`members_accounts`.*
`members_accounts`.`id`
`members_accounts`.`Date`
`members_accounts`.`Name`
`members_accounts`.`IsCashBox`
`members_accounts`.`CurrencyID`
`members_accounts`.`BankID`
`members_accounts`.`SectionID`
`members_accounts`.`AccountNumber`
`members_accounts`.`TransactionID`
`members_accounts`.`IsBankStatements`
`members_accounts`.`IsManualStatements`
`members_accounts`.`IsForeignCurrencyAccount`
`members_accounts`.`NotCheckFortStatus`
`members_accounts`.`IsSepaAccount`
`members_accounts`.`EmailForSepa`
`members_accounts`.`status`
`members_accounts`.`deleted`
`members_accounts`.`addedOn`
`members_accounts`.`addedBy`
`members_accounts`.`modifiedBy`
`members_accounts`.`modifiedOn`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`payees`.*
`payees`.`id`
`payees`.`name`
`payees`.`company_group_ids`
`payees`.`status`
`payees`.`deleted`
`payees`.`addedOn`
`payees`.`addedBy`
`payees`.`modifiedBy`
`payees`.`modifiedOn`
`payees`.`member_id`
`payment_control_dates`.*
`payment_control_dates`.`id`
`payment_control_dates`.`user_id`
`payment_control_dates`.`month_from`
`payment_control_dates`.`year_from`
`payment_control_dates`.`month_to`
`payment_control_dates`.`year_to`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`sepa_settings`.*
`sepa_settings`.`id`
`sepa_settings`.`date`
`sepa_settings`.`Purpose`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`volunteers`.*
`volunteers`.`id`
`volunteers`.`OwnerID`
`volunteers`.`volunteer_type`
`volunteers`.`volunteer_from`
`volunteers`.`volunteer_till`
`volunteers`.`status`
`volunteers`.`deleted`
`volunteers`.`addedOn`
`volunteers`.`addedBy`
`volunteers`.`modifiedBy`
`volunteers`.`modifiedOn`
`withdrawal_splits`.*
`withdrawal_splits`.`id`
`withdrawal_splits`.`withdrawal_id`
`withdrawal_splits`.`cat_id`
`withdrawal_splits`.`sub_cat_id`
`withdrawal_splits`.`sub_sub_cat_id`
`withdrawal_splits`.`split_amount`
`withdrawal_splits`.`status`
`withdrawal_splits`.`deleted`
`withdrawal_splits`.`addedOn`
`withdrawal_splits`.`addedBy`
`withdrawal_splits`.`modifiedBy`
`withdrawal_splits`.`modifiedOn`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`number`
`withdrawals`.`date`
`withdrawals`.`pay_to`
`withdrawals`.`amount`
`withdrawals`.`info`
`withdrawals`.`document`
`withdrawals`.`status`
`withdrawals`.`deleted`
`withdrawals`.`addedOn`
`withdrawals`.`addedBy`
`withdrawals`.`modifiedBy`
`withdrawals`.`modifiedOn`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
accounts
anreden_salutation
bank_statements
banks_for_check
bereiche_areas
booking_histories
booking_materials
booking_pictures
booking_splits
bookings
brief_anredens
categories
certificate_templates
ci_sessions
company_details
contents
currencies
deposits
deposits_splits
donation_boxes
donation_in_kinds
email_templates
employees
folder_files
folders
languages
letter_sender_object_items
list_function_columns
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
mail_templates
materials
member_bank
member_ibans
member_payment_info
member_rechnungs_invoices
member_settings
members
members_accounts
modules
payees
payment_control_dates
reports_dates
role_permissions
roles
send_email_logs
sepa_settings
settings
signers
titles
transfers
uploads
user_address_books
user_profiles
user_schedules
user_settings
users
volunteers
withdrawal_splits
withdrawals
SQL query on database
axiuss40_africa_charity_program
: