Recent
`medvantm_pharmacy_db`.`configs`
`medvantm_pharmacy_db`.`delivery`
`information_schema`.`INNODB_FT_INDEX_CACHE`
`information_schema`.`USER_STATISTICS`
`medvantm_pharmacy_db`.`zra_classification_codes`
`information_schema`.`STATISTICS`
`performance_schema`.`file_summary_by_instance`
`performance_schema`.`socket_summary_by_instance`
`medvantm_pharmacy_db`.`zra_imports`
`medvantm_pharmacy_db`.`users`
Favorites
There are no favorite tables.
New
adminpanel
information_schema
medvantm_pharmacy_db
mysql
oapi_db
performance_schema
phpmyadmin
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
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: medvantm_pharmacy_db
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
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
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`product_id`
`cart`.`strength_id`
`cart`.`quantity`
`cart`.`price`
`cart`.`name`
`cart`.`measurement`
`cart`.`image`
`cart`.`created_at`
`cart`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`parent_id`
`categories`.`description`
`categories`.`image_url`
`categories`.`is_active`
`categories`.`display_order`
`categories`.`slug`
`categories`.`created_at`
`categories`.`updated_at`
`configs`.*
`configs`.`id`
`configs`.`config_key`
`configs`.`config_value`
`consultant_availability`.*
`consultant_availability`.`id`
`consultant_availability`.`consultant_id`
`consultant_availability`.`day`
`consultant_availability`.`time_slot`
`consultations`.*
`consultations`.`id`
`consultations`.`user_id`
`consultations`.`consultant_id`
`consultations`.`type`
`consultations`.`date_time`
`consultations`.`status`
`consultations`.`summary`
`consultations`.`google_meet_link`
`consultations`.`fee`
`consultations`.`clinic_address`
`consultations`.`created_at`
`content_sections`.*
`content_sections`.`id`
`content_sections`.`page`
`content_sections`.`section_name`
`content_sections`.`content`
`content_sections`.`image`
`delivery`.*
`delivery`.`id`
`delivery`.`user_id`
`delivery`.`billing_gender`
`delivery`.`billing_dob`
`delivery`.`billing_title`
`delivery`.`billing_first_name`
`delivery`.`billing_last_name`
`delivery`.`billing_email`
`delivery`.`billing_phone`
`delivery`.`billing_street`
`delivery`.`billing_apartment`
`delivery`.`billing_city`
`delivery`.`billing_county`
`delivery`.`billing_postal_code`
`delivery`.`billing_country`
`delivery`.`shipping_street`
`delivery`.`shipping_city`
`delivery`.`shipping_county`
`delivery`.`shipping_postal_code`
`delivery`.`shipping_country`
`delivery`.`order_notes`
`delivery`.`created_at`
`dpo_config`.*
`dpo_config`.`id`
`dpo_config`.`company_token`
`dpo_config`.`company_token_iv`
`dpo_config`.`api_endpoint`
`dpo_config`.`payment_url`
`dpo_config`.`redirect_url`
`dpo_config`.`service_type`
`dpo_config`.`created_at`
`dpo_config`.`updated_at`
`gallery_images`.*
`gallery_images`.`id`
`gallery_images`.`image_url`
`gallery_images`.`alt_text`
`gallery_images`.`created_at`
`medicine_strengths`.*
`medicine_strengths`.`id`
`medicine_strengths`.`medicine_id`
`medicine_strengths`.`measurement`
`medicine_strengths`.`price`
`medicine_strengths`.`inStock`
`medicine_strengths`.`created_at`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`shortDescription`
`medicines`.`description`
`medicines`.`image`
`medicines`.`price`
`medicines`.`originalPrice`
`medicines`.`stock`
`medicines`.`isControlled`
`medicines`.`is_disabled`
`medicines`.`category_id`
`medicines`.`subcategory_id`
`medicines`.`max_quantity`
`medicines`.`activeIngredient`
`medicines`.`side_effects`
`medicines`.`dosageInstructions`
`medicines`.`rating`
`medicines`.`reviewCount`
`medicines`.`manufacturer`
`medicines`.`supplier`
`medicines`.`barcode`
`medicines`.`batch_number`
`medicines`.`expiry_date`
`medicines`.`vat_rate`
`medicines`.`created_at`
`order_items`.*
`order_items`.`id`
`order_items`.`order_id`
`order_items`.`product_id`
`order_items`.`strength_id`
`order_items`.`quantity`
`order_items`.`price`
`order_items`.`prescription_path`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`delivery_id`
`orders`.`total`
`orders`.`status`
`orders`.`payment_status`
`orders`.`transaction_id`
`orders`.`gateway_transaction_id`
`orders`.`prnt`
`orders`.`incomplete`
`orders`.`billing_details`
`orders`.`shipping_details`
`orders`.`order_notes`
`orders`.`created_at`
`prescription_items`.*
`prescription_items`.`id`
`prescription_items`.`prescription_id`
`prescription_items`.`medicine_id`
`prescription_items`.`strength_id`
`prescription_items`.`quantity`
`prescription_items`.`approved_quantity`
`prescription_items`.`created_at`
`prescriptions`.*
`prescriptions`.`id`
`prescriptions`.`user_id`
`prescriptions`.`consultant_id`
`prescriptions`.`status`
`prescriptions`.`notes`
`prescriptions`.`created_at`
`refunds`.*
`refunds`.`id`
`refunds`.`user_id`
`refunds`.`order_id`
`refunds`.`consultation_id`
`refunds`.`cisInvcNo`
`refunds`.`reason`
`refunds`.`remarks`
`refunds`.`image_path`
`refunds`.`status`
`refunds`.`created_at`
`team_members`.*
`team_members`.`id`
`team_members`.`name`
`team_members`.`role`
`team_members`.`image_url`
`team_members`.`specialization`
`team_members`.`created_at`
`testimonials`.*
`testimonials`.`id`
`testimonials`.`name`
`testimonials`.`role`
`testimonials`.`image_url`
`testimonials`.`rating`
`testimonials`.`comment`
`testimonials`.`created_at`
`users`.*
`users`.`id`
`users`.`role`
`users`.`email`
`users`.`password`
`users`.`first_name`
`users`.`last_name`
`users`.`gender`
`users`.`dob`
`users`.`phone`
`users`.`address`
`users`.`created_at`
`zra_classification_codes`.*
`zra_classification_codes`.`itemClsCd`
`zra_classification_codes`.`itemClsNm`
`zra_classification_codes`.`itemClsLvl`
`zra_classification_codes`.`taxTyCd`
`zra_classification_codes`.`mjrTgYn`
`zra_classification_codes`.`useYn`
`zra_classification_codes`.`created_at`
`zra_classification_codes`.`updated_at`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cd_cls`
`zra_codes`.`cd_cls_nm`
`zra_codes`.`user_dfn_nm1`
`zra_codes`.`cd`
`zra_codes`.`cd_nm`
`zra_codes`.`user_dfn_cd1`
`zra_codes`.`created_at`
`zra_codes`.`updated_at`
`zra_config`.*
`zra_config`.`id`
`zra_config`.`tpin`
`zra_config`.`branch_id`
`zra_config`.`dvcSrlNo`
`zra_config`.`vsdc_base_url`
`zra_config`.`created_at`
`zra_config`.`updated_at`
`zra_imports`.*
`zra_imports`.`id`
`zra_imports`.`taskCd`
`zra_imports`.`dclDe`
`zra_imports`.`itemSeq`
`zra_imports`.`dclNo`
`zra_imports`.`hsCd`
`zra_imports`.`itemCd`
`zra_imports`.`itemNm`
`zra_imports`.`imptItemsttsCd`
`zra_imports`.`orgnNatCd`
`zra_imports`.`exptNatCd`
`zra_imports`.`pkg`
`zra_imports`.`pkgUnitCd`
`zra_imports`.`qty`
`zra_imports`.`qtyUnitCd`
`zra_imports`.`totWt`
`zra_imports`.`netWt`
`zra_imports`.`spplrNm`
`zra_imports`.`agntNm`
`zra_imports`.`invcFcurAmt`
`zra_imports`.`invcFcurCd`
`zra_imports`.`invcFcurExcrt`
`zra_imports`.`dclRefNum`
`zra_imports`.`created_at`
`zra_imports`.`updated_at`
`zra_init`.*
`zra_init`.`id`
`zra_init`.`tin`
`zra_init`.`taxprNm`
`zra_init`.`bsnsActv`
`zra_init`.`bhfId`
`zra_init`.`bhfNm`
`zra_init`.`bhfOpenDt`
`zra_init`.`prvncNm`
`zra_init`.`dstrtNm`
`zra_init`.`sctrNm`
`zra_init`.`locDesc`
`zra_init`.`hqYn`
`zra_init`.`mgrNm`
`zra_init`.`mgrTelNo`
`zra_init`.`mgrEmail`
`zra_init`.`sdcId`
`zra_init`.`mrcNo`
`zra_init`.`lastPchsInvcNo`
`zra_init`.`lastSaleRcptNo`
`zra_init`.`lastInvcNo`
`zra_init`.`lastSaleInvcNo`
`zra_init`.`lastTrainInvcNo`
`zra_init`.`lastProfrmInvcNo`
`zra_init`.`lastCopyInvcNo`
`zra_init`.`created_at`
`zra_init`.`updated_at`
`zra_items`.*
`zra_items`.`id`
`zra_items`.`tpin`
`zra_items`.`bhfId`
`zra_items`.`itemCd`
`zra_items`.`itemClsCd`
`zra_items`.`itemTyCd`
`zra_items`.`itemNm`
`zra_items`.`itemStdNm`
`zra_items`.`orgnNatCd`
`zra_items`.`pkgUnitCd`
`zra_items`.`qtyUnitCd`
`zra_items`.`vatCatCd`
`zra_items`.`iplCatCd`
`zra_items`.`tlCatCd`
`zra_items`.`exciseTxCatCd`
`zra_items`.`btchNo`
`zra_items`.`bcd`
`zra_items`.`dftPrc`
`zra_items`.`manufacturerTpin`
`zra_items`.`manufacturerItemCd`
`zra_items`.`rrp`
`zra_items`.`svcChargeYn`
`zra_items`.`rentalYn`
`zra_items`.`addInfo`
`zra_items`.`sftyQty`
`zra_items`.`isrcAplcbYn`
`zra_items`.`useYn`
`zra_items`.`regrNm`
`zra_items`.`regrId`
`zra_items`.`modrNm`
`zra_items`.`modrId`
`zra_items`.`resultCd`
`zra_items`.`resultMsg`
`zra_items`.`resultDt`
`zra_items`.`created_at`
`zra_items`.`updated_at`
`zra_purchase_items`.*
`zra_purchase_items`.`id`
`zra_purchase_items`.`purchase_id`
`zra_purchase_items`.`itemSeq`
`zra_purchase_items`.`itemCd`
`zra_purchase_items`.`itemClsCd`
`zra_purchase_items`.`itemNm`
`zra_purchase_items`.`bcd`
`zra_purchase_items`.`pkgUnitCd`
`zra_purchase_items`.`pkg`
`zra_purchase_items`.`qtyUnitCd`
`zra_purchase_items`.`qty`
`zra_purchase_items`.`prc`
`zra_purchase_items`.`splyAmt`
`zra_purchase_items`.`dcRt`
`zra_purchase_items`.`dcAmt`
`zra_purchase_items`.`vatCatCd`
`zra_purchase_items`.`iplCatCd`
`zra_purchase_items`.`tlCatCd`
`zra_purchase_items`.`exciseTxCatCd`
`zra_purchase_items`.`vatTaxblAmt`
`zra_purchase_items`.`exciseTaxblAmt`
`zra_purchase_items`.`iplTaxblAmt`
`zra_purchase_items`.`tlTaxblAmt`
`zra_purchase_items`.`taxblAmt`
`zra_purchase_items`.`vatAmt`
`zra_purchase_items`.`iplAmt`
`zra_purchase_items`.`tlAmt`
`zra_purchase_items`.`exciseTxAmt`
`zra_purchase_items`.`totAmt`
`zra_purchase_items`.`created_at`
`zra_purchases`.*
`zra_purchases`.`id`
`zra_purchases`.`cisInvcNo`
`zra_purchases`.`orgInvcNo`
`zra_purchases`.`spplrTpin`
`zra_purchases`.`spplrNm`
`zra_purchases`.`spplrBhfId`
`zra_purchases`.`spplrInvcNo`
`zra_purchases`.`pchsSttsCd`
`zra_purchases`.`rcptTyCd`
`zra_purchases`.`regTyCd`
`zra_purchases`.`pchsTyCd`
`zra_purchases`.`pmtTyCd`
`zra_purchases`.`cfmDt`
`zra_purchases`.`pchsDt`
`zra_purchases`.`salesDt`
`zra_purchases`.`stockRlsDt`
`zra_purchases`.`totItemCnt`
`zra_purchases`.`totTaxblAmt`
`zra_purchases`.`totTaxAmt`
`zra_purchases`.`totAmt`
`zra_purchases`.`remark`
`zra_purchases`.`created_at`
`zra_purchases`.`updated_at`
`zra_sales`.*
`zra_sales`.`id`
`zra_sales`.`tpin`
`zra_sales`.`bhfId`
`zra_sales`.`orgInvcNo`
`zra_sales`.`cisInvcNo`
`zra_sales`.`userId`
`zra_sales`.`custTpin`
`zra_sales`.`custNm`
`zra_sales`.`salesTyCd`
`zra_sales`.`rcptTyCd`
`zra_sales`.`pmtTyCd`
`zra_sales`.`salesSttsCd`
`zra_sales`.`cfmDt`
`zra_sales`.`salesDt`
`zra_sales`.`stockRlsDt`
`zra_sales`.`cnclReqDt`
`zra_sales`.`cnclDt`
`zra_sales`.`rfdDt`
`zra_sales`.`rfdRsnCd`
`zra_sales`.`totItemCnt`
`zra_sales`.`taxblAmtA`
`zra_sales`.`taxblAmtB`
`zra_sales`.`taxblAmtC1`
`zra_sales`.`taxblAmtC2`
`zra_sales`.`taxblAmtC3`
`zra_sales`.`taxblAmtD`
`zra_sales`.`taxblAmtRvat`
`zra_sales`.`taxblAmtE`
`zra_sales`.`taxblAmtF`
`zra_sales`.`taxblAmtIpl1`
`zra_sales`.`taxblAmtIpl2`
`zra_sales`.`taxblAmtTl`
`zra_sales`.`taxblAmtEcm`
`zra_sales`.`taxblAmtExeeg`
`zra_sales`.`taxblAmtTot`
`zra_sales`.`taxRtA`
`zra_sales`.`taxRtB`
`zra_sales`.`taxRtC1`
`zra_sales`.`taxRtC2`
`zra_sales`.`taxRtC3`
`zra_sales`.`taxRtD`
`zra_sales`.`taxRtRvat`
`zra_sales`.`taxRtE`
`zra_sales`.`taxRtF`
`zra_sales`.`taxRtIpl1`
`zra_sales`.`taxRtIpl2`
`zra_sales`.`taxRtTl`
`zra_sales`.`taxRtEcm`
`zra_sales`.`taxRtExeeg`
`zra_sales`.`taxRtTot`
`zra_sales`.`taxAmtA`
`zra_sales`.`taxAmtB`
`zra_sales`.`taxAmtC1`
`zra_sales`.`taxAmtC2`
`zra_sales`.`taxAmtC3`
`zra_sales`.`taxAmtD`
`zra_sales`.`taxAmtRvat`
`zra_sales`.`taxAmtE`
`zra_sales`.`taxAmtF`
`zra_sales`.`taxAmtIpl1`
`zra_sales`.`taxAmtIpl2`
`zra_sales`.`taxAmtTl`
`zra_sales`.`taxAmtEcm`
`zra_sales`.`taxAmtExeeg`
`zra_sales`.`taxAmtTot`
`zra_sales`.`totTaxblAmt`
`zra_sales`.`totTaxAmt`
`zra_sales`.`cashDcRt`
`zra_sales`.`cashDcAmt`
`zra_sales`.`totAmt`
`zra_sales`.`prchrAcptcYn`
`zra_sales`.`remark`
`zra_sales`.`regrId`
`zra_sales`.`regrNm`
`zra_sales`.`modrId`
`zra_sales`.`modrNm`
`zra_sales`.`saleCtyCd`
`zra_sales`.`lpoNumber`
`zra_sales`.`currencyTyCd`
`zra_sales`.`exchangeRt`
`zra_sales`.`destnCountryCd`
`zra_sales`.`dbtRsnCd`
`zra_sales`.`invcAdjust`
`zra_sales`.`resultCd`
`zra_sales`.`resultMsg`
`zra_sales`.`resultDt`
`zra_sales`.`rcptNo`
`zra_sales`.`intrlData`
`zra_sales`.`rcptSign`
`zra_sales`.`vsdcRcptPbctDate`
`zra_sales`.`sdcId`
`zra_sales`.`mrcNo`
`zra_sales`.`qrCodeUrl`
`zra_sales`.`prnt`
`zra_sales`.`created_at`
`zra_sales`.`updated_at`
`zra_sales_items`.*
`zra_sales_items`.`id`
`zra_sales_items`.`sales_id`
`zra_sales_items`.`itemSeq`
`zra_sales_items`.`itemCd`
`zra_sales_items`.`itemClsCd`
`zra_sales_items`.`itemNm`
`zra_sales_items`.`bcd`
`zra_sales_items`.`pkgUnitCd`
`zra_sales_items`.`pkg`
`zra_sales_items`.`qtyUnitCd`
`zra_sales_items`.`qty`
`zra_sales_items`.`prc`
`zra_sales_items`.`splyAmt`
`zra_sales_items`.`dcRt`
`zra_sales_items`.`dcAmt`
`zra_sales_items`.`isrccCd`
`zra_sales_items`.`isrccNm`
`zra_sales_items`.`isrcRt`
`zra_sales_items`.`isrcAmt`
`zra_sales_items`.`vatCatCd`
`zra_sales_items`.`exciseTxCatCd`
`zra_sales_items`.`vatTaxblAmt`
`zra_sales_items`.`exciseTaxblAmt`
`zra_sales_items`.`vatAmt`
`zra_sales_items`.`exciseTxAmt`
`zra_sales_items`.`totAmt`
`zra_sales_items`.`created_at`
`zra_stock`.*
`zra_stock`.`id`
`zra_stock`.`sarNo`
`zra_stock`.`orgSarNo`
`zra_stock`.`regTyCd`
`zra_stock`.`custTpin`
`zra_stock`.`custNm`
`zra_stock`.`custBhfId`
`zra_stock`.`sarTyCd`
`zra_stock`.`ocrnDt`
`zra_stock`.`totItemCnt`
`zra_stock`.`totTaxblAmt`
`zra_stock`.`totTaxAmt`
`zra_stock`.`totAmt`
`zra_stock`.`remark`
`zra_stock`.`regrId`
`zra_stock`.`regrNm`
`zra_stock`.`modrNm`
`zra_stock`.`modrId`
`zra_stock`.`created_at`
`zra_stock`.`updated_at`
`zra_stock_items`.*
`zra_stock_items`.`id`
`zra_stock_items`.`stock_id`
`zra_stock_items`.`itemSeq`
`zra_stock_items`.`itemCd`
`zra_stock_items`.`itemNm`
`zra_stock_items`.`pkgUnitCd`
`zra_stock_items`.`qtyUnitCd`
`zra_stock_items`.`pkg`
`zra_stock_items`.`qty`
`zra_stock_items`.`prc`
`zra_stock_items`.`totDcAmt`
`zra_stock_items`.`splyAmt`
`zra_stock_items`.`taxblAmt`
`zra_stock_items`.`vatCatCd`
`zra_stock_items`.`taxAmt`
`zra_stock_items`.`totAmt`
`zra_stock_items`.`created_at`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`itemNm`
`zra_stock_master`.`qty`
`zra_stock_master`.`created_at`
`zra_stock_master`.`updated_at`
`zra_stock_transfer`.*
`zra_stock_transfer`.`id`
`zra_stock_transfer`.`itemCd`
`zra_stock_transfer`.`movement_type`
`zra_stock_transfer`.`created_at`
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`product_id`
`cart`.`strength_id`
`cart`.`quantity`
`cart`.`price`
`cart`.`name`
`cart`.`measurement`
`cart`.`image`
`cart`.`created_at`
`cart`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`parent_id`
`categories`.`description`
`categories`.`image_url`
`categories`.`is_active`
`categories`.`display_order`
`categories`.`slug`
`categories`.`created_at`
`categories`.`updated_at`
`configs`.*
`configs`.`id`
`configs`.`config_key`
`configs`.`config_value`
`consultant_availability`.*
`consultant_availability`.`id`
`consultant_availability`.`consultant_id`
`consultant_availability`.`day`
`consultant_availability`.`time_slot`
`consultations`.*
`consultations`.`id`
`consultations`.`user_id`
`consultations`.`consultant_id`
`consultations`.`type`
`consultations`.`date_time`
`consultations`.`status`
`consultations`.`summary`
`consultations`.`google_meet_link`
`consultations`.`fee`
`consultations`.`clinic_address`
`consultations`.`created_at`
`content_sections`.*
`content_sections`.`id`
`content_sections`.`page`
`content_sections`.`section_name`
`content_sections`.`content`
`content_sections`.`image`
`delivery`.*
`delivery`.`id`
`delivery`.`user_id`
`delivery`.`billing_gender`
`delivery`.`billing_dob`
`delivery`.`billing_title`
`delivery`.`billing_first_name`
`delivery`.`billing_last_name`
`delivery`.`billing_email`
`delivery`.`billing_phone`
`delivery`.`billing_street`
`delivery`.`billing_apartment`
`delivery`.`billing_city`
`delivery`.`billing_county`
`delivery`.`billing_postal_code`
`delivery`.`billing_country`
`delivery`.`shipping_street`
`delivery`.`shipping_city`
`delivery`.`shipping_county`
`delivery`.`shipping_postal_code`
`delivery`.`shipping_country`
`delivery`.`order_notes`
`delivery`.`created_at`
`dpo_config`.*
`dpo_config`.`id`
`dpo_config`.`company_token`
`dpo_config`.`company_token_iv`
`dpo_config`.`api_endpoint`
`dpo_config`.`payment_url`
`dpo_config`.`redirect_url`
`dpo_config`.`service_type`
`dpo_config`.`created_at`
`dpo_config`.`updated_at`
`gallery_images`.*
`gallery_images`.`id`
`gallery_images`.`image_url`
`gallery_images`.`alt_text`
`gallery_images`.`created_at`
`medicine_strengths`.*
`medicine_strengths`.`id`
`medicine_strengths`.`medicine_id`
`medicine_strengths`.`measurement`
`medicine_strengths`.`price`
`medicine_strengths`.`inStock`
`medicine_strengths`.`created_at`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`shortDescription`
`medicines`.`description`
`medicines`.`image`
`medicines`.`price`
`medicines`.`originalPrice`
`medicines`.`stock`
`medicines`.`isControlled`
`medicines`.`is_disabled`
`medicines`.`category_id`
`medicines`.`subcategory_id`
`medicines`.`max_quantity`
`medicines`.`activeIngredient`
`medicines`.`side_effects`
`medicines`.`dosageInstructions`
`medicines`.`rating`
`medicines`.`reviewCount`
`medicines`.`manufacturer`
`medicines`.`supplier`
`medicines`.`barcode`
`medicines`.`batch_number`
`medicines`.`expiry_date`
`medicines`.`vat_rate`
`medicines`.`created_at`
`order_items`.*
`order_items`.`id`
`order_items`.`order_id`
`order_items`.`product_id`
`order_items`.`strength_id`
`order_items`.`quantity`
`order_items`.`price`
`order_items`.`prescription_path`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`delivery_id`
`orders`.`total`
`orders`.`status`
`orders`.`payment_status`
`orders`.`transaction_id`
`orders`.`gateway_transaction_id`
`orders`.`prnt`
`orders`.`incomplete`
`orders`.`billing_details`
`orders`.`shipping_details`
`orders`.`order_notes`
`orders`.`created_at`
`prescription_items`.*
`prescription_items`.`id`
`prescription_items`.`prescription_id`
`prescription_items`.`medicine_id`
`prescription_items`.`strength_id`
`prescription_items`.`quantity`
`prescription_items`.`approved_quantity`
`prescription_items`.`created_at`
`prescriptions`.*
`prescriptions`.`id`
`prescriptions`.`user_id`
`prescriptions`.`consultant_id`
`prescriptions`.`status`
`prescriptions`.`notes`
`prescriptions`.`created_at`
`refunds`.*
`refunds`.`id`
`refunds`.`user_id`
`refunds`.`order_id`
`refunds`.`consultation_id`
`refunds`.`cisInvcNo`
`refunds`.`reason`
`refunds`.`remarks`
`refunds`.`image_path`
`refunds`.`status`
`refunds`.`created_at`
`team_members`.*
`team_members`.`id`
`team_members`.`name`
`team_members`.`role`
`team_members`.`image_url`
`team_members`.`specialization`
`team_members`.`created_at`
`testimonials`.*
`testimonials`.`id`
`testimonials`.`name`
`testimonials`.`role`
`testimonials`.`image_url`
`testimonials`.`rating`
`testimonials`.`comment`
`testimonials`.`created_at`
`users`.*
`users`.`id`
`users`.`role`
`users`.`email`
`users`.`password`
`users`.`first_name`
`users`.`last_name`
`users`.`gender`
`users`.`dob`
`users`.`phone`
`users`.`address`
`users`.`created_at`
`zra_classification_codes`.*
`zra_classification_codes`.`itemClsCd`
`zra_classification_codes`.`itemClsNm`
`zra_classification_codes`.`itemClsLvl`
`zra_classification_codes`.`taxTyCd`
`zra_classification_codes`.`mjrTgYn`
`zra_classification_codes`.`useYn`
`zra_classification_codes`.`created_at`
`zra_classification_codes`.`updated_at`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cd_cls`
`zra_codes`.`cd_cls_nm`
`zra_codes`.`user_dfn_nm1`
`zra_codes`.`cd`
`zra_codes`.`cd_nm`
`zra_codes`.`user_dfn_cd1`
`zra_codes`.`created_at`
`zra_codes`.`updated_at`
`zra_config`.*
`zra_config`.`id`
`zra_config`.`tpin`
`zra_config`.`branch_id`
`zra_config`.`dvcSrlNo`
`zra_config`.`vsdc_base_url`
`zra_config`.`created_at`
`zra_config`.`updated_at`
`zra_imports`.*
`zra_imports`.`id`
`zra_imports`.`taskCd`
`zra_imports`.`dclDe`
`zra_imports`.`itemSeq`
`zra_imports`.`dclNo`
`zra_imports`.`hsCd`
`zra_imports`.`itemCd`
`zra_imports`.`itemNm`
`zra_imports`.`imptItemsttsCd`
`zra_imports`.`orgnNatCd`
`zra_imports`.`exptNatCd`
`zra_imports`.`pkg`
`zra_imports`.`pkgUnitCd`
`zra_imports`.`qty`
`zra_imports`.`qtyUnitCd`
`zra_imports`.`totWt`
`zra_imports`.`netWt`
`zra_imports`.`spplrNm`
`zra_imports`.`agntNm`
`zra_imports`.`invcFcurAmt`
`zra_imports`.`invcFcurCd`
`zra_imports`.`invcFcurExcrt`
`zra_imports`.`dclRefNum`
`zra_imports`.`created_at`
`zra_imports`.`updated_at`
`zra_init`.*
`zra_init`.`id`
`zra_init`.`tin`
`zra_init`.`taxprNm`
`zra_init`.`bsnsActv`
`zra_init`.`bhfId`
`zra_init`.`bhfNm`
`zra_init`.`bhfOpenDt`
`zra_init`.`prvncNm`
`zra_init`.`dstrtNm`
`zra_init`.`sctrNm`
`zra_init`.`locDesc`
`zra_init`.`hqYn`
`zra_init`.`mgrNm`
`zra_init`.`mgrTelNo`
`zra_init`.`mgrEmail`
`zra_init`.`sdcId`
`zra_init`.`mrcNo`
`zra_init`.`lastPchsInvcNo`
`zra_init`.`lastSaleRcptNo`
`zra_init`.`lastInvcNo`
`zra_init`.`lastSaleInvcNo`
`zra_init`.`lastTrainInvcNo`
`zra_init`.`lastProfrmInvcNo`
`zra_init`.`lastCopyInvcNo`
`zra_init`.`created_at`
`zra_init`.`updated_at`
`zra_items`.*
`zra_items`.`id`
`zra_items`.`tpin`
`zra_items`.`bhfId`
`zra_items`.`itemCd`
`zra_items`.`itemClsCd`
`zra_items`.`itemTyCd`
`zra_items`.`itemNm`
`zra_items`.`itemStdNm`
`zra_items`.`orgnNatCd`
`zra_items`.`pkgUnitCd`
`zra_items`.`qtyUnitCd`
`zra_items`.`vatCatCd`
`zra_items`.`iplCatCd`
`zra_items`.`tlCatCd`
`zra_items`.`exciseTxCatCd`
`zra_items`.`btchNo`
`zra_items`.`bcd`
`zra_items`.`dftPrc`
`zra_items`.`manufacturerTpin`
`zra_items`.`manufacturerItemCd`
`zra_items`.`rrp`
`zra_items`.`svcChargeYn`
`zra_items`.`rentalYn`
`zra_items`.`addInfo`
`zra_items`.`sftyQty`
`zra_items`.`isrcAplcbYn`
`zra_items`.`useYn`
`zra_items`.`regrNm`
`zra_items`.`regrId`
`zra_items`.`modrNm`
`zra_items`.`modrId`
`zra_items`.`resultCd`
`zra_items`.`resultMsg`
`zra_items`.`resultDt`
`zra_items`.`created_at`
`zra_items`.`updated_at`
`zra_purchase_items`.*
`zra_purchase_items`.`id`
`zra_purchase_items`.`purchase_id`
`zra_purchase_items`.`itemSeq`
`zra_purchase_items`.`itemCd`
`zra_purchase_items`.`itemClsCd`
`zra_purchase_items`.`itemNm`
`zra_purchase_items`.`bcd`
`zra_purchase_items`.`pkgUnitCd`
`zra_purchase_items`.`pkg`
`zra_purchase_items`.`qtyUnitCd`
`zra_purchase_items`.`qty`
`zra_purchase_items`.`prc`
`zra_purchase_items`.`splyAmt`
`zra_purchase_items`.`dcRt`
`zra_purchase_items`.`dcAmt`
`zra_purchase_items`.`vatCatCd`
`zra_purchase_items`.`iplCatCd`
`zra_purchase_items`.`tlCatCd`
`zra_purchase_items`.`exciseTxCatCd`
`zra_purchase_items`.`vatTaxblAmt`
`zra_purchase_items`.`exciseTaxblAmt`
`zra_purchase_items`.`iplTaxblAmt`
`zra_purchase_items`.`tlTaxblAmt`
`zra_purchase_items`.`taxblAmt`
`zra_purchase_items`.`vatAmt`
`zra_purchase_items`.`iplAmt`
`zra_purchase_items`.`tlAmt`
`zra_purchase_items`.`exciseTxAmt`
`zra_purchase_items`.`totAmt`
`zra_purchase_items`.`created_at`
`zra_purchases`.*
`zra_purchases`.`id`
`zra_purchases`.`cisInvcNo`
`zra_purchases`.`orgInvcNo`
`zra_purchases`.`spplrTpin`
`zra_purchases`.`spplrNm`
`zra_purchases`.`spplrBhfId`
`zra_purchases`.`spplrInvcNo`
`zra_purchases`.`pchsSttsCd`
`zra_purchases`.`rcptTyCd`
`zra_purchases`.`regTyCd`
`zra_purchases`.`pchsTyCd`
`zra_purchases`.`pmtTyCd`
`zra_purchases`.`cfmDt`
`zra_purchases`.`pchsDt`
`zra_purchases`.`salesDt`
`zra_purchases`.`stockRlsDt`
`zra_purchases`.`totItemCnt`
`zra_purchases`.`totTaxblAmt`
`zra_purchases`.`totTaxAmt`
`zra_purchases`.`totAmt`
`zra_purchases`.`remark`
`zra_purchases`.`created_at`
`zra_purchases`.`updated_at`
`zra_sales`.*
`zra_sales`.`id`
`zra_sales`.`tpin`
`zra_sales`.`bhfId`
`zra_sales`.`orgInvcNo`
`zra_sales`.`cisInvcNo`
`zra_sales`.`userId`
`zra_sales`.`custTpin`
`zra_sales`.`custNm`
`zra_sales`.`salesTyCd`
`zra_sales`.`rcptTyCd`
`zra_sales`.`pmtTyCd`
`zra_sales`.`salesSttsCd`
`zra_sales`.`cfmDt`
`zra_sales`.`salesDt`
`zra_sales`.`stockRlsDt`
`zra_sales`.`cnclReqDt`
`zra_sales`.`cnclDt`
`zra_sales`.`rfdDt`
`zra_sales`.`rfdRsnCd`
`zra_sales`.`totItemCnt`
`zra_sales`.`taxblAmtA`
`zra_sales`.`taxblAmtB`
`zra_sales`.`taxblAmtC1`
`zra_sales`.`taxblAmtC2`
`zra_sales`.`taxblAmtC3`
`zra_sales`.`taxblAmtD`
`zra_sales`.`taxblAmtRvat`
`zra_sales`.`taxblAmtE`
`zra_sales`.`taxblAmtF`
`zra_sales`.`taxblAmtIpl1`
`zra_sales`.`taxblAmtIpl2`
`zra_sales`.`taxblAmtTl`
`zra_sales`.`taxblAmtEcm`
`zra_sales`.`taxblAmtExeeg`
`zra_sales`.`taxblAmtTot`
`zra_sales`.`taxRtA`
`zra_sales`.`taxRtB`
`zra_sales`.`taxRtC1`
`zra_sales`.`taxRtC2`
`zra_sales`.`taxRtC3`
`zra_sales`.`taxRtD`
`zra_sales`.`taxRtRvat`
`zra_sales`.`taxRtE`
`zra_sales`.`taxRtF`
`zra_sales`.`taxRtIpl1`
`zra_sales`.`taxRtIpl2`
`zra_sales`.`taxRtTl`
`zra_sales`.`taxRtEcm`
`zra_sales`.`taxRtExeeg`
`zra_sales`.`taxRtTot`
`zra_sales`.`taxAmtA`
`zra_sales`.`taxAmtB`
`zra_sales`.`taxAmtC1`
`zra_sales`.`taxAmtC2`
`zra_sales`.`taxAmtC3`
`zra_sales`.`taxAmtD`
`zra_sales`.`taxAmtRvat`
`zra_sales`.`taxAmtE`
`zra_sales`.`taxAmtF`
`zra_sales`.`taxAmtIpl1`
`zra_sales`.`taxAmtIpl2`
`zra_sales`.`taxAmtTl`
`zra_sales`.`taxAmtEcm`
`zra_sales`.`taxAmtExeeg`
`zra_sales`.`taxAmtTot`
`zra_sales`.`totTaxblAmt`
`zra_sales`.`totTaxAmt`
`zra_sales`.`cashDcRt`
`zra_sales`.`cashDcAmt`
`zra_sales`.`totAmt`
`zra_sales`.`prchrAcptcYn`
`zra_sales`.`remark`
`zra_sales`.`regrId`
`zra_sales`.`regrNm`
`zra_sales`.`modrId`
`zra_sales`.`modrNm`
`zra_sales`.`saleCtyCd`
`zra_sales`.`lpoNumber`
`zra_sales`.`currencyTyCd`
`zra_sales`.`exchangeRt`
`zra_sales`.`destnCountryCd`
`zra_sales`.`dbtRsnCd`
`zra_sales`.`invcAdjust`
`zra_sales`.`resultCd`
`zra_sales`.`resultMsg`
`zra_sales`.`resultDt`
`zra_sales`.`rcptNo`
`zra_sales`.`intrlData`
`zra_sales`.`rcptSign`
`zra_sales`.`vsdcRcptPbctDate`
`zra_sales`.`sdcId`
`zra_sales`.`mrcNo`
`zra_sales`.`qrCodeUrl`
`zra_sales`.`prnt`
`zra_sales`.`created_at`
`zra_sales`.`updated_at`
`zra_sales_items`.*
`zra_sales_items`.`id`
`zra_sales_items`.`sales_id`
`zra_sales_items`.`itemSeq`
`zra_sales_items`.`itemCd`
`zra_sales_items`.`itemClsCd`
`zra_sales_items`.`itemNm`
`zra_sales_items`.`bcd`
`zra_sales_items`.`pkgUnitCd`
`zra_sales_items`.`pkg`
`zra_sales_items`.`qtyUnitCd`
`zra_sales_items`.`qty`
`zra_sales_items`.`prc`
`zra_sales_items`.`splyAmt`
`zra_sales_items`.`dcRt`
`zra_sales_items`.`dcAmt`
`zra_sales_items`.`isrccCd`
`zra_sales_items`.`isrccNm`
`zra_sales_items`.`isrcRt`
`zra_sales_items`.`isrcAmt`
`zra_sales_items`.`vatCatCd`
`zra_sales_items`.`exciseTxCatCd`
`zra_sales_items`.`vatTaxblAmt`
`zra_sales_items`.`exciseTaxblAmt`
`zra_sales_items`.`vatAmt`
`zra_sales_items`.`exciseTxAmt`
`zra_sales_items`.`totAmt`
`zra_sales_items`.`created_at`
`zra_stock`.*
`zra_stock`.`id`
`zra_stock`.`sarNo`
`zra_stock`.`orgSarNo`
`zra_stock`.`regTyCd`
`zra_stock`.`custTpin`
`zra_stock`.`custNm`
`zra_stock`.`custBhfId`
`zra_stock`.`sarTyCd`
`zra_stock`.`ocrnDt`
`zra_stock`.`totItemCnt`
`zra_stock`.`totTaxblAmt`
`zra_stock`.`totTaxAmt`
`zra_stock`.`totAmt`
`zra_stock`.`remark`
`zra_stock`.`regrId`
`zra_stock`.`regrNm`
`zra_stock`.`modrNm`
`zra_stock`.`modrId`
`zra_stock`.`created_at`
`zra_stock`.`updated_at`
`zra_stock_items`.*
`zra_stock_items`.`id`
`zra_stock_items`.`stock_id`
`zra_stock_items`.`itemSeq`
`zra_stock_items`.`itemCd`
`zra_stock_items`.`itemNm`
`zra_stock_items`.`pkgUnitCd`
`zra_stock_items`.`qtyUnitCd`
`zra_stock_items`.`pkg`
`zra_stock_items`.`qty`
`zra_stock_items`.`prc`
`zra_stock_items`.`totDcAmt`
`zra_stock_items`.`splyAmt`
`zra_stock_items`.`taxblAmt`
`zra_stock_items`.`vatCatCd`
`zra_stock_items`.`taxAmt`
`zra_stock_items`.`totAmt`
`zra_stock_items`.`created_at`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`itemNm`
`zra_stock_master`.`qty`
`zra_stock_master`.`created_at`
`zra_stock_master`.`updated_at`
`zra_stock_transfer`.*
`zra_stock_transfer`.`id`
`zra_stock_transfer`.`itemCd`
`zra_stock_transfer`.`movement_type`
`zra_stock_transfer`.`created_at`
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`product_id`
`cart`.`strength_id`
`cart`.`quantity`
`cart`.`price`
`cart`.`name`
`cart`.`measurement`
`cart`.`image`
`cart`.`created_at`
`cart`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`parent_id`
`categories`.`description`
`categories`.`image_url`
`categories`.`is_active`
`categories`.`display_order`
`categories`.`slug`
`categories`.`created_at`
`categories`.`updated_at`
`configs`.*
`configs`.`id`
`configs`.`config_key`
`configs`.`config_value`
`consultant_availability`.*
`consultant_availability`.`id`
`consultant_availability`.`consultant_id`
`consultant_availability`.`day`
`consultant_availability`.`time_slot`
`consultations`.*
`consultations`.`id`
`consultations`.`user_id`
`consultations`.`consultant_id`
`consultations`.`type`
`consultations`.`date_time`
`consultations`.`status`
`consultations`.`summary`
`consultations`.`google_meet_link`
`consultations`.`fee`
`consultations`.`clinic_address`
`consultations`.`created_at`
`content_sections`.*
`content_sections`.`id`
`content_sections`.`page`
`content_sections`.`section_name`
`content_sections`.`content`
`content_sections`.`image`
`delivery`.*
`delivery`.`id`
`delivery`.`user_id`
`delivery`.`billing_gender`
`delivery`.`billing_dob`
`delivery`.`billing_title`
`delivery`.`billing_first_name`
`delivery`.`billing_last_name`
`delivery`.`billing_email`
`delivery`.`billing_phone`
`delivery`.`billing_street`
`delivery`.`billing_apartment`
`delivery`.`billing_city`
`delivery`.`billing_county`
`delivery`.`billing_postal_code`
`delivery`.`billing_country`
`delivery`.`shipping_street`
`delivery`.`shipping_city`
`delivery`.`shipping_county`
`delivery`.`shipping_postal_code`
`delivery`.`shipping_country`
`delivery`.`order_notes`
`delivery`.`created_at`
`dpo_config`.*
`dpo_config`.`id`
`dpo_config`.`company_token`
`dpo_config`.`company_token_iv`
`dpo_config`.`api_endpoint`
`dpo_config`.`payment_url`
`dpo_config`.`redirect_url`
`dpo_config`.`service_type`
`dpo_config`.`created_at`
`dpo_config`.`updated_at`
`gallery_images`.*
`gallery_images`.`id`
`gallery_images`.`image_url`
`gallery_images`.`alt_text`
`gallery_images`.`created_at`
`medicine_strengths`.*
`medicine_strengths`.`id`
`medicine_strengths`.`medicine_id`
`medicine_strengths`.`measurement`
`medicine_strengths`.`price`
`medicine_strengths`.`inStock`
`medicine_strengths`.`created_at`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`shortDescription`
`medicines`.`description`
`medicines`.`image`
`medicines`.`price`
`medicines`.`originalPrice`
`medicines`.`stock`
`medicines`.`isControlled`
`medicines`.`is_disabled`
`medicines`.`category_id`
`medicines`.`subcategory_id`
`medicines`.`max_quantity`
`medicines`.`activeIngredient`
`medicines`.`side_effects`
`medicines`.`dosageInstructions`
`medicines`.`rating`
`medicines`.`reviewCount`
`medicines`.`manufacturer`
`medicines`.`supplier`
`medicines`.`barcode`
`medicines`.`batch_number`
`medicines`.`expiry_date`
`medicines`.`vat_rate`
`medicines`.`created_at`
`order_items`.*
`order_items`.`id`
`order_items`.`order_id`
`order_items`.`product_id`
`order_items`.`strength_id`
`order_items`.`quantity`
`order_items`.`price`
`order_items`.`prescription_path`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`delivery_id`
`orders`.`total`
`orders`.`status`
`orders`.`payment_status`
`orders`.`transaction_id`
`orders`.`gateway_transaction_id`
`orders`.`prnt`
`orders`.`incomplete`
`orders`.`billing_details`
`orders`.`shipping_details`
`orders`.`order_notes`
`orders`.`created_at`
`prescription_items`.*
`prescription_items`.`id`
`prescription_items`.`prescription_id`
`prescription_items`.`medicine_id`
`prescription_items`.`strength_id`
`prescription_items`.`quantity`
`prescription_items`.`approved_quantity`
`prescription_items`.`created_at`
`prescriptions`.*
`prescriptions`.`id`
`prescriptions`.`user_id`
`prescriptions`.`consultant_id`
`prescriptions`.`status`
`prescriptions`.`notes`
`prescriptions`.`created_at`
`refunds`.*
`refunds`.`id`
`refunds`.`user_id`
`refunds`.`order_id`
`refunds`.`consultation_id`
`refunds`.`cisInvcNo`
`refunds`.`reason`
`refunds`.`remarks`
`refunds`.`image_path`
`refunds`.`status`
`refunds`.`created_at`
`team_members`.*
`team_members`.`id`
`team_members`.`name`
`team_members`.`role`
`team_members`.`image_url`
`team_members`.`specialization`
`team_members`.`created_at`
`testimonials`.*
`testimonials`.`id`
`testimonials`.`name`
`testimonials`.`role`
`testimonials`.`image_url`
`testimonials`.`rating`
`testimonials`.`comment`
`testimonials`.`created_at`
`users`.*
`users`.`id`
`users`.`role`
`users`.`email`
`users`.`password`
`users`.`first_name`
`users`.`last_name`
`users`.`gender`
`users`.`dob`
`users`.`phone`
`users`.`address`
`users`.`created_at`
`zra_classification_codes`.*
`zra_classification_codes`.`itemClsCd`
`zra_classification_codes`.`itemClsNm`
`zra_classification_codes`.`itemClsLvl`
`zra_classification_codes`.`taxTyCd`
`zra_classification_codes`.`mjrTgYn`
`zra_classification_codes`.`useYn`
`zra_classification_codes`.`created_at`
`zra_classification_codes`.`updated_at`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cd_cls`
`zra_codes`.`cd_cls_nm`
`zra_codes`.`user_dfn_nm1`
`zra_codes`.`cd`
`zra_codes`.`cd_nm`
`zra_codes`.`user_dfn_cd1`
`zra_codes`.`created_at`
`zra_codes`.`updated_at`
`zra_config`.*
`zra_config`.`id`
`zra_config`.`tpin`
`zra_config`.`branch_id`
`zra_config`.`dvcSrlNo`
`zra_config`.`vsdc_base_url`
`zra_config`.`created_at`
`zra_config`.`updated_at`
`zra_imports`.*
`zra_imports`.`id`
`zra_imports`.`taskCd`
`zra_imports`.`dclDe`
`zra_imports`.`itemSeq`
`zra_imports`.`dclNo`
`zra_imports`.`hsCd`
`zra_imports`.`itemCd`
`zra_imports`.`itemNm`
`zra_imports`.`imptItemsttsCd`
`zra_imports`.`orgnNatCd`
`zra_imports`.`exptNatCd`
`zra_imports`.`pkg`
`zra_imports`.`pkgUnitCd`
`zra_imports`.`qty`
`zra_imports`.`qtyUnitCd`
`zra_imports`.`totWt`
`zra_imports`.`netWt`
`zra_imports`.`spplrNm`
`zra_imports`.`agntNm`
`zra_imports`.`invcFcurAmt`
`zra_imports`.`invcFcurCd`
`zra_imports`.`invcFcurExcrt`
`zra_imports`.`dclRefNum`
`zra_imports`.`created_at`
`zra_imports`.`updated_at`
`zra_init`.*
`zra_init`.`id`
`zra_init`.`tin`
`zra_init`.`taxprNm`
`zra_init`.`bsnsActv`
`zra_init`.`bhfId`
`zra_init`.`bhfNm`
`zra_init`.`bhfOpenDt`
`zra_init`.`prvncNm`
`zra_init`.`dstrtNm`
`zra_init`.`sctrNm`
`zra_init`.`locDesc`
`zra_init`.`hqYn`
`zra_init`.`mgrNm`
`zra_init`.`mgrTelNo`
`zra_init`.`mgrEmail`
`zra_init`.`sdcId`
`zra_init`.`mrcNo`
`zra_init`.`lastPchsInvcNo`
`zra_init`.`lastSaleRcptNo`
`zra_init`.`lastInvcNo`
`zra_init`.`lastSaleInvcNo`
`zra_init`.`lastTrainInvcNo`
`zra_init`.`lastProfrmInvcNo`
`zra_init`.`lastCopyInvcNo`
`zra_init`.`created_at`
`zra_init`.`updated_at`
`zra_items`.*
`zra_items`.`id`
`zra_items`.`tpin`
`zra_items`.`bhfId`
`zra_items`.`itemCd`
`zra_items`.`itemClsCd`
`zra_items`.`itemTyCd`
`zra_items`.`itemNm`
`zra_items`.`itemStdNm`
`zra_items`.`orgnNatCd`
`zra_items`.`pkgUnitCd`
`zra_items`.`qtyUnitCd`
`zra_items`.`vatCatCd`
`zra_items`.`iplCatCd`
`zra_items`.`tlCatCd`
`zra_items`.`exciseTxCatCd`
`zra_items`.`btchNo`
`zra_items`.`bcd`
`zra_items`.`dftPrc`
`zra_items`.`manufacturerTpin`
`zra_items`.`manufacturerItemCd`
`zra_items`.`rrp`
`zra_items`.`svcChargeYn`
`zra_items`.`rentalYn`
`zra_items`.`addInfo`
`zra_items`.`sftyQty`
`zra_items`.`isrcAplcbYn`
`zra_items`.`useYn`
`zra_items`.`regrNm`
`zra_items`.`regrId`
`zra_items`.`modrNm`
`zra_items`.`modrId`
`zra_items`.`resultCd`
`zra_items`.`resultMsg`
`zra_items`.`resultDt`
`zra_items`.`created_at`
`zra_items`.`updated_at`
`zra_purchase_items`.*
`zra_purchase_items`.`id`
`zra_purchase_items`.`purchase_id`
`zra_purchase_items`.`itemSeq`
`zra_purchase_items`.`itemCd`
`zra_purchase_items`.`itemClsCd`
`zra_purchase_items`.`itemNm`
`zra_purchase_items`.`bcd`
`zra_purchase_items`.`pkgUnitCd`
`zra_purchase_items`.`pkg`
`zra_purchase_items`.`qtyUnitCd`
`zra_purchase_items`.`qty`
`zra_purchase_items`.`prc`
`zra_purchase_items`.`splyAmt`
`zra_purchase_items`.`dcRt`
`zra_purchase_items`.`dcAmt`
`zra_purchase_items`.`vatCatCd`
`zra_purchase_items`.`iplCatCd`
`zra_purchase_items`.`tlCatCd`
`zra_purchase_items`.`exciseTxCatCd`
`zra_purchase_items`.`vatTaxblAmt`
`zra_purchase_items`.`exciseTaxblAmt`
`zra_purchase_items`.`iplTaxblAmt`
`zra_purchase_items`.`tlTaxblAmt`
`zra_purchase_items`.`taxblAmt`
`zra_purchase_items`.`vatAmt`
`zra_purchase_items`.`iplAmt`
`zra_purchase_items`.`tlAmt`
`zra_purchase_items`.`exciseTxAmt`
`zra_purchase_items`.`totAmt`
`zra_purchase_items`.`created_at`
`zra_purchases`.*
`zra_purchases`.`id`
`zra_purchases`.`cisInvcNo`
`zra_purchases`.`orgInvcNo`
`zra_purchases`.`spplrTpin`
`zra_purchases`.`spplrNm`
`zra_purchases`.`spplrBhfId`
`zra_purchases`.`spplrInvcNo`
`zra_purchases`.`pchsSttsCd`
`zra_purchases`.`rcptTyCd`
`zra_purchases`.`regTyCd`
`zra_purchases`.`pchsTyCd`
`zra_purchases`.`pmtTyCd`
`zra_purchases`.`cfmDt`
`zra_purchases`.`pchsDt`
`zra_purchases`.`salesDt`
`zra_purchases`.`stockRlsDt`
`zra_purchases`.`totItemCnt`
`zra_purchases`.`totTaxblAmt`
`zra_purchases`.`totTaxAmt`
`zra_purchases`.`totAmt`
`zra_purchases`.`remark`
`zra_purchases`.`created_at`
`zra_purchases`.`updated_at`
`zra_sales`.*
`zra_sales`.`id`
`zra_sales`.`tpin`
`zra_sales`.`bhfId`
`zra_sales`.`orgInvcNo`
`zra_sales`.`cisInvcNo`
`zra_sales`.`userId`
`zra_sales`.`custTpin`
`zra_sales`.`custNm`
`zra_sales`.`salesTyCd`
`zra_sales`.`rcptTyCd`
`zra_sales`.`pmtTyCd`
`zra_sales`.`salesSttsCd`
`zra_sales`.`cfmDt`
`zra_sales`.`salesDt`
`zra_sales`.`stockRlsDt`
`zra_sales`.`cnclReqDt`
`zra_sales`.`cnclDt`
`zra_sales`.`rfdDt`
`zra_sales`.`rfdRsnCd`
`zra_sales`.`totItemCnt`
`zra_sales`.`taxblAmtA`
`zra_sales`.`taxblAmtB`
`zra_sales`.`taxblAmtC1`
`zra_sales`.`taxblAmtC2`
`zra_sales`.`taxblAmtC3`
`zra_sales`.`taxblAmtD`
`zra_sales`.`taxblAmtRvat`
`zra_sales`.`taxblAmtE`
`zra_sales`.`taxblAmtF`
`zra_sales`.`taxblAmtIpl1`
`zra_sales`.`taxblAmtIpl2`
`zra_sales`.`taxblAmtTl`
`zra_sales`.`taxblAmtEcm`
`zra_sales`.`taxblAmtExeeg`
`zra_sales`.`taxblAmtTot`
`zra_sales`.`taxRtA`
`zra_sales`.`taxRtB`
`zra_sales`.`taxRtC1`
`zra_sales`.`taxRtC2`
`zra_sales`.`taxRtC3`
`zra_sales`.`taxRtD`
`zra_sales`.`taxRtRvat`
`zra_sales`.`taxRtE`
`zra_sales`.`taxRtF`
`zra_sales`.`taxRtIpl1`
`zra_sales`.`taxRtIpl2`
`zra_sales`.`taxRtTl`
`zra_sales`.`taxRtEcm`
`zra_sales`.`taxRtExeeg`
`zra_sales`.`taxRtTot`
`zra_sales`.`taxAmtA`
`zra_sales`.`taxAmtB`
`zra_sales`.`taxAmtC1`
`zra_sales`.`taxAmtC2`
`zra_sales`.`taxAmtC3`
`zra_sales`.`taxAmtD`
`zra_sales`.`taxAmtRvat`
`zra_sales`.`taxAmtE`
`zra_sales`.`taxAmtF`
`zra_sales`.`taxAmtIpl1`
`zra_sales`.`taxAmtIpl2`
`zra_sales`.`taxAmtTl`
`zra_sales`.`taxAmtEcm`
`zra_sales`.`taxAmtExeeg`
`zra_sales`.`taxAmtTot`
`zra_sales`.`totTaxblAmt`
`zra_sales`.`totTaxAmt`
`zra_sales`.`cashDcRt`
`zra_sales`.`cashDcAmt`
`zra_sales`.`totAmt`
`zra_sales`.`prchrAcptcYn`
`zra_sales`.`remark`
`zra_sales`.`regrId`
`zra_sales`.`regrNm`
`zra_sales`.`modrId`
`zra_sales`.`modrNm`
`zra_sales`.`saleCtyCd`
`zra_sales`.`lpoNumber`
`zra_sales`.`currencyTyCd`
`zra_sales`.`exchangeRt`
`zra_sales`.`destnCountryCd`
`zra_sales`.`dbtRsnCd`
`zra_sales`.`invcAdjust`
`zra_sales`.`resultCd`
`zra_sales`.`resultMsg`
`zra_sales`.`resultDt`
`zra_sales`.`rcptNo`
`zra_sales`.`intrlData`
`zra_sales`.`rcptSign`
`zra_sales`.`vsdcRcptPbctDate`
`zra_sales`.`sdcId`
`zra_sales`.`mrcNo`
`zra_sales`.`qrCodeUrl`
`zra_sales`.`prnt`
`zra_sales`.`created_at`
`zra_sales`.`updated_at`
`zra_sales_items`.*
`zra_sales_items`.`id`
`zra_sales_items`.`sales_id`
`zra_sales_items`.`itemSeq`
`zra_sales_items`.`itemCd`
`zra_sales_items`.`itemClsCd`
`zra_sales_items`.`itemNm`
`zra_sales_items`.`bcd`
`zra_sales_items`.`pkgUnitCd`
`zra_sales_items`.`pkg`
`zra_sales_items`.`qtyUnitCd`
`zra_sales_items`.`qty`
`zra_sales_items`.`prc`
`zra_sales_items`.`splyAmt`
`zra_sales_items`.`dcRt`
`zra_sales_items`.`dcAmt`
`zra_sales_items`.`isrccCd`
`zra_sales_items`.`isrccNm`
`zra_sales_items`.`isrcRt`
`zra_sales_items`.`isrcAmt`
`zra_sales_items`.`vatCatCd`
`zra_sales_items`.`exciseTxCatCd`
`zra_sales_items`.`vatTaxblAmt`
`zra_sales_items`.`exciseTaxblAmt`
`zra_sales_items`.`vatAmt`
`zra_sales_items`.`exciseTxAmt`
`zra_sales_items`.`totAmt`
`zra_sales_items`.`created_at`
`zra_stock`.*
`zra_stock`.`id`
`zra_stock`.`sarNo`
`zra_stock`.`orgSarNo`
`zra_stock`.`regTyCd`
`zra_stock`.`custTpin`
`zra_stock`.`custNm`
`zra_stock`.`custBhfId`
`zra_stock`.`sarTyCd`
`zra_stock`.`ocrnDt`
`zra_stock`.`totItemCnt`
`zra_stock`.`totTaxblAmt`
`zra_stock`.`totTaxAmt`
`zra_stock`.`totAmt`
`zra_stock`.`remark`
`zra_stock`.`regrId`
`zra_stock`.`regrNm`
`zra_stock`.`modrNm`
`zra_stock`.`modrId`
`zra_stock`.`created_at`
`zra_stock`.`updated_at`
`zra_stock_items`.*
`zra_stock_items`.`id`
`zra_stock_items`.`stock_id`
`zra_stock_items`.`itemSeq`
`zra_stock_items`.`itemCd`
`zra_stock_items`.`itemNm`
`zra_stock_items`.`pkgUnitCd`
`zra_stock_items`.`qtyUnitCd`
`zra_stock_items`.`pkg`
`zra_stock_items`.`qty`
`zra_stock_items`.`prc`
`zra_stock_items`.`totDcAmt`
`zra_stock_items`.`splyAmt`
`zra_stock_items`.`taxblAmt`
`zra_stock_items`.`vatCatCd`
`zra_stock_items`.`taxAmt`
`zra_stock_items`.`totAmt`
`zra_stock_items`.`created_at`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`itemNm`
`zra_stock_master`.`qty`
`zra_stock_master`.`created_at`
`zra_stock_master`.`updated_at`
`zra_stock_transfer`.*
`zra_stock_transfer`.`id`
`zra_stock_transfer`.`itemCd`
`zra_stock_transfer`.`movement_type`
`zra_stock_transfer`.`created_at`
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
cart
categories
configs
consultant_availability
consultations
content_sections
delivery
dpo_config
gallery_images
medicine_strengths
medicines
order_items
orders
prescription_items
prescriptions
refunds
team_members
testimonials
users
zra_classification_codes
zra_codes
zra_config
zra_imports
zra_init
zra_items
zra_purchase_items
zra_purchases
zra_sales
zra_sales_items
zra_stock
zra_stock_items
zra_stock_master
zra_stock_transfer
SQL query on database
medvantm_pharmacy_db
: