address_city:branch_id LONG,city_code TEXT/255,city_id LONG PR,city_name TEXT/255,country_code TEXT/255:city_id,branch_id,city_code,city_name,country_code
address_country:branch_id LONG,code TEXT/3,country TEXT/100,country_e TEXT/50,country_id LONG PR,domain TEXT/50:country_id,branch_id,code,country_e,domain
alert:alert_src BYTE,alert_src_id LONG,branch_id LONG,created_date DATETIME,id LONG PR,read_date DATETIME,read_user_id LONG:id,alert_src,alert_src_id,branch_id,created_date,read_date,read_user_id
app_data_replace:branch_id LONG,code_br_des TEXT/32,code_br_src TEXT/32,data_type BYTE,id LONG PR,id_des LONG,id_src LONG:id,branch_id,code_br_des,code_br_src,data_type,id_des,id_src
app_function:branch_id LONG,function_id LONG PR,function_name TEXT/50,function_name_display TEXT/50,group_name TEXT/50:function_id,branch_id,function_name,function_name_display,group_name
app_goods_import_print:goods_id LONG,id LONG PR,import_invoice_id LONG,print_count LONG,branch_id LONG:id,goods_id,import_invoice_id,branch_id
app_homepage:branch_id LONG,code TEXT/32,data MEMO,id LONG PR,is_active INTEGER,name TEXT/100:id,branch_id,is_active,name,code
app_log:branch_id LONG,function_id LONG,id LONG PR,log_date DATETIME,log_src TEXT/50,log_src_id LONG,log_src_nobr TEXT/32,log_sync INTEGER,log_type INTEGER,user_id LONG,val_string TEXT/255,obj_id LONG:id,branch_id,function_id,log_date,log_src,log_src_id,log_src_nobr,log_sync,log_type,user_id,val_string,obj_id
app_log_resetpass:customer_code TEXT/30,customer_computername TEXT/30,customer_date DATETIME,customer_diskserial TEXT/30,id LONG PR,request_date DATETIME,techsupport_username TEXT/20:id,customer_code,customer_date,request_date
app_param:branch_id LONG,id LONG PR,param_name TEXT/50,val_bool INTEGER,val_currency DOUBLE,val_datetime DATETIME,val_double DOUBLE,val_long LONG,val_string MEMO:id,branch_id,param_name
app_param_printer:branch_id LONG,id LONG PR,printer_name TEXT/32,paper_size TEXT/2,printer_address TEXT/32,printer_type BYTE,is_valid BYTE:id,printer_name,branch_id,is_valid
bank:bank_id LONG PR,bank_name TEXT/100,bank_shortname TEXT/20,bin LONG,branch_id LONG:bank_id,bank_name,bank_shortname,branch_id,bin
bank_account:account_id LONG PR,account_init DOUBLE,account_number TEXT/50,account_owner TEXT/255,bank_code TEXT/10,bank_name TEXT/255,bank_shortname TEXT/20,bin LONG,branch_id LONG,continued INTEGER:account_id,account_number,bank_shortname,bank_code,bank_name,branch_id,continued
branch:branch_address TEXT/255,branch_email TEXT/255,branch_fax TEXT/50,branch_id LONG PR,branch_init_cash DOUBLE,branch_name TEXT/255 R,branch_phone TEXT/255,branch_taxcode TEXT/50,branch_website TEXT/255,customer_checksum MEMO,customer_code TEXT/20 R,customer_code5 TEXT/32 R,customer_password5 TEXT/32,group_id INTEGER,is_continued INTEGER R,pcserial TEXT/32,sync_password TEXT/32:branch_id,customer_code,branch_name,customer_code5,customer_password5,group_id,is_continued,sync_password
branch_contacts_group:branch_id LONG,group_id LONG,id LONG PR:id,branch_id,group_id
branch_contacts_replace:contact_code_br_from TEXT/32,contact_code_br_to TEXT/32,contact_id_from LONG,contact_id_to LONG,id LONG PR:id,contact_code_br_from,contact_code_br_to,contact_id_from,contact_id_to
branch_goods_replace:goods_code_br_from TEXT/32,goods_code_br_to TEXT/32,goods_id_from LONG,goods_id_to LONG,id LONG PR:id,goods_code_br_from,goods_code_br_to,goods_id_from,goods_id_to
branch_session:branch_id LONG,id LONG R,session_checkdate DATETIME,session_date DATETIME,session_syncdate DATETIME:branch_id,session_checkdate,session_date,session_syncdate
branch_store:branch_id LONG,id LONG PR,is_forswaponly BYTE,is_main BYTE,store_id LONG:id,branch_id,is_forswaponly,is_main,store_id
branch_store_public:branch_id LONG R,id LONG R,store_id LONG R:branch_id,store_id
branch_syncstatus:branch_id LONG,id LONG PR,sync_date DATETIME,sync_name TEXT/100:id,branch_id,sync_date,sync_name
branch_user:branch_id LONG,id LONG PR,is_admin BYTE,user_id LONG R:id,branch_id,is_admin,user_id
ccard:branch_id LONG,card_code TEXT/50 R,card_id LONG PR,category_id LONG,date_from DATETIME,date_to DATETIME:card_id,card_code,branch_id,category_id,date_from,date_to
ccard_category: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 INTEGER,category_name TEXT/255 R:category_id,category_code,category_name,branch_id,category_level
ccard_contact:branch_id LONG,card_code TEXT/50 R,contact_id LONG R,date_reg DATETIME R,id LONG PR,user_id LONG R:id,card_code,branch_id,contact_id,date_reg,user_id
ccard_exim_export_invoice:branch_id LONG,card_code TEXT/50,id LONG PR,invoice_discount_val DOUBLE R,invoice_id LONG R:id,branch_id,card_code,invoice_id
clinic_goods_guide:age_from DOUBLE,age_to DOUBLE,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 BYTE,use_isbefore_eating BYTE,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:test_id,exim_export_invoice_details_id,create_doctor_id,goods_id,medexam_id,result_doctor_id,test_doctor_id,test_status
contacts:bank_account MEMO,branch_id LONG,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 INTEGER,continued INTEGER R,date_birth DATETIME,debit_mustpayday DOUBLE,debit_mustpaymax DOUBLE,debit_mustrecday DOUBLE,debit_mustrecmax DOUBLE,debit_mustrecoverduemax INTEGER,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 INTEGER,type_supplier INTEGER,discount_foods DOUBLE,discount_drink DOUBLE,discount_service DOUBLE,discount_goods DOUBLE:contact_id,branch_id,contact_address,contact_cmnd,contact_code,contact_name,contact_sex,continued,date_birth,phone,tax_code,type_customer,type_supplier,bank_account
contacts_group:branch_id LONG,description MEMO,group_id LONG PR,group_name TEXT/50 R,hotline TEXT/255,group_code TEXT/20:group_id,group_name,branch_id,group_code
contacts_group_details:branch_id LONG,contact_id LONG R,group_id LONG R,id LONG PR:id,branch_id,contact_id,group_id
crd_details:branch_id LONG,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:id,branch_id,crd_date,type_id,user_id,user_id_operator
crd_type:branch_id LONG,money_add DOUBLE,money_sub DOUBLE,point LONG R,type_id LONG PR,type_name TEXT/100 R:type_id,type_name,branch_id
diary:branch_id LONG,category_id LONG,content MEMO,diary_date DATETIME R,diary_id LONG PR,user_id LONG:diary_id,branch_id,category_id,diary_date,user_id
diary_category:branch_id LONG,category_id LONG PR,category_name TEXT/50 R:category_id,branch_id,category_name
exim_delivery:address_id LONG R,branch_id LONG,delivery_cost DOUBLE,delivery_no TEXT/32,delivery_status INTEGER R,delivery_user_id LONG,finish_time DATETIME,id LONG PR,invoice_id_export LONG R,invoice_id_import LONG,is_export_invoice INTEGER,shipper_id LONG,shipper_note MEMO,start_time DATETIME,user_id LONG R,rc_contact_id LONG,so_contact_id LONG,sp_contact_id LONG,comment MEMO:id,address_id,branch_id,delivery_no,delivery_status,delivery_user_id,invoice_id_export,invoice_id_import,is_export_invoice,shipper_id,start_time,so_contact_id,sp_contact_id,user_id,rc_contact_id
exim_delivery_address:address TEXT/255 R,branch_id LONG,continued INTEGER R,id LONG PR:id,address,branch_id,continued
exim_expected_export_invoice:branch_id LONG,comment MEMO,contact_id LONG R,delivery_date DATETIME,invoice_id LONG PR,invoice_no TEXT/50,is_finished INTEGER R,order_date DATETIME,order_no TEXT/15,reason_other TEXT/2,receipt_debt_invoice_id LONG,total_cost DOUBLE,user_id LONG R,contact_supply_id LONG,money_rate DOUBLE:invoice_id,branch_id,contact_id,is_finished,order_no,receipt_debt_invoice_id,user_id,contact_supply_id
exim_expected_export_invoice_details:branch_id LONG,color_id LONG,comment MEMO,fas_size TEXT/10,goods_id LONG R,id LONG PR,invoice_id LONG R,quantity DOUBLE,unit_id INTEGER,unit_price DOUBLE:id,branch_id,color_id,fas_size,goods_id,invoice_id,unit_id
exim_expected_import_invoice:branch_id LONG,comment MEMO,contact_id LONG,contact_supply_id LONG,delivery_date DATETIME,invoice_id LONG PR,invoice_no TEXT/50,is_finished INTEGER,money_rate DOUBLE,order_date DATETIME,order_no TEXT/50,pay_debt_invoice_id LONG,total_cost DOUBLE,user_id LONG:invoice_id,branch_id,contact_id,contact_supply_id,is_finished,order_no,pay_debt_invoice_id,user_id
exim_expected_import_invoice_details:branch_id LONG,comment MEMO,goods_id LONG R,id LONG PR,invoice_id LONG R,quantity DOUBLE,unit_id INTEGER,unit_price DOUBLE,color_id LONG:id,branch_id,goods_id,invoice_id,unit_id,color_id
exim_export_import_back_details:branch_id LONG,exim_export_invoice_details_id LONG R,exim_import_invoice_details_id LONG R,id LONG PR,is_export INTEGER R:id,branch_id,exim_export_invoice_details_id,exim_import_invoice_details_id,is_export
exim_export_import_details:branch_id LONG,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 INTEGER R,quantity DOUBLE R,store_id LONG R,unit_id INTEGER:id,branch_id,export_invoice_details_id,goods_id,import_invoice_details_id,manual_add,store_id,unit_id
exim_export_import_goods_changed:branch_id LONG,date_changed DATETIME R,goods_id LONG R,id LONG PR,store_id INTEGER,unit_id INTEGER:id,branch_id,date_changed,goods_id,store_id,unit_id
exim_export_invoice:bank_account_id LONG,branch_id LONG,ccard_code TEXT/50,ccard_point_used DOUBLE,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_date DATETIME R,invoice_discount DOUBLE,invoice_id LONG PR,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,money_debit_nextpayment DATETIME,money_deduction DOUBLE,money_rate DOUBLE,pay_others DOUBLE,reason TEXT/2 R,reason_other TEXT/5,store_id LONG R,total_cost DOUBLE,trade_user_id LONG,user_id LONG R,vat DOUBLE,payment_method BYTE,clinic_medexam_id LONG,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,resinvoicesource LONG:invoice_id,bank_account_id,branch_id,ccard_code,contact_id,contact_id_extra,expected_invoice_id,invoice_date,invoice_no,reason,reason_other,store_id,trade_user_id,clinic_medexam_id,user_id,res_obj_id,invoice_date_end,payment_method,resinvoicesource
exim_export_invoice_details:branch_id LONG,ccard_point_accumulated DOUBLE,color_id LONG,comment TEXT/255,date_active DATETIME,date_alarm DATETIME,date_expired DATETIME,discount DOUBLE,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 DOUBLE,producer_code TEXT/32,qrimportid LONG,qrimportserial LONG,quantity DOUBLE,quantity_count DOUBLE,quantity_depth DOUBLE,quantity_height DOUBLE,quantity_width DOUBLE,serial MEMO,unit_id INTEGER,unit_price DOUBLE,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:id,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_export_invoice_details_old:branch_id LONG,ccard_point_accumulated DOUBLE,code_br TEXT/32,color_id LONG,comment TEXT/255,date_active DATETIME,date_alarm DATETIME,date_expired DATETIME,discount DOUBLE,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 DOUBLE,producer_code TEXT/32,qrimportid LONG,qrimportserial LONG,quantity DOUBLE,quantity_count DOUBLE,quantity_depth DOUBLE,quantity_height DOUBLE,quantity_width DOUBLE,serial MEMO,unit_id INTEGER,unit_price DOUBLE,warranty DOUBLE,br_isloaded BYTE,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:id,code_br,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,br_isloaded,spa_employee_id,spa_combo_id,id_parent,res_isremotecall,res_orderuserid
exim_goods_alarm:alarm_by TEXT/255,branch_id LONG,comment MEMO,date_alarm DATETIME,details_id LONG R,id LONG PR,is_export INTEGER R,user_id LONG R:id,branch_id,date_alarm,details_id,is_export,user_id
exim_goods_serial:branch_id LONG,details_id LONG R,id LONG PR,is_export INTEGER R,serial TEXT/20:id,branch_id,details_id,is_export,serial
exim_import_invoice:bank_account_id LONG,branch_id LONG,comment MEMO,contact_id LONG,contact_id_extra LONG,contact_note MEMO,expected_invoice_id LONG,invoice_date DATETIME R,invoice_discount DOUBLE,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_deduction DOUBLE,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,payment_method BYTE:invoice_id,bank_account_id,branch_id,contact_id,contact_id_extra,expected_invoice_id,invoice_date,invoice_no,reason,reason_other,store_id,trade_user_id,user_id,payment_method
exim_import_invoice_details:branch_id LONG,color_id LONG,comment TEXT/255,date_active DATETIME,date_alarm DATETIME,date_expired DATETIME,discount DOUBLE 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 DOUBLE,producer_code TEXT/32,quantity DOUBLE R,quantity_count DOUBLE,quantity_depth DOUBLE,quantity_height DOUBLE,quantity_width DOUBLE,serial MEMO,unit_id INTEGER,unit_price DOUBLE R,warranty DOUBLE:id,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:branch_id LONG,exim_export_invoice_details_id LONG R,exim_import_invoice_details_id LONG R,id LONG PR:id,exim_export_invoice_details_id,exim_import_invoice_details_id,branch_id
exim_swap_relation:branch_id LONG,export_invoice_id LONG,import_invoice_id LONG,import_store_id LONG,relation_id LONG PR:relation_id,branch_id,export_invoice_id,import_invoice_id,import_store_id
goods:goods_id LONG PR,goods_name TEXT/255 R,goods_name_web TEXT/255,branch_id LONG,goods_code TEXT/50,category_id LONG,ccard_point DOUBLE,comment MEMO,continued INTEGER 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_discount_default DOUBLE,goods_discount_money DOUBLE,goods_discount_wholesale_money DOUBLE,goods_discount_wholesale_percent DOUBLE,goods_sname TEXT/255,image_name TEXT/20,image_set MEMO,import_price DOUBLE R,net_weight DOUBLE,packing_size TEXT/20,packing_weight DOUBLE,price_extra MEMO,profit_default DOUBLE,profit_default_percent DOUBLE,profit_default_wholesale DOUBLE,profit_default_wholesale_percent DOUBLE,template_id LONG,time_price_update DATETIME,unit TEXT/50,warranty DOUBLE,latest_price DOUBLE,res_iscombo BYTE,res_ismix BYTE,res_nguyenlieu BYTE,res_objcategory BYTE,res_servicedefault BYTE,res_servicemincost DOUBLE,res_servicenodiscount BYTE,res_serviceorder LONG,res_thanhpham BYTE,spa_minutelimit LONG,spa_commission DOUBLE,export_price_sale DOUBLE,thumbnail_ext TEXT/10,web_stock_status BYTE,web_is_hasattribute BYTE,web_order_online BYTE,web_producer_id INTEGER,web_order_min DOUBLE,web_visited_count LONG,web_order_count LONG:goods_id,branch_id,category_id,continued,export_price_hourlycharge,goods_code,goods_name,goods_sname,template_id,time_price_update,res_iscombo,res_ismix,res_nguyenlieu,res_objcategory,res_servicedefault,res_servicenodiscount,res_serviceorder,res_thanhpham,goods_name_web
goods_alarmdate:alarm_date DOUBLE R,branch_id INTEGER,goods_id LONG R,id LONG PR,unit_id INTEGER,unit_name TEXT/50,unit_ratio DOUBLE:id,branch_id,goods_id,unit_id,unit_name
goods_attribute:alarm_date DOUBLE,branch_id LONG,goods_id LONG R,id LONG PR,limited_date DOUBLE,unit_id INTEGER,unit_ratio DOUBLE,attr_name TEXT/255,export_price DOUBLE,export_price_wholesale DOUBLE:id,alarm_date,branch_id,goods_id,limited_date,unit_id
goods_category:branch_id LONG,category_code TEXT/50,category_discount_default DOUBLE,category_id LONG PR,category_name TEXT/255 R,category_service BYTE,comment MEMO,description MEMO,continued INTEGER R,fas_size TEXT/255,res_doan BYTE,res_douong BYTE,parent_id LONG,web_in_level BYTE,web_in_order BYTE,res_goods_category_type BYTE,web_goods_sumary_template MEMO,web_goods_description_template MEMO,web_children_count INTEGER:category_id,branch_id,category_code,category_name,category_service,continued,res_doan,res_douong,parent_id,res_goods_category_type
goods_color:branch_id LONG,color_id LONG PR,color_name TEXT/100 R,color_rgb TEXT/6,short_name TEXT/8:color_id,branch_id,color_name,short_name
goods_comment:id LONG PR,comment TEXT/255:id
goods_commission:branch_id LONG,goods_id LONG R,id LONG PR,number_deployment DOUBLE,number_sell DOUBLE,percent_deployment DOUBLE,percent_sell DOUBLE,unit_id INTEGER,user_id LONG:id,branch_id,goods_id,unit_id,user_id
goods_labeled:id LONG PR,branch_id LONG,goods_id LONG R:id,branch_id,goods_id
goods_limiteddate:branch_id INTEGER,goods_id LONG R,id LONG PR,limited_date DATETIME R,unit_id INTEGER,unit_name TEXT/50,unit_ratio DOUBLE:id,branch_id,goods_id,limited_date,unit_id,unit_name
goods_mix_details:branch_id LONG,goods_child_id LONG,goods_main_id LONG,goods_mix_template_details_id LONG,id LONG PR,quantity DOUBLE,unit_id INTEGER,unit_price_autoget BYTE:id,branch_id,goods_child_id,goods_main_id,goods_mix_template_details_id,unit_id
goods_mix_template:branch_id LONG,template_id LONG PR,template_name TEXT/50 R:template_id,template_name,branch_id
goods_mix_template_details:branch_id LONG,category_id LONG R,id LONG PR,label TEXT/100,template_id LONG R,web_in_order BYTE:id,branch_id,category_id,template_id
goods_price_bycustomer:branch_id LONG,category_id LONG,contact_id LONG R,discount_bycustomer DOUBLE,expired_date DATETIME,export_price_bycustomer DOUBLE R,goods_id LONG R,pricebycustomer_id LONG PR,unit_id LONG:pricebycustomer_id,branch_id,category_id,contact_id,expired_date,goods_id,unit_id
goods_pricename:branch_id LONG,pricename_id LONG PR,pricename_label TEXT/50:pricename_id,branch_id,pricename_label
goods_pricename_val:branch_id LONG,date_updated DATETIME,goods_id LONG R,price_extra DOUBLE,pricename_id LONG,pricenameval_id LONG PR,unit_id INTEGER:pricenameval_id,branch_id,date_updated,goods_id,pricename_id,unit_id
goods_pricetemplate:branch_id LONG,is_mix INTEGER,pricetemplate_id LONG PR,pricetemplate_name TEXT/255:pricetemplate_id,pricetemplate_name,branch_id,is_mix
goods_pricetemplate_categoryorder:branch_id LONG,category_id LONG R,id LONG PR,pricetemplate_id LONG R,template_order LONG R:id,branch_id,category_id,pricetemplate_id,template_order
goods_pricetemplate_notes:content MEMO,date_from DATETIME,date_to DATETIME,id LONG PR,pricetemplate_id LONG R:id,date_from,date_to,pricetemplate_id
goods_pricetemplatedetails:branch_id LONG,goods_id LONG R,id LONG PR,pricetemplate_id LONG,unit_id INTEGER:id,branch_id,goods_id,pricetemplate_id,unit_id
goods_pricetemplatemix:branch_id LONG,pricetemplate_id LONG,pricetemplatemix_id LONG PR,pricetemplatemix_name TEXT/255,template_id LONG:pricetemplatemix_id,branch_id,pricetemplate_id,pricetemplatemix_name,template_id
goods_pricetemplatemix_details:branch_id LONG,goods_id LONG R,goods_mix_template_details_id LONG,id LONG PR,pricetemplatemix_id LONG R,quantity DOUBLE R,unit_id INTEGER:id,branch_id,goods_id,goods_mix_template_details_id,pricetemplatemix_id,unit_id
goods_stocktaking:stocktaking_id LONG PR,branch_id LONG,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,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
goods_store_param:branch_id LONG,color_id LONG,expired_date DATETIME,fas_size TEXT/10,goods_id LONG R,import_price_init DOUBLE,instock_min DOUBLE,lot_number TEXT/15,param_id LONG PR,quantity_init DOUBLE R,quantity_stock DOUBLE,store_id LONG,unit_id INTEGER:param_id,branch_id,color_id,expired_date,fas_size,goods_id,lot_number,store_id,unit_id
goods_tracking:id LONG PR,branch_id LONG,goods_id LONG R,unit_id LONG R,store_id LONG R,quantity DOUBLE,update_date DATETIME,user_id LONG R,color_id LONG:id,branch_id,goods_id,store_id,user_id,color_id
goods_tracking_details:id LONG PR,branch_id LONG,tracking_id LONG R,goods_id LONG R,unit_id LONG R,quantity DOUBLE,color_id LONG:id,branch_id,tracking_id,goods_id,unit_id,color_id
goods_unit:branch_id LONG,continued BYTE,export_price DOUBLE,export_price_wholesale DOUBLE,goods_code_unit TEXT/50,goods_discount_default DOUBLE,goods_discount_money DOUBLE,goods_discount_wholesale_money DOUBLE,goods_discount_wholesale_percent DOUBLE,goods_id LONG R,import_price DOUBLE,is_autopricefrombase INTEGER,net_weight DOUBLE,packing_size TEXT/20,packing_weight DOUBLE,price_extra MEMO,profit_default DOUBLE,profit_default_percent DOUBLE,profit_default_wholesale DOUBLE,profit_default_wholesale_percent DOUBLE,time_price_update DATETIME,unit_id LONG PR,unit_name TEXT/50 R,unit_ratio DOUBLE R,ccard_point DOUBLE:unit_id,branch_id,continued,goods_code_unit,goods_id,is_autopricefrombase,time_price_update,unit_name
goods_web:goods_id LONG PR,goods_name TEXT/255 R,branch_id LONG,goods_code TEXT/50,category_id LONG,ccard_point DOUBLE,code_br TEXT/32,comment MEMO,continued INTEGER 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_discount_default DOUBLE,goods_discount_money DOUBLE,goods_discount_wholesale_money DOUBLE,goods_discount_wholesale_percent DOUBLE,goods_sname TEXT/255,image_name TEXT/20,image_set MEMO,import_price DOUBLE R,net_weight DOUBLE,packing_size TEXT/20,packing_weight DOUBLE,price_extra MEMO,profit_default DOUBLE,profit_default_percent DOUBLE,profit_default_wholesale DOUBLE,profit_default_wholesale_percent DOUBLE,template_id LONG,time_price_update DATETIME,unit TEXT/50,warranty DOUBLE,br_isloaded BYTE,latest_price DOUBLE,res_iscombo BYTE,res_ismix BYTE,res_nguyenlieu BYTE,res_objcategory BYTE,res_servicedefault BYTE,res_servicemincost DOUBLE,res_servicenodiscount BYTE,res_serviceorder LONG,res_thanhpham BYTE,spa_minutelimit LONG,spa_commission DOUBLE,export_price_sale DOUBLE,thumbnail_ext TEXT/10,web_stock_status BYTE,web_is_hasattribute BYTE,web_order_online BYTE,web_producer_id INTEGER,web_order_min DOUBLE,web_visited_count LONG,web_order_count LONG:goods_id,code_br,branch_id,category_id,continued,export_price_hourlycharge,goods_code,goods_name,goods_sname,template_id,time_price_update,br_isloaded,res_iscombo,res_ismix,res_nguyenlieu,res_objcategory,res_servicedefault,res_servicenodiscount,res_serviceorder,res_thanhpham
job_schedule:branch_id LONG,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:job_id,branch_id,date_create,date_must_finish,user_id,user_id_finish,user_id_operator
pay_debt:bank_accountid LONG,branch_id LONG,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:invoice_id,bank_accountid,branch_id,contact_id,exim_import_invoice_id,exim_import_invoice_no,invoice_date,store_id,trade_user_id,user_id
pay_debt_import_invoice:branch_id LONG,id LONG PR,import_invoice_id LONG R,is_manual BYTE,pay_invoice_id LONG R,pay_val DOUBLE:id,branch_id,import_invoice_id,is_manual,pay_invoice_id
pay_others:bank_accountid LONG,branch_id LONG,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 INTEGER,store_id LONG,type_id LONG,user_id LONG:invoice_id,bank_accountid,branch_id,contact_id,employee_user_id,export_invoice_id,export_invoice_voucher,import_invoice_id,import_invoice_voucher,invoice_date,store_id,type_id,user_id
pay_type:branch_id LONG,comment TEXT/255,type_id LONG PR,type_name TEXT/50 R:type_id,branch_id,type_name
price_quotation:branch_id LONG,comment MEMO,contact_id LONG R,expired_date DATETIME,from_date DATETIME,quotation_id LONG PR,quotation_name TEXT/255 R,quotation_ps MEMO,user_id LONG R:quotation_id,branch_id,contact_id,quotation_name,user_id
price_quotation_details:branch_id LONG,comment MEMO,goods_id LONG R,id LONG PR,quantity DOUBLE,quotation_id LONG R,unit_id INTEGER R,unit_price DOUBLE,warranty DOUBLE:id,branch_id,goods_id,quotation_id,unit_id
promotion_goods:branch_id LONG,goods_id LONG R,id LONG PR,max_quantity DOUBLE,program_id LONG R,unit_id INTEGER R:id,branch_id,goods_id,program_id,unit_id
promotion_goods_quantity:branch_id LONG,discount DOUBLE,id LONG PR,promotion_goods_id LONG R,quantity_base DOUBLE R:id,branch_id,promotion_goods_id,quantity_base
promotion_goods_quantity_attach:branch_id LONG,goods_id LONG R,id LONG PR,is_onetime BYTE,is_retail BYTE,is_wholesale BYTE,promotion_goods_quantity_id LONG R,quantity_attach DOUBLE R,unit_id LONG R:id,branch_id,goods_id,is_onetime,is_retail,is_wholesale,promotion_goods_quantity_id,unit_id
promotion_program:branch_id LONG,date_from DATETIME R,date_to DATETIME R,max_money_promotion DOUBLE R,program_id LONG PR,program_name TEXT/255 R:program_id,branch_id,program_name
receipt_debt:bank_accountid LONG,branch_id LONG,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:invoice_id,bank_accountid,branch_id,contact_id,exim_export_invoice_id,exim_export_invoice_no,invoice_date,store_id,trade_user_id,user_id
receipt_debt_export_invoice:branch_id LONG,export_invoice_id LONG R,id LONG PR,is_manual BYTE,receipt_invoice_id LONG R,receipt_val DOUBLE R:id,branch_id,export_invoice_id,is_manual,receipt_invoice_id
receipt_others:bank_accountid LONG,branch_id LONG,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 INTEGER,store_id LONG,swap_invoice_id LONG,type_id LONG,user_id LONG:invoice_id,bank_accountid,branch_id,contact_id,employee_user_id,export_invoice_id,import_invoice_id,invoice_date,invoice_no,is_external,store_id,swap_invoice_id,type_id,user_id
receipt_type:branch_id LONG,comment TEXT/255,type_id LONG PR,type_name TEXT/50 R:type_id,branch_id,type_name
repair_extern_details:branch_id LONG,contact_id LONG R,employee_id LONG R,id LONG PR,invoice_date DATETIME R,is_send INTEGER R,pay_others_invoice_id LONG,quantity DOUBLE R,repair_cost DOUBLE,repair_invoice_details_id LONG R:id,branch_id,contact_id,employee_id,invoice_date,is_send,pay_others_invoice_id,repair_invoice_details_id
repair_invoice:branch_id LONG,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:invoice_id,branch_id,contact_id,invoice_date,invoice_no,reply_date,return_date,trade_user_id,user_id
repair_invoice_details:accessories TEXT/255,branch_id LONG,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:id,branch_id,exim_export_invoice_id,repair_user_id,invoice_id
repair_return_invoice:branch_id LONG,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:invoice_id,branch_id,contact_id,invoice_date,receipt_debt_invoice_id,trade_user_id,user_id
repair_return_invoice_details:branch_id LONG,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:id,branch_id,invoice_id,repair_invoice_details_id
repair_status:adjust_date DATETIME R,branch_id LONG,id LONG PR,is_fixed INTEGER R,quantity DOUBLE R,repair_invoice_details_id LONG R,trade_user_id LONG R:id,adjust_date,branch_id,is_fixed,repair_invoice_details_id,trade_user_id
res_goods_label:branch_id LONG,goods_id LONG R,id LONG PR:id,goods_id,branch_id
res_invoice_log:branch_id LONG,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:id,branch_id,date_updated,goods_id,invoice_id,obj_id,reason_id,user_id
res_invoice_service:branch_id LONG,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:id,branch_id,employee_id,goods_id,invoice_id,spa_combo_id
res_invoice_source:source_id LONG PR,branch_id LONG,source_name TEXT/100,extra_charge DOUBLE,continued BYTE,contact_id LONG,payment_debit BYTE:source_id,branch_id,source_name,continued,contact_id
res_locklist:branch_id LONG,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:lock_id,branch_id,date_from,date_to,user_id
res_locklist_details:branch_id LONG,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:id,branch_id,contact_id,invoice_id,lock_id,trade_user_id,user_id
res_mix:branch_id LONG,id LONG PR,invoice_id_from LONG R,invoice_id_to LONG R:id,branch_id,invoice_id_to
res_obj:group_id LONG,branch_id LONG,continued BYTE,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 BYTE,status_extra BYTE,status_invoice BYTE,type_id LONG:obj_id,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_obj_goodsin:branch_id LONG,goods_id LONG R,id LONG PR,invoice_date DATETIME R,obj_id LONG R,quantity DOUBLE R,trade_user_id LONG R:id,branch_id,goods_id,invoice_date,obj_id,trade_user_id
res_obj_goodsout:branch_id LONG,goods_id LONG R,id LONG PR,invoice_date DATETIME R,obj_id LONG R,quantity DOUBLE R,trade_user_id LONG R:id,branch_id,goods_id,invoice_date,obj_id,trade_user_id
res_obj_goodsuse:branch_id LONG,goods_id LONG R,id LONG PR,invoice_id LONG R,obj_id LONG R,quantity DOUBLE R:id,branch_id,goods_id,invoice_id,obj_id
res_obj_user:branch_id LONG,id LONG PR,obj_id LONG R,user_id LONG R:id,branch_id,obj_id,user_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_objtype:branch_id LONG,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:type_id,branch_id,obj_category,type_name
res_objtype_goods:branch_id LONG,goods_id LONG R,unit_id LONG,id LONG PR,quantity DOUBLE R,res_objtype_id LONG R:id,branch_id,goods_id,unit_id,res_objtype_id
res_objtype_price:branch_id LONG,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:id,branch_id,price_base,price_type,type_id
res_remote_call:session_id TEXT/32,unit_id LONG,branch_id LONG,call_date DATETIME R,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:id,branch_id,call_date,goods_id,obj_id,confirm_date,user_id,unit_id,session_id
res_reserve:branch_id LONG,comment TEXT/255,comming_date DATETIME R,contact_id LONG R,customer_count LONG R,discount_money DOUBLE R,is_deleted BYTE,is_finished BYTE,reserve_date DATETIME R,reserve_id LONG PR,reserve_money DOUBLE R,sum_money DOUBLE R,user_id LONG R:reserve_id,branch_id,comming_date,contact_id,is_deleted,is_finished,reserve_date,user_id
res_reserve_details:branch_id LONG,discount DOUBLE R,goods_id LONG R,id LONG PR,quantity DOUBLE R,reserve_id LONG R,unit_price DOUBLE R:id,branch_id,goods_id,reserve_id
res_reserve_obj:branch_id LONG,id LONG PR,obj_id LONG R,reserve_id LONG R,user_id LONG R:id,branch_id,obj_id,reserve_id,user_id
res_service_block:block_id LONG PR,block_name TEXT/50 R,branch_id LONG:block_id,block_name,branch_id
res_service_block_details:block_id LONG R,id LONG PR,time_block DOUBLE R,time_from DOUBLE R,time_to DOUBLE R:id,block_id,time_from
res_service_block_use:block_id LONG R,goods_id LONG R,id LONG PR:id,goods_id,block_id
res_service_pricedaytime:branch_id LONG,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:id,branch_id,day_of_week,service_id,time_from
res_service_priceusetime:branch_id LONG,discount_percent LONG R,hour_from LONG R,hour_to LONG R,id LONG PR,service_id LONG R:id,branch_id,hour_from,service_id
res_setused:branch_id LONG,date_used DATETIME,exim_export_invoice_details_id LONG R,id LONG PR,is_importback BYTE,user_id LONG R:id,branch_id,date_used,exim_export_invoice_details_id,user_id
res_usershift:branch_id LONG,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,branch_id,end_date,start_date,user_id
service_invoice:branch_id LONG,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 INTEGER R,total_cost DOUBLE R,trade_user_id LONG:invoice_id,branch_id,contact_id,invoice_date,invoice_no,location_internal,trade_user_id
service_invoice_details:branch_id LONG,id LONG PR,invoice_id LONG R,service_cost DOUBLE,service_name TEXT/255,service_result TEXT/255,service_status TEXT/255:id,branch_id,invoice_id
shipper:branch_id LONG,continued INTEGER,shipper_comment TEXT/255,shipper_id LONG PR,shipper_name TEXT/50,shipper_phone TEXT/100:shipper_id,branch_id,continued,shipper_name
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:combo_id,export_invoice_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:branch_id LONG,comment TEXT/255,continued INTEGER,is_main INTEGER,store_address TEXT/255,store_code TEXT/5,store_id LONG PR,store_name TEXT/50 R:store_id,branch_id,continued,is_main,store_name
user_advance_payment:ap_cost DOUBLE R,ap_date DATETIME R,ap_reason MEMO,branch_id LONG,id LONG PR,user_id LONG R:id,ap_date,branch_id,user_id
user_commission_deployment:branch_id LONG,comment TEXT/255,id LONG PR,invoice_id LONG R,user_id LONG R:id,branch_id,invoice_id,user_id
user_commission_deployment_details:branch_id LONG,exim_export_invoice_details_id LONG R,id LONG PR,invoice_id LONG R,money_deployment DOUBLE,user_count LONG R:id,branch_id,exim_export_invoice_details_id,invoice_id
user_commission_sell:branch_id LONG,exim_export_invoice_details_id LONG R,id LONG PR,invoice_id LONG R,money_sell DOUBLE,user_id LONG R:id,branch_id,exim_export_invoice_details_id,invoice_id,user_id
user_exim:branch_id LONG,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 INTEGER R,user_id LONG R:id,branch_id,contact_id,goods_id,invoice_date,unit_id,user_id
user_function:branch_id LONG,can_add INTEGER,can_remove INTEGER,can_run INTEGER,can_update INTEGER,can_view INTEGER,function_id LONG,id LONG PR,user_id LONG R:id,branch_id,function_id,user_id
user_group:group_name TEXT/32,group_id LONG PR,group_code TEXT/2,branch_id LONG:group_id,group_name,group_code,branch_id
user_list:address TEXT/255,admin INTEGER R,branch_id LONG,can_signin INTEGER R,cmnd TEXT/50,comment TEXT/255,crd_point LONG,date_birth DATETIME,homepage_code TEXT/32,is_lock INTEGER R,mobile TEXT/50,onlinepage MEMO,password TEXT/50 R,realname TEXT/100 R,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 INTEGER R,group_code TEXT/2,event_last_view DATETIME,clinic_isaccountant BYTE,clinic_isdoctor BYTE,phone TEXT/50,pin_menu MEMO,homepage TEXT/100:user_id,username,admin,branch_id,can_signin,date_birth,password,time_signin,valid,clinic_isaccountant,clinic_isdoctor,group_code
user_salary_shift:branch_id LONG,cost_off DOUBLE R,cost_offpen DOUBLE R,cost_work DOUBLE R,id LONG PR,shift_id LONG R,user_id LONG R:id,branch_id,shift_id,user_id
user_salary_shift_table:branch_id LONG,cost_off DOUBLE R,cost_offpen DOUBLE R,cost_work DOUBLE R,id LONG PR,shift_id LONG R,table_name TEXT/100 R:id,branch_id,shift_id,table_name
user_shift:branch_id LONG,from_hour INTEGER R,from_min INTEGER R,shift_id LONG PR,shift_name TEXT/255 R,to_hour INTEGER R,to_min INTEGER R:shift_id,branch_id,shift_name
user_store:branch_id LONG,id LONG PR,store_id LONG R,user_id LONG R:id,branch_id,store_id,user_id
user_timekeeping:branch_id LONG,id LONG PR,shift_id LONG,tk_cost DOUBLE R,tk_date DATETIME R,tk_type INTEGER R,user_id LONG R:id,branch_id,shift_id,tk_date,user_id
user_uipack:branch_id LONG,id LONG PR,ui_pack TEXT/32,user_id LONG:id,branch_id,ui_pack,user_id
warranty_customer_export:branch_id LONG,customer_export_id LONG PR,goods_id LONG,quantity_export DOUBLE R,serial MEMO,warranty_invoice_no TEXT/50 R:customer_export_id,branch_id,goods_id,warranty_invoice_no
warranty_customer_import:branch_id LONG,customer_import_id LONG PR,goods_id LONG,quantity_import DOUBLE R,serial MEMO,warranty_invoice_no TEXT/50 R:customer_import_id,branch_id,goods_id,warranty_invoice_no
warranty_invoice:branch_id LONG,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:invoice_id,branch_id,contact_id,invoice_code,invoice_date,invoice_no,trade_user_id,user_id
warranty_supplier_export:branch_id LONG,goods_id LONG,quantity_export DOUBLE R,serial MEMO,supplier_export_id LONG PR,warranty_invoice_no TEXT/50 R:supplier_export_id,branch_id,goods_id,warranty_invoice_no
warranty_supplier_import:branch_id LONG,goods_id LONG,quantity_import DOUBLE R,serial MEMO,supplier_import_id LONG PR,warranty_invoice_no TEXT/50 R:supplier_import_id,branch_id,goods_id
web_adv:adv_id INTEGER PR,description TEXT/255,url TEXT/255 R,file_name TEXT/100,file_type TEXT/10,file_width INTEGER R,file_height INTEGER R:adv_id
web_configs:id LONG PR,config_name TEXT/100 R,config_val MEMO:id,config_name,config_name
web_download:download_id LONG PR,category_id LONG R,title TEXT/255 R,url TEXT/255 R,description MEMO,date_updated DATETIME:download_id,title,title
web_download_category:category_id INTEGER PR,title TEXT/100 R,parent_id LONG R,children_count INTEGER R,prd_count INTEGER R,web_in_level BYTE R,web_in_order BYTE:category_id,web_in_order,title,web_in_order,title
web_feedback:id LONG PR,poster_email TEXT/100 R,poster_name TEXT/100,address TEXT/255,contents MEMO R,reply MEMO,date_post DATETIME R,public BYTE:id,public,public
web_files:file_id LONG PR,file_name TEXT/255 R,file_type TEXT/20 R,file_size DOUBLE R,owner_id LONG,owner_type TEXT/10 R:file_id,file_name,owner_type,owner_id,file_name,owner_type,owner_id
web_gallery:gallery_id LONG PR,title TEXT/255,title_en TEXT/100,date_updated DATETIME R,visited_count LONG,description MEMO:gallery_id,date_updated,visited_count,date_updated,visited_count
web_gallery_file:id LONG PR,gallery_id LONG R,file_id LONG R,thumbnail_file_id LONG R:id,gallery_id,file_id,file_id,gallery_id,file_id
web_goods:title TEXT/255,goods_code TEXT/20,goods_id LONG PR,category_id INTEGER R,unit TEXT/50 R,import_money_param TEXT/3,retail_money_param TEXT/3,wholesale_money_param TEXT/3,unit_price DOUBLE,unit_price_sale DOUBLE,unit_price_sub DOUBLE,unit_price_wholesale DOUBLE,unit_price_wholesale_sub DOUBLE,unit_price_prev DOUBLE,unit_price_import DOUBLE,unit_price_import_sub DOUBLE,profit_retail_max DOUBLE,profit_wholesale_max DOUBLE,description MEMO,sumary MEMO,date_updated DATETIME R,order_count LONG,visited_count LONG R,order_online BYTE R,order_min INTEGER,producer_id INTEGER R,stock BYTE R,warranty BYTE,thumbnail_ext TEXT/10,combination_id LONG R,is_hasattribute BYTE:goods_id,goods_code,category_id,date_updated,order_count,title,producer_id,combination_id,goods_code,category_id,date_updated,order_count,title,producer_id,combination_id,description,description
web_goods_attribute:id LONG PR,goods_id LONG R,attr_name TEXT/255,export_price DOUBLE,export_price_wholesale DOUBLE:id,goods_id
web_goods_cart:cart_id LONG PR,session_id TEXT/32 R,goods_id LONG R,quantity LONG R,combination_id LONG,parent_id LONG:cart_id,session_id,goods_id,combination_id,parent_id,session_id,goods_id,combination_id,parent_id
web_goods_category_property:property_id LONG PR,category_id LONG R,property_name TEXT/100 R,property_multi_value BYTE R:property_id,category_id,category_id
web_goods_category_property_value:property_value_id LONG PR,property_id LONG R,property_value TEXT/100 R:property_value_id,property_id,property_id
web_goods_news:id LONG PR,goods_id LONG R,news_id LONG R:id,goods_id,news_id,goods_id,news_id
web_goods_order:order_id LONG PR,order_code TEXT/32,order_time DATETIME R,done_time DATETIME,dealer_code TEXT/32,payment_method BYTE,delivery_method BYTE,contact_name TEXT/50 R,total_cost LONG R,address TEXT/100 R,email TEXT/60 R,phone TEXT/20 R,is_readed BYTE R,comment MEMO:order_id,order_time,is_readed,order_code,email,delivery_method,order_time,is_readed,order_code,email,delivery_method
web_goods_order_details:id LONG PR,order_id LONG R,goods_id LONG R,unit_id INTEGER R,quantity LONG R,unit_price DOUBLE R:id,goods_id,order_id,unit_id,goods_id,order_id,unit_id
web_goods_producer:producer_id INTEGER PR,producer TEXT/50 R,website TEXT/50:producer_id,producer,producer
web_goods_property_value:id LONG PR,goods_id LONG R,property_value_id LONG R:id,goods_id,property_value_id,goods_id,property_value_id
web_mail_category:category_id LONG PR,category_name TEXT/255 R:category_id,category_name,category_name
web_mail_list:mail_id LONG PR,category_id LONG R,mail TEXT/255 R:mail_id,mail,category_id,mail,mail,category_id
web_mail_list_remove:id LONG PR,mail TEXT/255 R:id,mail,mail
web_news:news_id INTEGER PR,title TEXT/255 R,summary MEMO,contents MEMO,contents_old MEMO R,thumbnail_ext TEXT/10,date_updated DATETIME R,date_created DATETIME R,source TEXT/100,admin_id BYTE R,visited_count INTEGER R,printed_count INTEGER R,category_id LONG R:news_id,date_updated,admin_id,visited_count,category_id,date_created,date_updated,admin_id,visited_count,category_id,date_created
web_news_category:category_id BYTE PR,category_code TEXT/100,category_name TEXT/150 R,description MEMO,parent_id INTEGER R,web_in_level BYTE,web_in_order BYTE,web_children_count BYTE,visibled BYTE R,lang TEXT/2,description_short MEMO:category_id,parent_id,visibled,category_code,lang,parent_id,visibled,category_code,lang
web_news_reply:reply_id LONG PR,news_id LONG R,user_email TEXT/255 R,user_name TEXT/255 R,reply_content MEMO R,reply_time DATETIME R,show_public BYTE R:reply_id,news_id,reply_time,news_id,reply_time
web_pages:page_id INTEGER PR,page_title TEXT/50 R,page_name TEXT/50 R:page_id,page_title,page_name,page_title,page_name
web_ui_col_box:box_id INTEGER PR,box_name TEXT/50 R,box_filename TEXT/50 R:box_id
web_ui_col_box_item:id LONG PR,box_id INTEGER R,source TEXT/10,leftside BYTE R,page TEXT/255:id,box_id,leftside,page,box_id,leftside,page
web_ui_home_banner:banner_id LONG PR,banner_type TEXT/10 R,banner_file TEXT/100 R,web_template TEXT/50 R,width INTEGER R,height INTEGER R,active BYTE R:banner_id,active,active
web_ui_home_box:id LONG PR,box_name TEXT/50,description MEMO,box_in_order BYTE,column_count BYTE R,style LONG R,lang TEXT/2,url TEXT/255,url_title MEMO:id,box_name,box_in_order,box_name,lang,box_name,box_in_order,lang
web_ui_home_box_item:id LONG PR,box_id LONG,in_order BYTE R,source_news LONG,source_goods LONG,source_image TEXT/100,source_url TEXT/255,file_type TEXT/10,file_width LONG,file_height LONG,show_title BYTE R,show_price BYTE R:id,in_order,box_id,in_order,box_id
web_ui_home_goodsfocus:id LONG PR,goods_id LONG R,web_in_order BYTE:id,goods_id,goods_id
web_ui_home_imageslide:id LONG PR,image_filename TEXT/100,comment TEXT/255,url TEXT/255:id
web_ui_menu:id LONG PR,name TEXT/10 R,title TEXT/100,url TEXT/255:id,name,name
web_ui_menu_item:id LONG PR,type BYTE,name TEXT/50 R,title TEXT/100 R,description TEXT/160,url TEXT/255,view_order BYTE R,is_visible BYTE R,is_authen BYTE R,parent_id INTEGER R,in_path TEXT/100,web_in_level BYTE,target_newwindow BYTE:id,name,view_order,is_visible,is_authen,in_path,type,name,view_order,is_visible,is_authen,in_path,type
web_userright:right_id INTEGER PR,username TEXT/32 R,page_id INTEGER R:right_id,username,username
web_video_clip:clip_id LONG PR,clip_title TEXT/255,clip_thumbnail TEXT/100,clip_url TEXT/255 R:clip_id
eiv_exim_export_invoice:id LONG PR,invoice_id LONG R,eiv_id_attr TEXT/36 R,eiv_lookup_code TEXT/20 R,eiv_statusInv INTEGER,eiv_no TEXT/12,eiv_code_cqt TEXT/40,eiv_autoSign INTEGER,eiv_sendCQT INTEGER,eiv_msgSendCQT MEMO,eiv_createtime DATETIME,eiv_updatetime DATETIME,eiv_deletetime DATETIME:id,invoice_id,eiv_id_attr,eiv_lookup_code,eiv_createtime,eiv_updatetime,eiv_statusInv,eiv_code_cqt
eiv_goods_category_tax:id LONG PR,category_id LONG R,tax DOUBLE R:id,category_id
eiv_goods:id LONG PR,goods_id LONG R,eiv_goods_name TEXT/255:id,goods_id,eiv_goods_name