address_city:br_isloaded BYTE,branch_id LONG,city_code TEXT/255,city_id LONG PR,city_name TEXT/255,code_br TEXT/32,country_code TEXT/255 R:code_br,city_id,city_name,br_isloaded,branch_id
address_country:br_isloaded BYTE,branch_id LONG,code TEXT/3,code_br TEXT/32,country TEXT/100,country_e TEXT/50 R,country_id LONG PR,domain TEXT/50:domain,code_br,country_e,country_id,br_isloaded,branch_id,code
alert:alert_src BYTE,alert_src_id LONG,br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,created_date DATETIME,id LONG PR,read_date DATETIME,read_user_id LONG R:id,alert_src_id,alert_src,br_isloaded,branch_id,code_br,created_date,read_date,read_user_id
app_data_replace:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,code_br_des TEXT/32 R,code_br_src TEXT/32 R,data_type BYTE R,id LONG PR,id_des LONG R,id_src LONG R:id,br_isloaded,branch_id,code_br_des,code_br,code_br_src,data_type,id_des,id_src
app_function:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,function_id LONG PR,function_name TEXT/50 R,function_name_display TEXT/50,group_name TEXT/50:code_br,function_name,br_isloaded,branch_id,group_name,function_id
app_goods_import_print:branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,import_invoice_id LONG R,print_count LONG R:id,branch_id,code_br,goods_id,import_invoice_id
app_homepage:br_isloaded BYTE,branch_id LONG R,code TEXT/32,code_br TEXT/32,data MEMO,id LONG PR,is_active BYTE,name TEXT/100:code_br,id,br_isloaded,branch_id,code,is_active,name
app_log:branch_id LONG,obj_id LONG,id LONG PR,log_date DATETIME R,log_src TEXT/50,log_src_id LONG,log_src_nobr TEXT/32,log_sync BYTE,log_type BYTE,user_id LONG,val_string TEXT/255:id,obj_id,log_date,log_src_id,log_src,log_src_nobr,log_sync,log_type,user_id
app_param:branch_id LONG,code_br TEXT/32,id LONG PR,param_name TEXT/50 R,val_bool BYTE,val_currency CURRENCY,val_datetime DATETIME,val_double DOUBLE,val_long LONG,val_string MEMO:code_br,param_name,id,branch_id
app_param_printer:branch_id LONG,code_br TEXT/32,id LONG PR,printer_name TEXT/32,paper_size TEXT/2,printer_address TEXT/32,printer_type BYTE,is_valid YESNO/2:id,printer_name,branch_id,code_br,is_valid
bank:bank_id LONG PR,bank_name TEXT/100,bank_shortname TEXT/20,bin LONG,branch_id LONG,code_br TEXT/32:bank_name,bin,bank_id,branch_id,code_br
bank_account:account_id LONG PR,account_init DOUBLE R,account_number TEXT/50 R,account_owner TEXT/255,bank_code TEXT/10,bank_name TEXT/255 R,bank_shortname TEXT/20,bin LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,continued BYTE:code_br,account_id,account_number,bank_name,br_isloaded,branch_id,continued
branch:branch_id LONG PR,customer_code TEXT/32 RU,customer_code5 TEXT/32,sync_password TEXT/32,pcserial TEXT/32,branch_name TEXT/255,branch_address TEXT/255,branch_phone TEXT/50,branch_email TEXT/255,branch_website TEXT/255,branch_taxcode TEXT/32,branch_init_cash DOUBLE,is_continued BYTE,group_id LONG:branch_id,customer_code,customer_code5,sync_password,is_continued,group_id
ccard:br_isloaded BYTE,branch_id LONG,card_code TEXT/50 R,card_id LONG PR,category_id LONG,code_br TEXT/32,date_from DATETIME,date_to DATETIME:card_code,code_br,card_id,br_isloaded,branch_id,category_id
ccard_category:br_isloaded BYTE,branch_id LONG,category_code TEXT/50,category_discount_number DOUBLE,category_discount_percent DOUBLE,category_discount_percent_service DOUBLE,category_discount_time LONG,category_id LONG PR,category_level BYTE,category_name TEXT/255 R,code_br TEXT/32:code_br,category_code,category_name,category_id,br_isloaded,branch_id,category_level
ccard_contact:br_isloaded BYTE,branch_id LONG,card_code TEXT/50 R,code_br TEXT/32,contact_id LONG R,date_reg DATETIME R,id LONG PR,user_id LONG R:card_code,code_br,id,br_isloaded,branch_id,contact_id,date_reg,user_id
ccard_exim_export_invoice:br_isloaded BYTE,branch_id LONG,card_code TEXT/50,code_br TEXT/32,id LONG PR,invoice_discount_val DOUBLE R,invoice_id LONG R:code_br,id,br_isloaded,branch_id,card_code,invoice_id
clinic_goods_guide:age_from SINGLE,age_to SINGLE,goods_id LONG R,guide_content MEMO,guide_id LONG PR:guide_id,goods_id
clinic_medexam:comment TEXT/255,contact_id LONG R,contact_weight DOUBLE,diagnosis TEXT/255,doctor_id LONG R,first_goods_id LONG R,invoice_id LONG R,medexam_date DATETIME R,medexam_id LONG PR:medexam_id,contact_id,doctor_id,first_goods_id,invoice_id,medexam_date
clinic_medexam_prescription:create_doctor_id LONG R,create_time DATETIME,goods_id LONG R,howtouse TEXT/255,medexam_id LONG,prescription_id LONG PR,quantity DOUBLE,use_evening TEXT/10,use_isafter_eating YESNO/2,use_isbefore_eating YESNO/2,use_morning TEXT/10,use_noon TEXT/10:prescription_id,create_doctor_id,goods_id,medexam_id
clinic_medexam_test:comment TEXT/255,create_doctor_id LONG R,create_time DATETIME,exim_export_invoice_details_id LONG,goods_id LONG R,medexam_id LONG,quantity DOUBLE,result_description MEMO,result_doctor_id LONG,result_image_name TEXT/255,result_time DATETIME,test_doctor_id LONG,test_id LONG PR,test_status BYTE,test_time DATETIME:exim_export_invoice_details_id,test_id,create_doctor_id,goods_id,medexam_id,result_doctor_id,test_doctor_id,test_status
contacts:bank_account TEXT/255,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_address TEXT/255,contact_cmnd TEXT/20,contact_code TEXT/50,contact_id LONG PR,contact_name TEXT/255 R,contact_person TEXT/100,contact_sex BYTE,continued BYTE R,date_birth DATETIME,debit_mustpayday DOUBLE,debit_mustpaymax DOUBLE,debit_mustrecday DOUBLE,debit_mustrecmax DOUBLE,debit_mustrecoverduemax LONG,email TEXT/255,fax TEXT/20,note_goodsdelivery MEMO,phaithu_dauky DOUBLE R,phaitra_dauky DOUBLE R,phone TEXT/50,tax_code TEXT/50,type_customer BYTE,type_supplier BYTE,discount_foods DOUBLE,discount_drink DOUBLE,discount_service DOUBLE,discount_goods DOUBLE:code_br,contact_id,bank_account,br_isloaded,branch_id,contact_address,contact_cmnd,contact_name,contact_sex,continued,phone,tax_code,type_customer,type_supplier
contacts_group:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,description MEMO,group_id LONG PR,group_name TEXT/100 R,group_code TEXT/20,hotline TEXT/255:code_br,group_name,group_id,br_isloaded,branch_id,group_code
contacts_group_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,contact_id LONG R,group_id LONG R,id LONG PR:code_br,id,br_isloaded,branch_id,contact_id,group_id
crd_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,crd_date DATETIME R,id LONG PR,money_add DOUBLE,money_sub DOUBLE,point LONG R,type_id LONG R,user_id LONG R,user_id_operator LONG R:code_br,id,br_isloaded,branch_id,crd_date,type_id,user_id,user_id_operator
crd_type:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,money_add DOUBLE,money_sub DOUBLE,point LONG R,type_id LONG PR,type_name TEXT/100 R:type_id,code_br,type_name,br_isloaded,branch_id
diary:br_isloaded BYTE,branch_id LONG,category_id LONG,code_br TEXT/32,content MEMO,diary_date DATETIME R,diary_id LONG PR,user_id LONG:code_br,br_isloaded,branch_id,category_id,diary_date,diary_id
diary_category:br_isloaded BYTE,branch_id LONG,category_id LONG PR,category_name TEXT/255 R,code_br TEXT/32:code_br,br_isloaded,branch_id,category_id,category_name
exim_delivery:rc_contact_id LONG,so_contact_id LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,delivery_cost DOUBLE,delivery_no TEXT/32,delivery_status BYTE R,delivery_user_id LONG,finish_time DATETIME,id LONG PR,invoice_id_export LONG R,invoice_id_import LONG,is_export_invoice BYTE,sp_contact_id LONG,start_time DATETIME,user_id LONG R,comment TEXT:code_br,id,so_contact_id,br_isloaded,branch_id,delivery_no,delivery_status,delivery_user_id,invoice_id_import,invoice_id_export,is_export_invoice,sp_contact_id,start_time,user_id,rc_contact_id
exim_expected_export_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG R,contact_supply_id LONG,delivery_date DATETIME,invoice_id LONG PR,invoice_no TEXT/50,is_finished BYTE R,order_date DATETIME,order_no TEXT/15,reason_other TEXT/2,receipt_debt_invoice_id LONG,total_cost DOUBLE,money_rate DOUBLE,user_id LONG R:invoice_id,code_br,br_isloaded,branch_id,contact_id,is_finished,order_no,receipt_debt_invoice_id,user_id,contact_supply_id
exim_expected_export_invoice_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,color_id INTEGER,comment MEMO,fas_size TEXT/10,goods_id LONG R,id LONG PR,invoice_id LONG R,quantity DOUBLE,unit_id LONG,unit_price DOUBLE:code_br,id,br_isloaded,branch_id,color_id,fas_size,goods_id,invoice_id,unit_id
exim_expected_import_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG,contact_supply_id LONG,delivery_date DATETIME,invoice_id LONG PR,invoice_no TEXT/50,is_finished BYTE,money_rate SINGLE,order_date DATETIME,order_no TEXT/50,pay_debt_invoice_id LONG,total_cost DOUBLE,user_id LONG:invoice_id,br_isloaded,branch_id,code_br,contact_id,contact_supply_id,is_finished,order_no,pay_debt_invoice_id,user_id
exim_expected_import_invoice_details:id LONG PR,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,goods_id LONG R,invoice_id LONG R,quantity DOUBLE,unit_id LONG,color_id LONG,unit_price DOUBLE:code_br,id,br_isloaded,branch_id,goods_id,invoice_id,unit_id,color_id
exim_export_import_back_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,exim_export_invoice_details_id LONG R,exim_import_invoice_details_id LONG R,id LONG PR,is_export BYTE R:code_br,id,br_isloaded,branch_id,exim_export_invoice_details_id,exim_import_invoice_details_id,is_export
exim_export_import_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,export_invoice_details_id LONG R,export_unit_price DOUBLE R,goods_id LONG R,id LONG PR,import_invoice_details_id LONG R,import_unit_price DOUBLE R,manual_add BYTE R,quantity DOUBLE R,store_id LONG R,unit_id LONG:code_br,id,br_isloaded,branch_id,export_invoice_details_id,goods_id,import_invoice_details_id,manual_add,store_id,unit_id
exim_export_import_goods_changed:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,date_changed DATETIME R,goods_id LONG R,id LONG PR,store_id LONG,unit_id LONG:code_br,id,br_isloaded,branch_id,date_changed,goods_id,store_id,unit_id
exim_export_invoice:invoice_id LONG PR,branch_id LONG,code_br TEXT/32,invoice_date DATETIME R,payment_method BYTE,bank_account_id LONG,br_isloaded BYTE,ccard_code TEXT/50,ccard_point_used DOUBLE,clinic_medexam_id LONG,comment MEMO,contact_id LONG R,contact_id_extra LONG,contact_note MEMO,expected_discount DOUBLE,expected_invoice_id LONG,expected_prepaid DOUBLE,extra_charge DOUBLE,invoice_discount SINGLE,invoice_money_contact_give DOUBLE,invoice_money_discount DOUBLE R,invoice_no TEXT/50,invoice_vatmark TEXT/50,invoice_voucher TEXT/50,money_debit DOUBLE R,money_debit_nextpayment DATETIME,money_rate DOUBLE,pay_others DOUBLE,reason TEXT/2 R,reason_other TEXT/5,store_id LONG,total_cost DOUBLE R,trade_user_id LONG,user_id LONG R,vat DOUBLE R,res_obj_id LONG,res_mixcost DOUBLE,res_customer_count LONG,res_customer_info MEMO,discount_foods DOUBLE,discount_drink DOUBLE,discount_goods DOUBLE,discount_service DOUBLE,invoice_date_end DATETIME,money_deduction DOUBLE,resinvoicesource LONG:code_br,bank_account_id,br_isloaded,branch_id,ccard_code,clinic_medexam_id,contact_id,contact_id_extra,expected_invoice_id,invoice_id,invoice_no,invoice_date,reason,reason_other,trade_user_id,user_id,res_obj_id,invoice_date_end,payment_method,resinvoicesource
exim_export_invoice_details:br_isloaded BYTE,branch_id LONG,ccard_point_accumulated DOUBLE,code_br TEXT/32,color_id INTEGER,comment TEXT/255,date_active DATETIME,date_alarm DATETIME,date_expired DATETIME,discount SINGLE R,expired_date DATETIME,fas_size TEXT/10,goods_id LONG R,id LONG PR,id_mixmain LONG,id_promotion LONG,invoice_id LONG R,lot_number TEXT/15,packing_weight SINGLE,producer_code TEXT/32,qrimportid LONG,qrimportserial LONG,quantity DOUBLE R,quantity_count DOUBLE,quantity_depth DOUBLE,quantity_height DOUBLE,quantity_width DOUBLE,serial MEMO,unit_id LONG,unit_price DOUBLE R,warranty DOUBLE,hourinday_add DATETIME,hourinday_from DATETIME,hourinday_to DATETIME,hourinday_do DATETIME,spa_employee_id LONG,spa_combo_id LONG,commission DOUBLE,id_parent LONG,res_notekitchendrink TEXT/255,res_isremotecall BYTE,res_quantity_printed LONG,res_isobjgoods BYTE,res_orderuserid LONG:code_br,id,br_isloaded,branch_id,color_id,date_active,date_alarm,date_expired,expired_date,fas_size,goods_id,id_mixmain,id_promotion,invoice_id,lot_number,qrimportid,qrimportserial,unit_id,spa_employee_id,spa_combo_id,id_parent,res_isremotecall,res_orderuserid
exim_goods_alarm:alarm_by TEXT/255,br_isloaded BYTE,branch_id TEXT/50,code_br TEXT/32,comment MEMO,date_alarm DATETIME R,details_id LONG R,id LONG PR,is_export BYTE R,user_id LONG R:code_br,id,br_isloaded,branch_id,date_alarm,details_id,is_export,user_id
exim_goods_serial:br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,details_id LONG R,id LONG PR,is_export BYTE R,serial TEXT/20 R:code_br,id,br_isloaded,branch_id,details_id,is_export,serial
exim_import_invoice:payment_method BYTE,bank_account_id LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG,contact_id_extra LONG,contact_note MEMO,expected_invoice_id LONG,invoice_date DATETIME R,invoice_discount SINGLE,invoice_id LONG PR,invoice_money_discount DOUBLE R,invoice_no TEXT/50,invoice_vatmark TEXT/50,invoice_voucher TEXT/50,money_debit DOUBLE R,money_debit_nextpayment DATETIME,money_rate DOUBLE,pay_others DOUBLE,reason TEXT/2 R,reason_other TEXT/5,store_id LONG,total_cost DOUBLE R,trade_user_id LONG,user_id LONG R,vat DOUBLE R:code_br,bank_account_id,br_isloaded,branch_id,contact_id,contact_id_extra,expected_invoice_id,invoice_id,invoice_no,invoice_date,reason,reason_other,trade_user_id,user_id,payment_method
exim_import_invoice_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,color_id INTEGER,comment TEXT/255,date_active DATETIME,date_alarm DATETIME,date_expired DATETIME,discount SINGLE R,expired_date DATETIME,fas_size TEXT/10,goods_id LONG R,id LONG PR,id_mixmain LONG,id_promotion LONG,invoice_id LONG R,lot_number TEXT/15,packing_weight SINGLE,producer_code TEXT/32,quantity DOUBLE R,quantity_count DOUBLE,quantity_depth DOUBLE,quantity_height DOUBLE,quantity_width DOUBLE,serial MEMO,unit_id LONG,unit_price DOUBLE R,warranty DOUBLE:code_br,id,br_isloaded,branch_id,color_id,date_active,date_alarm,date_expired,expired_date,fas_size,goods_id,id_mixmain,id_promotion,invoice_id,lot_number,unit_id
exim_swap_details_relation:br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,exim_export_invoice_details_id LONG R,exim_import_invoice_details_id LONG R,id LONG PR:code_br,exim_export_invoice_details_id,exim_import_invoice_details_id,id,br_isloaded,branch_id
exim_swap_relation:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,export_invoice_id LONG,import_invoice_id LONG,import_store_id LONG,relation_id LONG PR:code_br,relation_id,br_isloaded,branch_id,export_invoice_id,import_invoice_id,import_store_id
goods:br_isloaded BYTE,branch_id LONG,category_id LONG,ccard_point DOUBLE,code_br TEXT/32,comment MEMO,continued BYTE R,description_full MEMO,description_short MEMO,dm_depth DOUBLE,dm_height DOUBLE,dm_width DOUBLE,export_price DOUBLE R,export_price_hourlycharge BYTE,export_price_wholesale DOUBLE,goods_code TEXT/50,goods_discount_default SINGLE,goods_discount_money SINGLE,goods_discount_wholesale_money SINGLE,goods_discount_wholesale_percent SINGLE,goods_id LONG PR,goods_name TEXT/255 R,goods_sname TEXT/255,image_name TEXT/20,image_set MEMO,import_price DOUBLE R,latest_price CURRENCY,net_weight SINGLE,packing_size TEXT/20,packing_weight SINGLE,price_extra SINGLE,profit_default DOUBLE,profit_default_percent SINGLE,profit_default_wholesale DOUBLE,profit_default_wholesale_percent SINGLE,res_iscombo YESNO/2,res_ismix BYTE,res_nguyenlieu BYTE,res_objcategory BYTE,res_servicedefault BYTE,res_servicemincost DOUBLE,res_servicenodiscount BYTE,res_serviceorder LONG,res_thanhpham BYTE R,spa_minutelimit LONG,spa_commission DOUBLE,template_id LONG,time_price_update DATETIME,unit TEXT/50,warranty DOUBLE:code_br,goods_code,goods_id,br_isloaded,branch_id,category_id,continued,export_price_hourlycharge,goods_name,res_iscombo,res_ismix,res_nguyenlieu,res_objcategory,res_servicedefault,res_servicenodiscount,res_serviceorder,res_thanhpham,time_price_update
goods_alarmdate:alarm_date DOUBLE R,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,unit_id LONG,unit_name TEXT/50,unit_ratio DOUBLE:id,br_isloaded,branch_id,code_br,goods_id,unit_id,unit_name
goods_attribute:alarm_date DOUBLE,br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,goods_id LONG R,id LONG PR,limited_date DOUBLE,unit_id LONG:code_br,id,br_isloaded,branch_id,goods_id,unit_id
goods_category:br_isloaded BYTE,branch_id LONG R,category_code TEXT/50,category_discount_default SINGLE,category_id LONG PR,category_name TEXT/255 R,category_service BYTE,code_br TEXT/32,comment MEMO,continued BYTE R,fas_size TEXT/255,res_doan BYTE R,res_douong BYTE R,parent_id LONG,res_goods_category_type BYTE:code_br,category_id,br_isloaded,branch_id,category_code,category_name,category_service,continued,res_doan,res_douong,parent_id,res_goods_category_type
goods_color:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,color_id LONG PR,color_name TEXT/100,color_rgb TEXT/6,short_name TEXT/8:code_br,color_id,br_isloaded,branch_id,color_name,short_name
goods_comment:id LONG PR,comment TEXT/255:id
goods_commission:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,number_deployment DOUBLE,number_sell DOUBLE,percent_deployment DOUBLE,percent_sell DOUBLE,unit_id LONG,user_id LONG:code_br,id,br_isloaded,branch_id,goods_id,unit_id,user_id
goods_limiteddate:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,limited_date DATETIME R,unit_id LONG,unit_name TEXT/50,unit_ratio DOUBLE:id,br_isloaded,branch_id,code_br,goods_id,unit_id,unit_name
goods_labeled:id LONG PR,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R:id,branch_id,br_isloaded,code_br,goods_id
goods_mix_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/50,goods_child_id LONG,goods_main_id LONG,goods_mix_template_details_id LONG,id LONG PR,quantity DOUBLE R,unit_id LONG,unit_price_autoget BYTE:code_br,br_isloaded,branch_id,goods_child_id,goods_main_id,id,unit_id
goods_mix_template:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,template_id LONG PR,template_name TEXT/50 R:template_id,code_br,br_isloaded,branch_id
goods_mix_template_details:br_isloaded BYTE,branch_id LONG,category_id LONG R,code_br TEXT/32,id LONG PR,label TEXT/100,template_id LONG R:code_br,id,br_isloaded,branch_id,category_id,template_id
goods_price_bycustomer:br_isloaded BYTE,branch_id LONG,category_id LONG,code_br TEXT/32,contact_id LONG,discount_bycustomer DOUBLE,expired_date DATETIME,export_price_bycustomer DOUBLE R,goods_id LONG,pricebycustomer_id LONG PR,unit_id LONG:code_br,pricebycustomer_id,br_isloaded,branch_id,category_id,contact_id,expired_date,goods_id,unit_id
goods_pricename:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,pricename_id LONG PR,pricename_label TEXT/50:pricename_id,br_isloaded,branch_id,code_br,pricename_label
goods_pricetemplate:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,is_mix BYTE,pricetemplate_id LONG PR,pricetemplate_name TEXT/255:code_br,pricetemplate_id,pricetemplate_name,br_isloaded,branch_id
goods_pricetemplate_categoryorder:br_isloaded YESNO/2,branch_id LONG,category_id LONG R,code_br TEXT/32,id LONG PR,pricetemplate_id LONG R,template_order LONG R:id,branch_id,category_id,code_br,pricetemplate_id,template_order
goods_pricetemplate_notes:br_isloaded YESNO/2,content MEMO,date_from DATETIME,date_to DATETIME,id LONG PR,pricetemplate_id LONG R:id,date_from,date_to,pricetemplate_id
goods_pricetemplatedetails:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG,id LONG PR,pricetemplate_id LONG,unit_id LONG:code_br,id,br_isloaded,branch_id,goods_id,pricetemplate_id,unit_id
goods_pricetemplatemix:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,pricetemplate_id LONG,pricetemplatemix_id LONG PR,pricetemplatemix_name TEXT/255,template_id LONG:code_br,pricetemplatemix_id,br_isloaded,branch_id,pricetemplate_id,pricetemplatemix_name,template_id
goods_pricetemplatemix_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,goods_mix_template_details_id LONG,id LONG PR,pricetemplatemix_id LONG R,quantity DOUBLE R,unit_id LONG:code_br,id,br_isloaded,branch_id,goods_id,goods_mix_template_details_id,pricetemplatemix_id,unit_id
goods_store_param:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,color_id INTEGER,expired_date DATETIME,fas_size TEXT/10,goods_id LONG,import_price_init DOUBLE,instock_min DOUBLE,lot_number TEXT/15,param_id LONG PR,quantity_init DOUBLE R,quantity_stock SINGLE,store_id LONG,unit_id LONG:code_br,param_id,br_isloaded,branch_id,color_id,expired_date,fas_size,goods_id,lot_number,store_id,unit_id
goods_unit:ccard_point DOUBLE,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,continued YESNO/2,export_price DOUBLE,export_price_wholesale DOUBLE,goods_code_unit TEXT/50,goods_discount_default SINGLE,goods_discount_money SINGLE,goods_discount_wholesale_money SINGLE,goods_discount_wholesale_percent SINGLE,goods_id LONG R,import_price DOUBLE,is_autopricefrombase BYTE,net_weight SINGLE,packing_size TEXT/20,packing_weight SINGLE,price_extra MEMO,profit_default DOUBLE,profit_default_percent SINGLE,profit_default_wholesale DOUBLE,profit_default_wholesale_percent SINGLE,time_price_update DATETIME,unit_id LONG PR,unit_name TEXT/50 R,unit_ratio DOUBLE R:code_br,unit_id,br_isloaded,branch_id,continued,goods_code_unit,goods_id,is_autopricefrombase
goods_stocktaking:stocktaking_id LONG PR,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,store_id LONG,date_create DATETIME,date_finish DATETIME,stocktaking_no TEXT/50,user_id LONG,total_cost DOUBLE,export_invoice_id LONG:stocktaking_id,code_br,br_isloaded,branch_id,store_id,user_id,date_create,date_finish,stocktaking_no,export_invoice_id
goods_stocktaking_details:id LONG PR,stocktaking_id LONG R,goods_id LONG R,unit_id LONG R,quantity_stock DOUBLE,quantity_stock_real DOUBLE,import_price DOUBLE:id,stocktaking_id,goods_id,unit_id
job_schedule:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,date_create DATETIME R,date_finish DATETIME,date_must_finish DATETIME R,description MEMO,job_id LONG PR,user_id LONG,user_id_finish LONG,user_id_operator LONG:code_br,job_id,br_isloaded,branch_id,date_create,date_must_finish,user_id_finish,user_id,user_id_operator
pay_debt:bank_accountid LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG R,exim_import_invoice_id LONG,exim_import_invoice_no TEXT/20,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/50,invoice_val DOUBLE R,store_id LONG,trade_user_id LONG,user_id LONG R:code_br,invoice_id,bank_accountid,br_isloaded,branch_id,contact_id,exim_import_invoice_id,exim_import_invoice_no,trade_user_id,user_id
pay_debt_import_invoice:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,id LONG PR,import_invoice_id LONG R,is_manual YESNO/2,pay_invoice_id LONG R,pay_val SINGLE:id,br_isloaded,branch_id,code_br,import_invoice_id,is_manual,pay_invoice_id
pay_others:bank_accountid LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,contact_id LONG,employee_user_id LONG,export_invoice_id LONG,export_invoice_voucher TEXT/50,import_invoice_id LONG,import_invoice_voucher TEXT/50,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/50,invoice_val DOUBLE R,is_external BYTE,store_id LONG,type_id LONG,user_id LONG:code_br,bank_accountid,br_isloaded,branch_id,contact_id,type_id,employee_user_id,export_invoice_id,export_invoice_voucher,import_invoice_id,import_invoice_voucher,invoice_date,user_id,invoice_id
pay_type:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,type_id LONG PR,type_name TEXT/100 R:code_br,type_id,br_isloaded,branch_id,type_name
price_quotation:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG R,expired_date DATETIME,from_date DATETIME,quotation_id LONG PR,quotation_name TEXT/255,quotation_ps MEMO,user_id LONG R:code_br,quotation_id,br_isloaded,branch_id,contact_id,user_id
price_quotation_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,goods_id LONG,id LONG PR,quantity DOUBLE,quotation_id LONG,unit_id LONG,unit_price DOUBLE,warranty DOUBLE:code_br,id,br_isloaded,branch_id,goods_id,quotation_id,unit_id
promotion_goods:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,max_quantity DOUBLE,program_id LONG R,unit_id LONG:code_br,id,br_isloaded,branch_id,goods_id,program_id,unit_id
promotion_goods_quantity:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,discount SINGLE,id LONG PR,promotion_goods_id LONG R,quantity_base SINGLE R:id,br_isloaded,branch_id,code_br,promotion_goods_id,quantity_base
promotion_goods_quantity_attach:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,is_onetime YESNO/2,is_retail YESNO/2,is_wholesale YESNO/2,promotion_goods_quantity_id LONG R,quantity_attach SINGLE R,unit_id LONG R:id,br_isloaded,branch_id,code_br,goods_id,is_onetime,is_retail,is_wholesale,promotion_goods_quantity_id,unit_id
promotion_program:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,date_from DATETIME R,date_to DATETIME R,max_money_promotion DOUBLE R,program_id LONG PR,program_name TEXT/255 R:code_br,program_id,br_isloaded,branch_id,program_name
receipt_debt:bank_accountid LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG R,exim_export_invoice_id LONG,exim_export_invoice_no TEXT/20,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/50,invoice_val DOUBLE R,store_id LONG,trade_user_id LONG,user_id LONG R:code_br,invoice_id,bank_accountid,br_isloaded,branch_id,contact_id,exim_export_invoice_id,exim_export_invoice_no,trade_user_id,user_id
receipt_debt_export_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,export_invoice_id LONG R,id LONG PR,is_manual YESNO/2,receipt_invoice_id LONG R,receipt_val DOUBLE R:code_br,id,br_isloaded,branch_id,export_invoice_id,is_manual,receipt_invoice_id
receipt_others:bank_accountid LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG,employee_user_id LONG,export_invoice_id LONG,export_invoice_voucher TEXT/50,import_invoice_id LONG,import_invoice_voucher TEXT/50,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/50,invoice_val DOUBLE R,is_external BYTE,store_id LONG,swap_invoice_id LONG,type_id LONG,user_id LONG:code_br,invoice_id,bank_accountid,br_isloaded,branch_id,contact_id,employee_user_id,export_invoice_id,import_invoice_id,swap_invoice_id,type_id,user_id
receipt_type:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,type_id LONG PR,type_name TEXT/100 R:code_br,type_id,type_name,br_isloaded,branch_id
repair_extern_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,contact_id LONG R,employee_id LONG R,id LONG PR,invoice_date DATETIME R,is_send BYTE R,pay_others_invoice_id LONG,quantity DOUBLE R,repair_cost DOUBLE,repair_invoice_details_id LONG R:code_br,id,br_isloaded,branch_id,contact_id,employee_id,invoice_date,is_send,pay_others_invoice_id,repair_invoice_details_id
repair_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,contact_id LONG,cost_total DOUBLE,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/50,reply_date DATETIME,return_date DATETIME,trade_user_id LONG,user_id LONG:code_br,invoice_id,br_isloaded,branch_id,contact_id,invoice_no,reply_date,return_date,trade_user_id,user_id
repair_invoice_details:accessories TEXT/255,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,cost_subtotal DOUBLE,exim_export_invoice_id LONG,goods_name TEXT/255 R,id LONG PR,invoice_id LONG,model TEXT/255,quantity DOUBLE R,quantity_failed DOUBLE,quantity_fixed DOUBLE,received_status TEXT/255,repair_user_id LONG,serial TEXT/255:code_br,id,br_isloaded,branch_id,exim_export_invoice_id,invoice_id,repair_user_id
repair_return_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,contact_id LONG R,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/255,receipt_debt_invoice_id LONG,trade_user_id LONG R,user_id LONG R:code_br,invoice_id,receipt_debt_invoice_id,br_isloaded,branch_id,contact_id,invoice_date,trade_user_id,user_id
repair_return_invoice_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,cost_paid DOUBLE R,id LONG PR,invoice_id LONG,quantity_failed DOUBLE,quantity_fixed DOUBLE,quantity_return DOUBLE R,repair_invoice_details_id LONG,warranty DOUBLE:code_br,id,br_isloaded,branch_id,invoice_id,repair_invoice_details_id
repair_status:adjust_date DATETIME R,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,is_fixed BYTE R,quantity DOUBLE R,repair_invoice_details_id LONG R,trade_user_id LONG R:code_br,id,adjust_date,br_isloaded,branch_id,is_fixed,repair_invoice_details_id,trade_user_id
res_goods_label:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR:code_br,goods_id,br_isloaded,branch_id,id
res_invoice_log:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,date_updated DATETIME R,goods_id LONG R,id LONG PR,invoice_id LONG R,obj_id LONG R,quantity DOUBLE R,quantity_change DOUBLE R,reason_id LONG,unit_price DOUBLE R,unit_price_change DOUBLE R,user_id LONG:code_br,id,br_isloaded,branch_id,date_updated,goods_id,invoice_id,obj_id,reason_id,user_id
res_invoice_service:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,employee_id LONG,exim_export_invoice_details_id LONG,goods_id LONG R,id LONG PR,invoice_id LONG R,spa_combo_id LONG,spa_minutelimit LONG,time_end DATETIME,time_start DATETIME R:code_br,id,br_isloaded,branch_id,employee_id,goods_id,invoice_id,spa_combo_id
res_invoice_source:source_id LONG PR,branch_id LONG,code_br TEXT/32,source_name TEXT/100,extra_charge DOUBLE,continued BYTE,contact_id LONG,payment_debit YESNO/2:source_id,branch_id,code_br,source_name,continued,contact_id
res_locklist:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,date_from DATETIME R,date_to DATETIME R,lock_id LONG PR,money_handover DOUBLE,money_init DOUBLE,total_cost DOUBLE,user_id LONG R:code_br,lock_id,br_isloaded,branch_id,date_from,date_to,user_id
res_locklist_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,contact_id LONG,id LONG PR,invoice_id LONG R,lock_id LONG R,total_cost DOUBLE,trade_user_id LONG,user_id LONG R:code_br,id,br_isloaded,branch_id,contact_id,invoice_id,lock_id,trade_user_id,user_id
res_mix:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,invoice_id_from LONG R,invoice_id_to LONG R:code_br,id,br_isloaded,branch_id,invoice_id_to
res_obj:group_id LONG,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,continued YESNO/2,date_callpayment DATETIME,date_callpayment_enum LONG,date_latestremotecall DATETIME,date_printbar DATETIME,date_printkitchen DATETIME,description TEXT/255,group_name TEXT/100,invoice_id LONG,obj_category LONG R,obj_id LONG PR,obj_name TEXT/50 R,price_type LONG,printer_bar TEXT/255,printer_kitchen TEXT/255,printer_name TEXT/255,seat_count LONG,show_order LONG,status_changed YESNO/2,status_extra BYTE,status_invoice BYTE,type_id LONG:code_br,obj_id,br_isloaded,branch_id,continued,group_name,invoice_id,obj_category,obj_name,price_type,printer_bar,printer_kitchen,printer_name,show_order,type_id,group_id
res_objgroup:group_id LONG PR,branch_id LONG,group_name TEXT/100 R,show_order BYTE:group_id,group_name,branch_id,show_order
res_obj_goodsin:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,invoice_date DATETIME R,obj_id LONG R,quantity DOUBLE R,trade_user_id LONG R:code_br,id,br_isloaded,branch_id,goods_id,invoice_date,obj_id,trade_user_id
res_obj_goodsout:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,invoice_date DATETIME R,obj_id LONG R,quantity DOUBLE R,trade_user_id LONG R:code_br,id,br_isloaded,branch_id,goods_id,invoice_date,obj_id,trade_user_id
res_obj_goodsuse:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,id LONG PR,invoice_id LONG R,obj_id LONG R,quantity DOUBLE R:code_br,id,br_isloaded,branch_id,goods_id,invoice_id,obj_id
res_obj_user:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,obj_id LONG R,user_id LONG R:code_br,id,br_isloaded,branch_id,obj_id,user_id
res_objtype:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,max_adults LONG R,max_children LONG R,obj_category BYTE,res_servicemincost DOUBLE,type_description MEMO,type_id LONG PR,type_name TEXT/255 R:code_br,type_id,br_isloaded,branch_id,obj_category,type_name
res_objtype_goods:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG R,unit_id LONG,id LONG PR,quantity DOUBLE R,res_objtype_id LONG R:code_br,id,br_isloaded,branch_id,goods_id,unit_id,res_objtype_id
res_objtype_price:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,hour_from DOUBLE,hour_to DOUBLE,hourinday_from DOUBLE,hourinday_to DOUBLE,id LONG PR,price_base LONG R,price_type LONG R,price_value DOUBLE R,type_id LONG R:code_br,id,br_isloaded,branch_id,price_base,price_type,type_id
res_remote_call:session_id TEXT/32,unit_id LONG,br_isloaded BYTE,branch_id LONG,call_date DATETIME R,code_br TEXT/32,comment TEXT/255,goods_id LONG R,id LONG PR,obj_id LONG R,quantity DOUBLE R,confirm_date DATETIME,status BYTE,user_id LONG R:code_br,id,br_isloaded,branch_id,call_date,goods_id,obj_id,confirm_date,user_id,unit_id,session_id
res_reserve:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,comming_date DATETIME R,contact_id LONG R,customer_count LONG R,discount_money DOUBLE R,is_deleted YESNO/2,is_finished YESNO/2,reserve_date DATETIME R,reserve_id LONG PR,reserve_money DOUBLE R,sum_money DOUBLE R,user_id LONG R:code_br,reserve_id,br_isloaded,branch_id,comming_date,contact_id,is_deleted,is_finished,reserve_date,user_id
res_reserve_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,discount DOUBLE R,goods_id LONG R,id LONG PR,quantity DOUBLE R,reserve_id LONG R,unit_price DOUBLE R:code_br,id,br_isloaded,branch_id,goods_id,reserve_id
res_reserve_obj:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,obj_id LONG R,reserve_id LONG R,user_id LONG R:code_br,id,br_isloaded,branch_id,obj_id,reserve_id,user_id
res_service_block:block_id LONG PR,block_name TEXT/50 R,br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32:block_name,block_id,br_isloaded,branch_id,code_br
res_service_block_details:block_id LONG R,id LONG PR,time_block SINGLE R,time_from SINGLE R,time_to SINGLE R:id,block_id,time_from
res_service_block_use:block_id LONG R,goods_id LONG R,id LONG PR:goods_id,id,block_id
res_service_pricedaytime:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,cost_min DOUBLE R,day_of_week LONG R,hour_price DOUBLE R,id LONG PR,service_id LONG R,time_from DATETIME,time_to DATETIME:code_br,id,br_isloaded,branch_id,day_of_week,service_id,time_from
res_service_priceusetime:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,discount_percent LONG R,hour_from LONG R,hour_to LONG R,id LONG PR,service_id LONG R:code_br,id,br_isloaded,branch_id,hour_from,service_id
res_setused:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,date_used DATETIME,exim_export_invoice_details_id LONG R,id LONG PR,is_importback YESNO/2,user_id LONG R:id,br_isloaded,branch_id,code_br,date_used,exim_export_invoice_details_id,user_id
res_usershift:br_isloaded YESNO/2,branch_id LONG,code_br TEXT/32,comment_end MEMO,comment_start MEMO,end_date DATETIME,id LONG PR,money_handover DOUBLE,money_init DOUBLE,money_receipt DOUBLE,start_date DATETIME,user_id LONG R:id,br_isloaded,branch_id,code_br,end_date,start_date,user_id
service_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment MEMO,contact_id LONG,date_from DATETIME,date_to DATETIME,invoice_date DATETIME R,invoice_id LONG PR,invoice_no TEXT/255,location_address TEXT/255,location_internal BYTE R,total_cost DOUBLE R,trade_user_id LONG:code_br,invoice_id,br_isloaded,branch_id,contact_id,invoice_date,invoice_no,location_internal,trade_user_id
service_invoice_details:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,invoice_id LONG R,service_cost DOUBLE,service_name TEXT/255,service_result TEXT/255,service_status TEXT/255:code_br,id,br_isloaded,branch_id,invoice_id
spa_appointment:appointment_date_from DATETIME R,appointment_date_to DATETIME,appointment_id LONG PR,appointment_status LONG R,comment MEMO,contact_id LONG R,created_date DATETIME R,total_cost LONG,user_id LONG R,work_user_id LONG:appointment_id,appointment_date_from,appointment_date_to,contact_id,created_date,work_user_id,user_id
spa_appointment_goods:appointment_id LONG R,goods_id LONG R,id LONG PR,quantity DOUBLE R,unit_price DOUBLE R:id,appointment_id,goods_id
spa_combo:combo_id LONG PR,combo_name TEXT/255 R,comment MEMO,contact_id LONG R,created_date DATETIME R,expired_date DATETIME,export_invoice_id LONG,money_debit DOUBLE R,money_discount DOUBLE R,money_total DOUBLE R,trade_user_id LONG R,user_id LONG R:export_invoice_id,combo_id,combo_name,contact_id,created_date,expired_date,trade_user_id,user_id
spa_combo_export_invoice:combo_id LONG R,export_invoice_id LONG R,id LONG PR:id,combo_id,export_invoice_id
spa_combo_goods:combo_id LONG R,goods_id LONG R,id LONG PR,quantity DOUBLE R,unit_price DOUBLE R:id,combo_id,goods_id
store_list:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,continued BYTE,is_main BYTE,store_address TEXT/255,store_code TEXT/5,store_id LONG PR,store_name TEXT/50 R:code_br,store_id,br_isloaded,branch_id,continued,is_main,store_name
user_advance_payment:ap_cost DOUBLE R,ap_date DATETIME R,ap_reason MEMO,br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,user_id LONG R:code_br,id,ap_date,br_isloaded,branch_id,user_id
user_commission_deployment:br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,comment TEXT/255,id LONG PR,invoice_id LONG R,user_id LONG R:code_br,id,br_isloaded,branch_id,invoice_id,user_id
user_commission_deployment_details:br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,exim_export_invoice_details_id LONG R,id LONG PR,invoice_id LONG R,money_deployment DOUBLE,user_count LONG R:code_br,id,br_isloaded,branch_id,exim_export_invoice_details_id,invoice_id
user_commission_sell:br_isloaded BYTE,branch_id LONG R,code_br TEXT/32,exim_export_invoice_details_id LONG R,id LONG PR,invoice_id LONG R,money_sell DOUBLE,user_id LONG R:code_br,id,br_isloaded,branch_id,exim_export_invoice_details_id,invoice_id,user_id
user_exim:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,contact_id LONG R,export_unit_price DOUBLE,goods_id LONG R,id LONG PR,import_invoice_no TEXT/20,import_unit_price DOUBLE,invoice_date DATETIME,invoice_no TEXT/20,quantity DOUBLE,unit_id LONG,user_id LONG R:code_br,id,br_isloaded,branch_id,contact_id,goods_id,invoice_date,unit_id,user_id
user_function:br_isloaded BYTE,branch_id LONG,can_add BYTE,can_remove BYTE,can_run BYTE,can_update BYTE,can_view BYTE,code_br TEXT/32,function_id LONG,id LONG PR,user_id LONG:code_br,id,br_isloaded,branch_id,function_id,user_id
user_group:group_name TEXT/32,group_id LONG PR,group_code TEXT/2,branch_id LONG,code_br TEXT/32:group_id,group_name,group_code,branch_id,code_br
user_list:group_code TEXT/2,event_last_view DATETIME,address TEXT/255,br_isloaded BYTE,branch_id LONG,can_signin BYTE R,clinic_isaccountant YESNO/2,clinic_isdoctor YESNO/2,cmnd TEXT/50,code_br TEXT/32,comment TEXT/255,crd_point LONG,date_birth DATETIME,homepage_code TEXT/32,is_lock BYTE R,mobile TEXT/25,onlinepage MEMO,password TEXT/50 R,realname TEXT/100 R,phone TEXT/50,salary_monthly DOUBLE,salary_shift_table TEXT/100,time_signin DATETIME,ui_pack TEXT/32,user_id LONG PR,user_title TEXT/50,username TEXT/50 R,valid BYTE R,pin_menu MEMO,homepage TEXT/100,admin LONG:code_br,user_id,username,br_isloaded,branch_id,can_signin,clinic_isaccountant,clinic_isdoctor,date_birth,valid,password,time_signin,group_code,admin
user_salary_shift:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,cost_off DOUBLE R,cost_offpen DOUBLE R,cost_work DOUBLE R,id LONG PR,shift_id LONG R,user_id LONG R:code_br,id,br_isloaded,branch_id,shift_id,user_id
user_salary_shift_table:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,cost_off DOUBLE R,cost_offpen DOUBLE R,cost_work DOUBLE R,id LONG PR,shift_id LONG R,table_name TEXT/100 R:code_br,id,br_isloaded,branch_id,shift_id,table_name
user_shift:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,from_hour BYTE R,from_min BYTE R,shift_id LONG PR,shift_name TEXT/255 R,to_hour BYTE R,to_min BYTE R:code_br,shift_id,br_isloaded,branch_id,shift_name
user_store:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,store_id LONG,user_id LONG:code_br,id,br_isloaded,branch_id,user_id,store_id
user_timekeeping:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,shift_id LONG,tk_cost DOUBLE R,tk_date DATETIME R,tk_type BYTE R,user_id LONG R:code_br,id,br_isloaded,branch_id,shift_id,tk_date,user_id
user_uipack:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,id LONG PR,ui_pack TEXT/32,user_id LONG:id,br_isloaded
warranty_customer_export:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,customer_export_id LONG PR,goods_id LONG,quantity_export DOUBLE R,serial MEMO,warranty_invoice_no TEXT/50 R:code_br,customer_export_id,br_isloaded,branch_id,goods_id,warranty_invoice_no
warranty_customer_import:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,customer_import_id LONG PR,goods_id LONG,quantity_import DOUBLE R,serial MEMO,warranty_invoice_no TEXT/50 R:code_br,customer_import_id,br_isloaded,branch_id,goods_id,warranty_invoice_no
warranty_invoice:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,comment TEXT/255,contact_id LONG,date_replying DATETIME,invoice_code TEXT/4 R,invoice_date DATETIME,invoice_id LONG PR,invoice_no TEXT/50,trade_user_id LONG,user_id LONG:code_br,invoice_id,br_isloaded,branch_id,contact_id,invoice_code,invoice_date,invoice_no,trade_user_id,user_id
warranty_supplier_export:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG,quantity_export DOUBLE R,serial MEMO,supplier_export_id LONG PR,warranty_invoice_no TEXT/50 R:code_br,supplier_export_id,br_isloaded,branch_id,goods_id,warranty_invoice_no
warranty_supplier_import:br_isloaded BYTE,branch_id LONG,code_br TEXT/32,goods_id LONG,quantity_import DOUBLE R,serial MEMO,supplier_import_id LONG PR,warranty_invoice_no TEXT/50 R:code_br,supplier_import_id,br_isloaded,branch_id,goods_id