perfex.tail1f1784.ts.net / 127.0.0.1 / gms_prod_20260722

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

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

Customize the navigation tree.

Navigation tree

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

Servers display options.

Servers

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

Databases display options.

Databases

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

Tables display options.

Tables

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

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

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

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

Untitled *

v		gms_prod_20260722 tblaccounting_accounts
id : int(11)
name : varchar(255)
code : varchar(16)
parent_account : int(11)
account_type_id : int(11)
active : int(11)

v		gms_prod_20260722 tblaccounting_account_types
id : int(11)
name : varchar(64)
slug : varchar(60)
group : tinyint(4)

v		gms_prod_20260722 tblactivity_log
id : int(11)
description : mediumtext
date : datetime
staffid : varchar(100)

v		gms_prod_20260722 tblannouncements
announcementid : int(11)
name : varchar(191)
message : text
showtousers : int(11)
showtostaff : int(11)
showname : int(11)
dateadded : datetime
userid : varchar(100)

v		gms_prod_20260722 tblarticles
id : int(11)
article_name : varchar(255)
expense_category : int(11)
price : float
tax : int(11)
rel_type : varchar(32)
rel_id : int(11)
channel : int(11)
meeting_date : date
contact_id : int(11)
description : text
file : varchar(256)

v		gms_prod_20260722 tblassigned_clients
id : int(11)
userid : int(11)
company : varchar(191)
vat : varchar(50)
phonenumber : varchar(30)
country : int(11)
city : varchar(100)
zip : varchar(15)
state : varchar(50)
address : varchar(100)
website : varchar(150)
datecreated : datetime
active : int(11)
leadid : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
longitude : varchar(191)
latitude : varchar(191)
default_language : varchar(40)
default_currency : int(11)
show_primary_contact : int(11)
stripe_id : varchar(40)
registration_confirmed : int(11)
addedfrom : int(11)
internal_notes : varchar(500)
id_odoo : int(11)
tax_type : int(11)
tax_pct : int(11)
bank_account : varchar(128)
bank_name : varchar(128)
swift_bic : varchar(32)
balance : decimal(15,6)
exchange_rate : decimal(15,6)
payment_terms : int(11)
payment_days : int(11)
billing_ftao : varchar(128)
billing_phone : varchar(16)
billing_street_addon : longtext
shipping_ftao : varchar(128)
shipping_phone : varchar(16)
shipping_street_addon : longtext
shipping_department : varchar(64)
shipping_designation : varchar(64)
classification : varchar(32)

v		gms_prod_20260722 tblbillpaymentrecords
id : int(11)
billid : int(11)
amount : decimal(15,2)
paymentmode : varchar(40)
paymentmethod : varchar(191)
date : date
daterecorded : datetime
note : mediumtext
transactionid : longtext
status : int(11)
company_address_id : int(11)

v		gms_prod_20260722 tblbills
id : int(11)
sent : tinyint(1)
datesend : datetime
supplierid : int(11)
deleted_supplier_name : varchar(100)
number : int(11)
prefix : varchar(50)
number_format : int(11)
reference : varchar(60)
datecreated : datetime
date : date
duedate : date
currency : int(11)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
total : decimal(15,2)
adjustment : decimal(15,2)
addedfrom : int(11)
hash : varchar(32)
status : int(11)
suppliernote : mediumtext
adminnote : mediumtext
last_overdue_reminder : date
last_due_reminder : date
cancel_overdue_reminders : int(11)
allowed_payment_modes : longtext
token : longtext
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
recurring : int(11)
recurring_type : varchar(10)
custom_recurring : tinyint(1)
cycles : int(11)
total_cycles : int(11)
is_recurring_from : int(11)
last_recurring_date : date
terms : mediumtext
sale_agent : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
include_shipping : tinyint(1)
show_shipping_on_bill : tinyint(1)
show_quantity_as : int(11)
project_id : int(11)
subscription_id : int(11)
purchase_order_id : int(11)
language : varchar(32)
company_address_id : int(11)
bill_description : text
payment_term : int(11)

v		gms_prod_20260722 tblclients
userid : int(11)
company : varchar(191)
vat : varchar(50)
phonenumber : varchar(30)
country : int(11)
city : varchar(100)
zip : varchar(15)
state : varchar(50)
address : varchar(100)
website : varchar(150)
datecreated : datetime
active : int(11)
leadid : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
longitude : varchar(191)
latitude : varchar(191)
default_language : varchar(40)
default_currency : int(11)
show_primary_contact : int(11)
stripe_id : varchar(40)
registration_confirmed : int(11)
addedfrom : int(11)
internal_notes : varchar(500)
id_odoo : int(11)
tax_type : int(11)
tax_pct : int(11)
bank_account : varchar(128)
bank_name : varchar(128)
swift_bic : varchar(32)
balance : decimal(15,6)
exchange_rate : decimal(15,6)
payment_terms : int(11)
payment_days : int(11)
billing_ftao : varchar(128)
billing_phone : varchar(16)
billing_street_addon : longtext
shipping_ftao : varchar(128)
shipping_phone : varchar(16)
shipping_street_addon : longtext
shipping_department : varchar(64)
shipping_designation : varchar(64)
classification : varchar(32)
last_vat : varchar(50)

v		gms_prod_20260722 tblcompany_addresses
id : int(11)
name : varchar(255)
address : varchar(255)
city : varchar(100)
state : varchar(100)
zip : varchar(20)
country : varchar(100)
phone : varchar(50)
vat : varchar(50)
is_default : tinyint(1)

v		gms_prod_20260722 tblconsents
id : int(11)
action : varchar(10)
date : datetime
ip : varchar(40)
contact_id : int(11)
lead_id : int(11)
description : text
opt_in_purpose_description : text
purpose_id : int(11)
staff_name : varchar(100)

v		gms_prod_20260722 tblconsent_purposes
id : int(11)
name : varchar(100)
description : text
date_created : datetime
last_updated : datetime

v		gms_prod_20260722 tblcontacts
id : int(11)
userid : int(11)
is_primary : int(11)
firstname : varchar(191)
lastname : varchar(191)
email : varchar(100)
phonenumber : varchar(100)
phonenumber2 : varchar(100)
title : varchar(100)
datecreated : datetime
password : varchar(255)
new_pass_key : varchar(32)
new_pass_key_requested : datetime
email_verified_at : datetime
email_verification_key : varchar(32)
email_verification_sent_at : datetime
last_ip : varchar(40)
last_login : datetime
last_password_change : datetime
active : tinyint(1)
profile_image : varchar(191)
direction : varchar(3)
invoice_emails : tinyint(1)
estimate_emails : tinyint(1)
credit_note_emails : tinyint(1)
contract_emails : tinyint(1)
task_emails : tinyint(1)
project_emails : tinyint(1)
ticket_emails : tinyint(1)
internal_notes : varchar(500)
greeting : varchar(256)

v		gms_prod_20260722 tblcontact_permissions
id : int(11)
permission_id : int(11)
userid : int(11)

v		gms_prod_20260722 tblcontracts
id : int(11)
content : longtext
description : text
subject : varchar(191)
client : int(11)
datestart : date
dateend : date
contract_type : int(11)
addedfrom : int(11)
dateadded : datetime
isexpirynotified : int(11)
contract_value : decimal(15,2)
trash : tinyint(1)
not_visible_to_client : tinyint(1)
hash : varchar(32)
signed : tinyint(1)
signature : varchar(40)
acceptance_firstname : varchar(50)
acceptance_lastname : varchar(50)
acceptance_email : varchar(100)
acceptance_date : datetime
acceptance_ip : varchar(40)

v		gms_prod_20260722 tblcontracts_types
id : int(11)
name : mediumtext

v		gms_prod_20260722 tblcontract_comments
id : int(11)
content : mediumtext
contract_id : int(11)
staffid : int(11)
dateadded : datetime

v		gms_prod_20260722 tblcontract_renewals
id : int(11)
contractid : int(11)
old_start_date : date
new_start_date : date
old_end_date : date
new_end_date : date
old_value : decimal(15,2)
new_value : decimal(15,2)
date_renewed : datetime
renewed_by : varchar(100)
renewed_by_staff_id : int(11)
is_on_old_expiry_notified : int(11)

v		gms_prod_20260722 tblcountries
country_id : int(11)
iso2 : char(2)
short_name : varchar(80)
long_name : varchar(80)
iso3 : char(3)
numcode : varchar(6)
un_member : varchar(12)
calling_code : varchar(8)
cctld : varchar(5)

v		gms_prod_20260722 tblcreditnotes
id : int(11)
clientid : int(11)
deleted_customer_name : varchar(100)
number : int(11)
prefix : varchar(50)
number_format : int(11)
datecreated : datetime
date : date
adminnote : text
terms : text
clientnote : text
currency : int(11)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
total : decimal(15,2)
adjustment : decimal(15,2)
addedfrom : int(11)
status : int(11)
project_id : int(11)
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
include_shipping : tinyint(1)
show_shipping_on_credit_note : tinyint(1)
show_quantity_as : int(11)
reference_no : varchar(100)
public_client_id : int(11)
language : varchar(32)
company_address_id : int(11)

v		gms_prod_20260722 tblcreditnote_refunds
id : int(11)
credit_note_id : int(11)
staff_id : int(11)
refunded_on : date
payment_mode : varchar(40)
note : text
amount : decimal(15,2)
created_at : datetime

v		gms_prod_20260722 tblcredits
id : int(11)
invoice_id : int(11)
credit_id : int(11)
staff_id : int(11)
date : date
date_applied : datetime
amount : decimal(15,2)

v		gms_prod_20260722 tblcurrencies
id : int(11)
symbol : varchar(10)
name : varchar(100)
decimal_separator : varchar(5)
thousand_separator : varchar(5)
placement : varchar(10)
isdefault : tinyint(1)

v		gms_prod_20260722 tblcustomers_groupings
id : int(11)
name : varchar(191)

v		gms_prod_20260722 tblcustomers_groups
id : int(11)
name : varchar(191)

v		gms_prod_20260722 tblcustomer_activity_log
id : int(11)
customerid : int(11)
description : mediumtext
additional_data : text
date : datetime
staffid : int(11)
full_name : varchar(100)
custom_activity : tinyint(1)

v		gms_prod_20260722 tblcustomer_admins
staff_id : int(11)
customer_id : int(11)
date_assigned : text

v		gms_prod_20260722 tblcustomer_groupings
id : int(11)
groupid : int(11)
customer_id : int(11)

v		gms_prod_20260722 tblcustomer_groups
id : int(11)
groupid : int(11)
customer_id : int(11)

v		gms_prod_20260722 tblcustomfields
id : int(11)
fieldto : varchar(15)
name : varchar(150)
slug : varchar(150)
required : tinyint(1)
type : varchar(20)
options : mediumtext
display_inline : tinyint(1)
field_order : int(11)
active : int(11)
show_on_pdf : int(11)
show_on_ticket_form : tinyint(1)
only_admin : tinyint(1)
show_on_table : tinyint(1)
show_on_client_portal : int(11)
disalow_client_to_edit : int(11)
bs_column : int(11)

v		gms_prod_20260722 tblcustomfieldsvalues
id : int(11)
relid : int(11)
fieldid : int(11)
fieldto : varchar(15)
value : text

v		gms_prod_20260722 tbldepartments
departmentid : int(11)
name : varchar(100)
imap_username : varchar(50)
email : varchar(100)
email_from_header : tinyint(1)
host : varchar(150)
password : mediumtext
encryption : varchar(3)
delete_after_import : int(11)
calendar_id : mediumtext
hidefromclient : tinyint(1)

v		gms_prod_20260722 tbldiary
id : int(11)
hash : varchar(65)
name : varchar(191)
surname : varchar(191)
title : varchar(100)
company : varchar(191)
description : text
country : int(11)
zip : varchar(15)
city : varchar(100)
state : varchar(50)
address : varchar(100)
assigned : int(11)
dateadded : datetime
from_form_id : int(11)
status : int(11)
source : int(11)
lastcontact : date
dateassigned : date
last_status_change : datetime
addedfrom : int(11)
email : varchar(100)
website : varchar(150)
leadorder : int(11)
date_converted : datetime
lost : tinyint(1)
junk : int(11)
last_lead_status : int(11)
is_imported_from_email_integration : tinyint(1)
email_integration_uid : varchar(30)
default_language : varchar(40)
rel_type : varchar(32)
rel_id : int(11)
contact_id : int(11)
channel_id : int(11)

v		gms_prod_20260722 tbldiary_members
id : int(11)
diary_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tbldismissed_announcements
dismissedannouncementid : int(11)
announcementid : int(11)
staff : int(11)
userid : int(11)

v		gms_prod_20260722 tblemaillists
listid : int(11)
name : mediumtext
creator : varchar(100)
datecreated : datetime

v		gms_prod_20260722 tblemailtemplates
emailtemplateid : int(11)
type : mediumtext
slug : varchar(100)
language : varchar(40)
name : mediumtext
subject : mediumtext
message : text
fromname : mediumtext
fromemail : varchar(100)
plaintext : int(11)
active : tinyint(4)
order : int(11)

v		gms_prod_20260722 tblesconnect_connectors
id : int(11)
name : varchar(50)
supports_import : tinyint(1)
supports_export : tinyint(1)

v		gms_prod_20260722 tblesconnect_connector_entities
id : int(11)
connector_id : int(11)
entity_type : varchar(50)

v		gms_prod_20260722 tblesconnect_sync_queue
id : int(11)
type : enum('import','export')
connector_id : int(11)
entity_id : int(11)
entity_type : varchar(50)
synched : tinyint(1)
attempts : tinyint(1)
log : text
created_at : datetime
updated_at : datetime
synched_at : datetime

v		gms_prod_20260722 tblesconnect_sync_settings
id : int(11)
type : enum('import','export')
connector_id : int(11)
entity_types : text
active : tinyint(1)
schedule_type : enum('hourly','daily','weekly','custom')
schedule_value : varchar(50)
mapping : text
last_run_at : datetime
created_at : datetime
updated_at : datetime

v		gms_prod_20260722 tblestimates
id : int(11)
sent : tinyint(1)
datesend : datetime
clientid : int(11)
contactid : int(11)
work_type : int(11)
deleted_customer_name : varchar(100)
project_id : int(11)
number : int(11)
prefix : varchar(50)
number_format : int(11)
hash : varchar(32)
datecreated : datetime
date : date
expirydate : date
date3 : date
date4 : date
date5 : date
currency : int(11)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
total : decimal(15,2)
adjustment : decimal(15,2)
addedfrom : int(11)
status : int(11)
clientnote : text
adminnote : text
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
invoiceid : longtext
invoiced_date : datetime
terms : text
reference_no : varchar(100)
sale_agent : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
include_shipping : tinyint(1)
show_shipping_on_estimate : tinyint(1)
show_quantity_as : int(11)
pipeline_order : int(11)
is_expiry_notified : int(11)
acceptance_firstname : varchar(50)
acceptance_lastname : varchar(50)
acceptance_email : varchar(100)
acceptance_date : datetime
acceptance_ip : varchar(40)
signature : varchar(40)
contract_operation_txt : longtext
summary_txt : longtext
summary_title : varchar(255)
work_type_item : int(11)
origen : varchar(255)
origen_type : int(11)
administrator : varchar(255)
phone : varchar(32)
phone2 : varchar(32)
email : varchar(64)
irdam1 : decimal(10,2)
irdam2 : decimal(10,2)
client_details_txt : longtext
contactid2 : int(11)
contactid3 : int(11)
contactid4 : int(11)
contactid5 : int(11)
contactid6 : int(11)
contactid7 : int(11)
contactid8 : int(11)
contactid9 : int(11)
contactid10 : int(11)
parentid : int(11)
e_company : int(11)
prevstudies_id : int(11)
version : varchar(256)
estimate_type : enum('modular','normal')
estimate_pdf_prefs : varchar(1024)
housing_surfaces : float
housing_coef_geo : float
housing_coef_typology : float
housing_coef_quality : float
housing_coef_use : float
garage_surfaces : float
garage_coef_geo : float
garage_coef_typology : float
garage_coef_quality : float
garage_coef_use : float
sp_surfaces : float
sp_coef_geo : float
sp_coef_typology : float
sp_coef_quality : float
sp_coef_use : float
porches_surfaces : float
porches_coef_geo : float
porches_coef_typology : float
porches_coef_quality : float
porches_coef_use : float
next_discount : int(11)
topographic_study : float
geotechnical_study : float
indicative : float
work_license_fee : float
icio : float
aesa : float
bail_replacement_urban_elements : float
works_plaque : float
public_manhole_connection : float
street_cuts : float
occupation_of_public_roads : float
first_occupation_license : float
ford_application_fee : float
mail_code : varchar(128)
project_subtotal : decimal(15,2)
specialty : int(11)
lead_date : date
language : varchar(32)
priority : int(11)
prov_price : int(11)
proposal_note : text
project_type : varchar(64)
study_area : varchar(128)
power : varchar(32)
country_id : int(11)
province : varchar(64)
term_id : int(11)
awarded_status_date : date
total_invoiced_pct : decimal(15,2)
company_address_id : int(11)

v		gms_prod_20260722 tblestimate_meetings
id : int(11)
estimate_id : int(11)
diary_id : int(11)

v		gms_prod_20260722 tblestimate_members
id : int(11)
estimate_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblevents
eventid : int(11)
title : mediumtext
description : text
userid : int(11)
start : datetime
end : datetime
public : int(11)
color : varchar(10)
isstartnotified : tinyint(1)
reminder_before : int(11)
reminder_before_type : varchar(10)

v		gms_prod_20260722 tblexpenses
id : int(11)
category : int(11)
currency : int(11)
amount : decimal(15,2)
tax : int(11)
tax2 : int(11)
reference_no : varchar(100)
note : text
expense_name : varchar(191)
supplierid : int(11)
clientid : int(11)
project_id : int(11)
task_id : int(11)
billable : int(11)
invoiceid : int(11)
paymentmode : varchar(50)
date : date
recurring_type : varchar(10)
repeat_every : int(11)
recurring : int(11)
cycles : int(11)
total_cycles : int(11)
custom_recurring : int(11)
last_recurring_date : date
create_invoice_billable : tinyint(1)
send_invoice_to_customer : tinyint(1)
recurring_from : int(11)
dateadded : datetime
addedfrom : int(11)
id_article : int(11)
id_prevstudies : int(11)
add_base : decimal(15,2)
total_tax : decimal(15,2)
total_irpf : decimal(15,2)
is_irpf : int(11)
is_provider_expense : int(11)
is_confirmed : int(11)
is_paid : tinyint(1)

v		gms_prod_20260722 tblexpenses_categories
id : int(11)
name : varchar(191)
description : text
account : varchar(50)
account_type : smallint(6)
accounting_account_id : int(11)

v		gms_prod_20260722 tblfiles
id : int(11)
rel_id : int(11)
rel_type : varchar(20)
file_name : varchar(191)
filetype : varchar(40)
visible_to_customer : int(11)
attachment_key : varchar(32)
external : varchar(40)
external_link : text
thumbnail_link : text
staffid : int(11)
contact_id : int(11)
task_comment_id : int(11)
dateadded : datetime

v		gms_prod_20260722 tblform_questions
questionid : int(11)
rel_id : int(11)
rel_type : varchar(20)
question : mediumtext
required : tinyint(1)
question_order : int(11)

v		gms_prod_20260722 tblform_question_box
boxid : int(11)
boxtype : varchar(10)
questionid : int(11)

v		gms_prod_20260722 tblform_question_box_description
questionboxdescriptionid : int(11)
description : mediumtext
boxid : mediumtext
questionid : int(11)

v		gms_prod_20260722 tblform_results
resultid : int(11)
boxid : int(11)
boxdescriptionid : int(11)
rel_id : int(11)
rel_type : varchar(20)
questionid : int(11)
answer : text
resultsetid : int(11)

v		gms_prod_20260722 tblgdpr_requests
id : int(11)
clientid : int(11)
contact_id : int(11)
lead_id : int(11)
request_type : varchar(191)
status : varchar(40)
request_date : datetime
request_from : varchar(150)
description : text

v		gms_prod_20260722 tblgoals
id : int(11)
subject : varchar(191)
description : text
start_date : date
end_date : date
goal_type : int(11)
contract_type : int(11)
achievement : int(11)
notify_when_fail : tinyint(1)
notify_when_achieve : tinyint(1)
notified : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblinventory_items
id : int(11)
sku : varchar(32)
description : varchar(256)
group_id : int(11)
brand_model : varchar(128)
serial_number : varchar(128)
location : varchar(64)
status : varchar(32)
supplier : varchar(128)
manufacturer : varchar(128)
observations : varchar(256)
entry_date : date
calibration_verification : char(1)
calibration_type : char(1)
calibration_date : date
next_calibration_date : date
certificate : varchar(256)
quantity : int(11)
updated_at : date
updated_by : int(11)

v		gms_prod_20260722 tblinventory_items_groups
id : int(11)
name : varchar(100)
parent_id : int(11)

v		gms_prod_20260722 tblinvoicepaymentrecords
id : int(11)
invoiceid : int(11)
amount : decimal(15,2)
paymentmode : varchar(40)
paymentmethod : varchar(191)
date : date
daterecorded : datetime
note : text
transactionid : mediumtext
expenseid : int(11)
invoice_date : date
status : int(11)
company_address_id : int(11)

v		gms_prod_20260722 tblinvoices
id : int(11)
sent : tinyint(1)
datesend : datetime
clientid : int(11)
deleted_customer_name : varchar(100)
number : int(11)
prefix : varchar(50)
number_format : int(11)
datecreated : datetime
date : date
duedate : date
currency : int(11)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
total : decimal(15,2)
adjustment : decimal(15,2)
adjustment_percent : decimal(15,2)
adjustment_type : varchar(30)
addedfrom : int(11)
hash : varchar(32)
status : int(11)
clientnote : text
adminnote : text
last_overdue_reminder : date
cancel_overdue_reminders : int(11)
allowed_payment_modes : mediumtext
token : mediumtext
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
recurring : int(11)
recurring_type : varchar(10)
custom_recurring : tinyint(1)
cycles : int(11)
total_cycles : int(11)
is_recurring_from : int(11)
last_recurring_date : date
terms : text
sale_agent : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
include_shipping : tinyint(1)
show_shipping_on_invoice : tinyint(1)
show_quantity_as : int(11)
project_id : int(11)
subscription_id : int(11)
invoice_type : varchar(30)
rel_id : int(11)
certificate_pct : varchar(8)
certificate_text : varchar(255)
rel_type : enum('customer','lead')
contact_id : int(11)
sub_cost_from_project : decimal(15,2)
invoice_description : text
expense_id_from_project : int(11)
is_verified : int(11)
estimateid : int(11)
estimate_pct : int(11)
public_client_id : int(11)
payment_term : int(11)
invoice_general_tax_pct : varchar(64)
language : varchar(32)
company_address_id : int(11)

v		gms_prod_20260722 tblitemable
id : int(11)
rel_id : int(11)
rel_type : varchar(15)
is_adjust : tinyint(1)
description : mediumtext
long_description : longtext
item_order : int(11)
cod : varchar(32)
rate_formula : varchar(255)
estimate_text : longtext
group_id : int(11)
json_fields : longtext
qty : decimal(15,2)
rate : decimal(15,2)
pct_rate : int(11)
unit : varchar(40)
performance_day : decimal(15,2)
performance_hour : decimal(15,2)
operator_cost_hour : decimal(15,2)
profit_meters : decimal(15,2)
material_cost_meters : decimal(15,2)
item_id : int(11)
item_type : varchar(16)
item_invoiced_pct : int(11)
category : int(11)
accounting_account_id : int(11)

v		gms_prod_20260722 tblitems
id : int(11)
description : mediumtext
long_description : text
rate : decimal(15,2)
tax : int(11)
tax2 : int(11)
unit : varchar(40)
group_id : int(11)
cod : varchar(16)
sku : varchar(32)

v		gms_prod_20260722 tblitems_groups
id : int(11)
name : varchar(50)

v		gms_prod_20260722 tblitem_tax
id : int(11)
itemid : int(11)
rel_id : int(11)
rel_type : varchar(20)
taxrate : decimal(15,2)
taxname : varchar(100)

v		gms_prod_20260722 tblknowedge_base_article_feedback
articleanswerid : int(11)
articleid : int(11)
answer : int(11)
ip : varchar(40)
date : datetime

v		gms_prod_20260722 tblknowledge_base
articleid : int(11)
articlegroup : int(11)
subject : mediumtext
description : text
slug : mediumtext
active : tinyint(4)
datecreated : datetime
article_order : int(11)
staff_article : int(11)

v		gms_prod_20260722 tblknowledge_base_groups
groupid : int(11)
name : varchar(191)
group_slug : text
description : mediumtext
active : tinyint(4)
color : varchar(10)
group_order : int(11)

v		gms_prod_20260722 tblleads
id : int(11)
hash : varchar(65)
name : varchar(191)
surname : varchar(191)
title : varchar(100)
company : varchar(191)
description : text
country : int(11)
zip : varchar(15)
city : varchar(100)
state : varchar(50)
address : varchar(100)
assigned : int(11)
dateadded : datetime
from_form_id : int(11)
status : int(11)
source : int(11)
lastcontact : datetime
dateassigned : date
last_status_change : datetime
addedfrom : int(11)
email : varchar(100)
website : varchar(150)
leadorder : int(11)
phonenumber : varchar(50)
date_converted : datetime
lost : tinyint(1)
junk : int(11)
last_lead_status : int(11)
is_imported_from_email_integration : tinyint(1)
email_integration_uid : varchar(30)
is_public : tinyint(1)
default_language : varchar(40)
client_id : int(11)
api_id : varchar(32)
email_template : int(11)
email_send_period : int(11)
date_last_notification : datetime

v		gms_prod_20260722 tblleads_email_integration
id : int(11)
active : int(11)
email : varchar(100)
imap_server : varchar(100)
password : mediumtext
check_every : int(11)
responsible : int(11)
lead_source : int(11)
lead_status : int(11)
encryption : varchar(3)
folder : varchar(100)
last_run : varchar(50)
notify_lead_imported : tinyint(1)
notify_lead_contact_more_times : tinyint(1)
notify_type : varchar(20)
notify_ids : mediumtext
mark_public : int(11)
only_loop_on_unseen_emails : tinyint(1)
delete_after_import : int(11)
create_task_if_customer : int(11)

v		gms_prod_20260722 tblleads_sources
id : int(11)
name : varchar(150)

v		gms_prod_20260722 tblleads_status
id : int(11)
name : varchar(50)
statusorder : int(11)
color : varchar(10)
isdefault : int(11)
api_status : varchar(32)

v		gms_prod_20260722 tbllead_activity_log
id : int(11)
leadid : int(11)
description : mediumtext
additional_data : text
date : datetime
staffid : int(11)
full_name : varchar(100)
custom_activity : tinyint(1)

v		gms_prod_20260722 tbllead_integration_emails
id : int(11)
subject : mediumtext
body : mediumtext
dateadded : datetime
leadid : int(11)
emailid : int(11)

v		gms_prod_20260722 tbllistemails
emailid : int(11)
listid : int(11)
email : varchar(100)
dateadded : datetime

v		gms_prod_20260722 tblmaillistscustomfields
customfieldid : int(11)
listid : int(11)
fieldname : varchar(150)
fieldslug : varchar(100)

v		gms_prod_20260722 tblmaillistscustomfieldvalues
customfieldvalueid : int(11)
listid : int(11)
customfieldid : int(11)
emailid : int(11)
value : varchar(100)

v		gms_prod_20260722 tblmail_queue
id : int(11)
engine : varchar(40)
email : varchar(191)
cc : text
bcc : text
message : mediumtext
alt_message : mediumtext
status : enum('pending','sending','sent','failed')
date : datetime
headers : text
attachments : mediumtext

v		gms_prod_20260722 tblmention_posts
id : int(11)
creator : int(11)
datecreated : datetime
content : text
pinned : int(11)
datepinned : datetime

v		gms_prod_20260722 tblmention_post_comments
id : int(11)
content : text
userid : int(11)
postid : int(11)
dateadded : datetime
is_contact : varchar(45)

v		gms_prod_20260722 tblmigrations
version : bigint(20)

v		gms_prod_20260722 tblmilestones
id : int(11)
name : varchar(191)
description : text
description_visible_to_customer : tinyint(1)
due_date : date
project_id : int(11)
color : varchar(10)
milestone_order : int(11)
datecreated : date
prevstudies_id : int(11)

v		gms_prod_20260722 tblmodules
id : int(11)
module_name : varchar(55)
installed_version : varchar(11)
active : tinyint(1)

v		gms_prod_20260722 tblnewsfeed_comment_likes
id : int(11)
postid : int(11)
commentid : int(11)
userid : int(11)
dateliked : datetime

v		gms_prod_20260722 tblnewsfeed_posts
postid : int(11)
creator : int(11)
datecreated : datetime
visibility : varchar(100)
content : text
pinned : int(11)
datepinned : datetime

v		gms_prod_20260722 tblnewsfeed_post_comments
id : int(11)
content : text
userid : int(11)
postid : int(11)
dateadded : datetime

v		gms_prod_20260722 tblnewsfeed_post_likes
id : int(11)
postid : int(11)
userid : int(11)
dateliked : datetime

v		gms_prod_20260722 tblngn_audit
id : int(11)
inbox_id : int(11)
action : enum('received','field_edited','approved','rejected','replayed','master_record_created','error','deleted','restored','rolled_back')
by_staff_id : int(11)
at : datetime
before_json : longtext
after_json : longtext
note : text

v		gms_prod_20260722 tblngn_classification
id : int(11)
tipo_movimiento : varchar(64)
categoria : varchar(64)
subcategoria : varchar(64)
active : tinyint(1)
sort_order : int(11)

v		gms_prod_20260722 tblngn_fx_rates
id : int(11)
base : char(3)
quote : char(3)
rate : decimal(18,8)
as_of_date : date
source : varchar(40)
fetched_at : datetime

v		gms_prod_20260722 tblngn_inbox
id : int(11)
payload_type : enum('supplier_invoice','card_expense')
idempotency_key : varchar(64)
n8n_workflow_id : varchar(64)
n8n_execution_id : varchar(64)
source_email : varchar(190)
raw_payload : longtext
extracted_fields : longtext
sharepoint_drive_id : varchar(255)
sharepoint_item_id : varchar(255)
sharepoint_web_url : text
attachment_filename : varchar(255)
attachment_size : bigint(20)
attachment_mime : varchar(100)
pdf_file_id : int(11)
status : enum('pending','edited','approved','rejected','error','deleted')
ai_confidence : decimal(4,3)
error_text : text
received_at : datetime
approved_by_staff_id : int(11)
approved_at : datetime
native_record_id : int(11)
native_record_type : enum('bill','expense')
edit_history : longtext
created_at : datetime
updated_at : datetime

v		gms_prod_20260722 tblngn_payment_schedule
id : int(11)
native_record_type : enum('bill','expense')
native_record_id : int(11)
inbox_id : int(11)
seq : int(11)
due_date : date
amount : decimal(15,2)
currency : varchar(10)
amount_eur : decimal(15,2)
status : enum('pending','paid')
paid_payment_record_id : int(11)
paid_at : datetime
created_at : datetime
updated_at : datetime

v		gms_prod_20260722 tblnotes
id : int(11)
rel_id : int(11)
rel_type : varchar(20)
description : text
date_contacted : datetime
addedfrom : int(11)
dateadded : datetime

v		gms_prod_20260722 tblnotifications
id : int(11)
isread : int(11)
isread_inline : tinyint(1)
date : datetime
description : text
fromuserid : int(11)
fromclientid : int(11)
from_fullname : varchar(100)
touserid : int(11)
fromcompany : int(11)
link : mediumtext
additional_data : text

v		gms_prod_20260722 tbloptions
id : int(11)
name : varchar(191)
value : longtext
autoload : tinyint(1)

v		gms_prod_20260722 tblpayment_attachments
id : int(11)
paymentid : int(11)
replyid : int(11)
file_name : varchar(191)
filetype : varchar(50)
dateadded : datetime

v		gms_prod_20260722 tblpayment_modes
id : int(11)
name : varchar(100)
description : text
account_code : varchar(16)
account_type : smallint(6)
accounting_account_id : int(11)
show_on_pdf : int(11)
invoices_only : int(11)
expenses_only : int(11)
selected_by_default : int(11)
active : tinyint(1)

v		gms_prod_20260722 tblpayment_modes_old
id : int(11)
name : varchar(100)
description : text
show_on_pdf : int(11)
invoices_only : int(11)
expenses_only : int(11)
selected_by_default : int(11)
active : tinyint(1)

v		gms_prod_20260722 tblpayment_terms
id : int(11)
name_english : varchar(255)
name_spanish : varchar(255)
days : int(11)
active : tinyint(1)

v		gms_prod_20260722 tblpermissions
permissionid : int(11)
name : mediumtext
shortname : mediumtext
active : tinyint(1)

v		gms_prod_20260722 tblpinned_prevstudies
id : int(11)
project_id : int(11)
staff_id : int(11)
pin_order : int(11)

v		gms_prod_20260722 tblpinned_projects
id : int(11)
project_id : int(11)
staff_id : int(11)
pin_order : int(11)

v		gms_prod_20260722 tblprevstudies
id : int(11)
name : varchar(191)
description : text
status : int(11)
clientid : int(11)
billing_type : int(11)
start_date : date
deadline : date
project_created : date
date_finished : datetime
progress : int(11)
progress_from_tasks : int(11)
project_sub_cost : decimal(15,2)
project_cost : decimal(15,2)
project_rate_per_hour : decimal(15,2)
estimated_hours : decimal(15,2)
addedfrom : int(11)
work_type : int(11)
est_number : varchar(16)
rel_id : int(11)
cod_prevstudy : varchar(32)
cod_project : varchar(32)
visa_date : date
record_licence : varchar(255)
date_licence : date
record_coac : varchar(255)
collab_name : varchar(255)
collab_cif : varchar(16)
collab_dir : varchar(255)
collab_phone : varchar(16)
collab_email : varchar(255)
contractor_name : varchar(255)
contractor_cif : varchar(16)
contractor_dir : varchar(255)
contractor_phone : varchar(16)
contractor_email : varchar(255)
eng_name : varchar(255)
eng_cif : varchar(16)
eng_dir : varchar(255)
eng_phone : varchar(16)
eng_email : varchar(255)
calc_name : varchar(255)
calc_cif : varchar(16)
calc_dir : varchar(255)
calc_phone : varchar(16)
calc_email : varchar(255)
dir : varchar(255)
cadastr_ref : varchar(128)
town_hall_pass : varchar(255)
project_tipology : varchar(255)
prom1_name : varchar(255)
prom1_cif : varchar(16)
prom1_dir : varchar(255)
prom1_phone : varchar(16)
prom1_email : varchar(255)
prom2_name : varchar(255)
prom2_cif : varchar(16)
prom2_dir : varchar(255)
prom2_phone : varchar(16)
prom2_email : varchar(255)
rep_name : varchar(255)
rep_cif : varchar(16)
rep_dir : varchar(255)
rep_phone : varchar(16)
rep_email : varchar(255)
plot_area : varchar(16)
built_living_place_ref : varchar(16)
built_parking_ref : varchar(16)
built_totals_ref : varchar(16)
built_living_place_amp : varchar(16)
built_parking_amp : varchar(16)
built_totals_amp : varchar(16)
built_living_place_const : varchar(16)
built_parking_const : varchar(16)
built_others_ref : varchar(16)
built_others_amp : varchar(16)
built_others_const : varchar(16)
built_others_total : varchar(16)
built_totals_const : varchar(16)
built_living_place_total : varchar(16)
built_parking_total : varchar(16)
built_totals_total : varchar(16)
pool_surface : varchar(16)
util_surface : varchar(16)
num_households : varchar(16)
num_parking : varchar(16)
pem : varchar(16)
checkboxes : varchar(500)
capture_date : date
briefing_date : date
forecast_date : date
presentation_date : date
mail_notification_status : int(11)
enable_capture_reminders : int(11)
capture_reminder_date4 : date
enable_presentation_reminders : int(11)
presentation_reminder_date_4 : date
capture_reminders_email : varchar(128)
presentation_reminders_email : varchar(128)

v		gms_prod_20260722 tblprevstudiesdiscussioncomments
id : int(11)
discussion_id : int(11)
discussion_type : varchar(10)
parent : int(11)
created : datetime
modified : datetime
content : text
staff_id : int(11)
contact_id : int(11)
fullname : varchar(191)
file_name : varchar(191)
file_mime_type : varchar(70)
viewed_by_users : longtext
liked_by_users : longtext

v		gms_prod_20260722 tblprevstudiesdiscussions
id : int(11)
project_id : int(11)
subject : varchar(191)
description : text
show_to_customer : tinyint(1)
datecreated : datetime
last_activity : datetime
staff_id : int(11)
contact_id : int(11)

v		gms_prod_20260722 tblprevstudies_activity
id : int(11)
project_id : int(11)
staff_id : int(11)
contact_id : int(11)
fullname : varchar(100)
visible_to_customer : int(11)
description_key : varchar(191)
additional_data : text
dateadded : datetime

v		gms_prod_20260722 tblprevstudies_files
id : int(11)
file_name : varchar(191)
subject : varchar(191)
description : text
filetype : varchar(50)
dateadded : datetime
last_activity : datetime
project_id : int(11)
visible_to_customer : tinyint(1)
staffid : int(11)
contact_id : int(11)
external : varchar(40)
external_link : text
thumbnail_link : text
folder : varchar(32)

v		gms_prod_20260722 tblprevstudies_members
id : int(11)
project_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblprevstudies_notes
id : int(11)
project_id : int(11)
content : text
staff_id : int(11)

v		gms_prod_20260722 tblprevstudies_settings
id : int(11)
project_id : int(11)
name : varchar(100)
value : text

v		gms_prod_20260722 tblprevstudies_status
id : int(11)
name : varchar(64)
color : varchar(16)
element_order : int(11)
filter_default : int(11)

v		gms_prod_20260722 tblprojectdiscussioncomments
id : int(11)
discussion_id : int(11)
discussion_type : varchar(10)
parent : int(11)
created : datetime
modified : datetime
content : text
staff_id : int(11)
contact_id : int(11)
fullname : varchar(191)
file_name : varchar(191)
file_mime_type : varchar(70)
viewed_by_users : longtext
liked_by_users : longtext

v		gms_prod_20260722 tblprojectdiscussions
id : int(11)
project_id : int(11)
subject : varchar(191)
description : text
show_to_customer : tinyint(1)
datecreated : datetime
last_activity : datetime
staff_id : int(11)
contact_id : int(11)

v		gms_prod_20260722 tblprojects
id : int(11)
name : varchar(191)
description : text
status : int(11)
clientid : int(11)
billing_type : int(11)
start_date : date
deadline : date
project_created : date
date_finished : datetime
progress : int(11)
progress_from_tasks : int(11)
project_sub_cost : decimal(15,2)
project_cost : decimal(15,2)
project_rate_per_hour : decimal(15,2)
estimated_hours : decimal(15,2)
addedfrom : int(11)
work_type : int(11)
est_number : varchar(16)
rel_id : int(11)
project_cod : varchar(32)
visa_date : date
record_licence : varchar(255)
date_licence : date
record_coac : varchar(255)
collab_name : varchar(255)
collab_cif : varchar(16)
collab_dir : varchar(255)
collab_phone : varchar(16)
collab_email : varchar(255)
contractor_name : varchar(255)
contractor_cif : varchar(16)
contractor_dir : varchar(255)
contractor_phone : varchar(16)
contractor_email : varchar(255)
eng_name : varchar(255)
eng_cif : varchar(16)
eng_dir : varchar(255)
eng_phone : varchar(16)
eng_email : varchar(255)
calc_name : varchar(255)
calc_cif : varchar(16)
calc_dir : varchar(255)
calc_phone : varchar(16)
calc_email : varchar(255)
dir : varchar(255)
cadastr_ref : varchar(128)
town_hall_pass : varchar(255)
project_tipology : varchar(255)
prom1_name : varchar(255)
prom1_cif : varchar(16)
prom1_dir : varchar(255)
prom1_phone : varchar(16)
prom1_email : varchar(255)
prom2_name : varchar(255)
prom2_cif : varchar(16)
prom2_dir : varchar(255)
prom2_phone : varchar(16)
prom2_email : varchar(255)
rep_name : varchar(255)
rep_cif : varchar(16)
rep_dir : varchar(255)
rep_phone : varchar(16)
rep_email : varchar(255)
plot_area : varchar(16)
built_living_place_ref : varchar(16)
built_parking_ref : varchar(16)
built_totals_ref : varchar(16)
built_living_place_amp : varchar(16)
built_parking_amp : varchar(16)
built_totals_amp : varchar(16)
built_living_place_const : varchar(16)
built_parking_const : varchar(16)
built_others_ref : varchar(16)
built_others_amp : varchar(16)
built_others_const : varchar(16)
built_others_total : varchar(16)
built_totals_const : varchar(16)
built_living_place_total : varchar(16)
built_parking_total : varchar(16)
built_totals_total : varchar(16)
pool_surface : varchar(16)
util_surface : varchar(16)
num_households : varchar(16)
num_parking : varchar(16)
pem : varchar(16)
horizontal_expenses : decimal(15,2)
profit_objective : decimal(15,2)
project_checkbox : varchar(1024)
project_inputbox : varchar(1024)
other_comment : varchar(256)
other_comment2 : varchar(256)
other_comment3 : varchar(256)
licence_date : date
profile_licence : varchar(256)
num_locals : int(11)
other1_name : varchar(128)
other2_name : varchar(128)
other1_cif : varchar(128)
other2_cif : varchar(128)
other1_dir : varchar(128)
other2_dir : varchar(128)
other1_phone : varchar(128)
other2_phone : varchar(128)
other1_email : varchar(128)
other2_email : varchar(128)
prevstudy_id : int(11)
horizontal_expenses_real : decimal(15,2)
profit_real : decimal(15,2)
project_sub_cost_real : decimal(15,2)
project_cost_real : decimal(15,2)

v		gms_prod_20260722 tblproject_activity
id : int(11)
project_id : int(11)
staff_id : int(11)
contact_id : int(11)
fullname : varchar(100)
visible_to_customer : int(11)
description_key : varchar(191)
additional_data : text
dateadded : datetime

v		gms_prod_20260722 tblproject_clients
id : int(11)
project_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblproject_files
id : int(11)
file_name : varchar(191)
subject : varchar(191)
description : text
filetype : varchar(50)
dateadded : datetime
last_activity : datetime
project_id : int(11)
visible_to_customer : tinyint(1)
staffid : int(11)
contact_id : int(11)
external : varchar(40)
external_link : text
thumbnail_link : text
folder : enum('projects','projects/admin')

v		gms_prod_20260722 tblproject_members
id : int(11)
project_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblproject_notes
id : int(11)
project_id : int(11)
content : text
staff_id : int(11)

v		gms_prod_20260722 tblproject_responsible_members
id : int(11)
project_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblproject_settings
id : int(11)
project_id : int(11)
name : varchar(100)
value : text

v		gms_prod_20260722 tblproject_status
id : int(11)
name : varchar(64)
color : varchar(16)
element_order : int(11)
filter_default : int(11)

v		gms_prod_20260722 tblproject_support_members
id : int(11)
project_id : int(11)
staff_id : int(11)

v		gms_prod_20260722 tblproject_types
id : int(11)
name : varchar(100)
datecreated : datetime

v		gms_prod_20260722 tblproposals
id : int(11)
subject : varchar(191)
content : longtext
addedfrom : int(11)
datecreated : datetime
total : decimal(15,2)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
adjustment : decimal(15,2)
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
show_quantity_as : int(11)
currency : int(11)
open_till : date
date : date
rel_id : int(11)
rel_type : varchar(40)
assigned : int(11)
hash : varchar(32)
proposal_to : varchar(191)
country : int(11)
zip : varchar(50)
state : varchar(100)
city : varchar(100)
address : varchar(200)
email : varchar(150)
phone : varchar(50)
allow_comments : tinyint(1)
status : int(11)
estimate_id : int(11)
invoice_id : int(11)
date_converted : datetime
pipeline_order : int(11)
is_expiry_notified : int(11)
acceptance_firstname : varchar(50)
acceptance_lastname : varchar(50)
acceptance_email : varchar(100)
acceptance_date : datetime
acceptance_ip : varchar(40)
signature : varchar(40)
specialty : int(11)
lead_date : date
language : varchar(8)
priority : int(11)
prov_price : int(11)
proposal_note : text

v		gms_prod_20260722 tblproposal_comments
id : int(11)
content : mediumtext
proposalid : int(11)
staffid : int(11)
dateadded : datetime

v		gms_prod_20260722 tblproposal_meetings
id : int(11)
proposal_id : int(11)
diary_id : int(11)

v		gms_prod_20260722 tblpurchase_items
id : int(11)
description_spanish : mediumtext
description_english : mediumtext
long_description : text
rate : decimal(15,2)
tax : int(11)
tax2 : int(11)
unit : varchar(40)
group_id : int(11)
accounting_account_id : int(11)
sku : varchar(32)
type : enum('goods','service')
equipment : varchar(32)
model : varchar(64)
serial_n : varchar(64)
currect_location : varchar(64)
item_condition : varchar(32)
provider : varchar(128)
maker : varchar(128)
admission_date : date
calibration_verification : varchar(16)
internal_external : varchar(16)
calibration_date : date
next_calibration_date : date
certificate : varchar(256)
last_edit_date : date
edited_by : int(11)
currency : int(11)

v		gms_prod_20260722 tblpurchase_items_groups
id : int(11)
name : varchar(50)

v		gms_prod_20260722 tblpurchase_orders
id : int(11)
sent : tinyint(1)
datesend : datetime
supplierid : int(11)
deleted_supplier_name : varchar(100)
project_id : int(11)
number : int(11)
prefix : varchar(50)
number_format : int(11)
hash : varchar(32)
datecreated : datetime
date : date
expirydate : date
currency : int(11)
subtotal : decimal(15,2)
total_tax : decimal(15,2)
total : decimal(15,2)
adjustment : decimal(15,2)
addedfrom : int(11)
status : int(11)
suppliernote : mediumtext
adminnote : mediumtext
discount_percent : decimal(15,2)
discount_total : decimal(15,2)
discount_type : varchar(30)
billid : int(11)
billed_date : datetime
terms : mediumtext
reference_no : varchar(100)
sale_agent : int(11)
billing_street : varchar(200)
billing_city : varchar(100)
billing_state : varchar(100)
billing_zip : varchar(100)
billing_country : int(11)
shipping_street : varchar(200)
shipping_city : varchar(100)
shipping_state : varchar(100)
shipping_zip : varchar(100)
shipping_country : int(11)
include_shipping : tinyint(1)
show_shipping_on_purchase_order : tinyint(1)
show_quantity_as : int(11)
pipeline_order : int(11)
is_expiry_notified : int(11)
acceptance_firstname : varchar(50)
acceptance_lastname : varchar(50)
acceptance_email : varchar(100)
acceptance_date : datetime
acceptance_ip : varchar(40)
signature : varchar(40)
short_link : varchar(100)
term_id : int(11)
language : varchar(32)
company_address_id : int(11)
reviewed_by : int(11)
approved_by : int(11)

v		gms_prod_20260722 tblrelated_items
id : int(11)
rel_id : int(11)
rel_type : varchar(30)
item_id : int(11)

v		gms_prod_20260722 tblreminders
id : int(11)
description : text
date : datetime
isnotified : int(11)
rel_id : int(11)
staff : int(11)
rel_type : varchar(40)
notify_by_email : int(11)
creator : int(11)

v		gms_prod_20260722 tblroles
roleid : int(11)
name : varchar(150)

v		gms_prod_20260722 tblrole_permissions
rolepermissionid : int(11)
roleid : int(11)
can_view : tinyint(1)
can_view_own : tinyint(1)
can_edit : tinyint(1)
can_create : tinyint(1)
can_delete : tinyint(1)
can_approve : tinyint(1)
permissionid : int(11)

v		gms_prod_20260722 tblsales_activity
id : int(11)
rel_type : varchar(20)
rel_id : int(11)
description : text
additional_data : text
staffid : varchar(11)
full_name : varchar(100)
date : datetime

v		gms_prod_20260722 tblsale_items
id : int(11)
description_spanish : mediumtext
description_english : mediumtext
long_description : text
rate : decimal(15,2)
tax : int(11)
tax2 : int(11)
unit : varchar(40)
group_id : int(11)
accounting_account_id : int(11)
sku : varchar(32)
type : enum('goods','service')
sale_code : varchar(50)
rate_currency_1 : decimal(15,2)

v		gms_prod_20260722 tblsale_items_groups
id : int(11)
name : varchar(50)
group_sku : varchar(256)

v		gms_prod_20260722 tblservices
serviceid : int(11)
name : varchar(50)

v		gms_prod_20260722 tblsessions
id : varchar(128)
ip_address : varchar(45)
timestamp : int(10) unsigned
data : blob

Create relationship
FOREIGN KEY
on delete
on update