
p8_hr_person , p8_hr_content_2 ӦƸߵļ,ÿֻдһ


p8_hr_content , p8_hr_content_1 ְλ




qb_hr_apply	ӦƸĳְλļ¼,ÿ˶Ӧÿְλ,ظӦƸ

   id  mediumint(7)       auto_increment   	ԶֵID,岻           
   cid  mediumint(7)     0                	Ӧְλqb_hr_contentеID
   uid  mediumint(7)     0                	ӦƸߵUID
   join_id  mediumint(7)     0                ӦƸ߼qb_hr_joinеID
   posttime  int(10)     0               	ӦƸ

qb_hr_city	ݱ
   fid  mediumint(7)  UNSIGNED     auto_increment     ID      
   fup  mediumint(7)  UNSIGNED   0      		ʱûʹ
   name  varchar(200)                     		
   class  smallint(4)     0                		ʱûʹ
   sons  smallint(4)     0                		ʱûʹ
   type  tinyint(1)     0                		ʱûʹ
   admin  varchar(100)                     		ʱûʹ
   list  int(10)     0                		ֵ
   listorder  tinyint(2)     0                	ʱûʹ
   passwd  varchar(32)                     		ʱûʹ
   logo  varchar(150)                     		ʱûʹ
   descrip  text                     			ʱûʹ
   style  varchar(50)                     		ʱûʹ
   template  text                     		ʱûʹ
   jumpurl  varchar(150)                     		ʱûʹ
   maxperpage  tinyint(3)     0                	ʱûʹ
   metakeywords  varchar(255)                     	ʱûʹ
   metadescription  varchar(255)                     	ʱûʹ
   allowcomment  tinyint(1)     0                	ʱûʹ
   allowpost  varchar(150)                     	ʱûʹ
   allowviewtitle  varchar(150)                     	ʱûʹ
   allowviewcontent  varchar(150)                     ʱûʹ
   allowdownload  varchar(150)                     	ʱûʹ
   forbidshow  tinyint(1)     0                	ʱûʹ
   config  text                    			ʱûʹ


qb_hr_collection	ҵ¼˲ſ
   id  mediumint(7)       auto_increment     		ԶֵID,岻         
   memberuid  mediumint(7)     0          		ְߵUID      
   companyuid  mediumint(7)     0             	ҵUID   
   posttime  int(10)     0              		¼ 


qb_hr_person		ӦƸߵļ,ÿֻдһ
   id  mediumint(7)       auto_increment              ԶֵID,ܻõ,ΪΨһ,ῼο͵  
   mid  smallint(4)     0                		ģIDǿΪ2
   hits  mediumint(7)     0                		ע
   posttime  int(10)     0                		Ǽ
   uid  mediumint(7)     0                		ӦƸUID
   username  varchar(30)                     		ӦƸߵʺ
   yz  tinyint(1)     0                		,1Ϊ,0Ϊ
   levels  tinyint(1)     0                		Ƽ,1ΪƼ,0ΪƼ
   levelstime  int(10)     0                		Ƽ
   ip  varchar(15)                     		ԴIP
   city_id  mediumint(7)     0       			ڳ


qb_hr_content_2		ӦƸߵļ,ÿֻдһ
   rid  mediumint(7)       auto_increment             ԶֵID,岻
   id  mediumint(7)     0                		ID
   uid  mediumint(7)     0                		ӦƸߵUID
   speciality  varchar(50)                     	רҵ
   age  tinyint(2)     0                		
   sex  tinyint(1)     0                		Ա
   truename  varchar(20)                     		
   height  int(4)     0                		
   school_age  tinyint(3)     0                	ѧ
   alma_mater  varchar(30)                     	ҵѧУ
   graduate_time  varchar(10)             		ҵ        
   mobphone  varchar(11)                     		ֻ
   qq  varchar(11)                   			QQ  
   email  varchar(50)                     		
   msn  varchar(50)                     		MSNʺ
   education  mediumtext                     		
   work  mediumtext                     		
   introduce  mediumtext                     		
   skill  mediumtext                     		س
   interest  mediumtext                     		
   lifeplace  varchar(50)                     	
   workyear  tinyint(2)     0                		
   worktime  varchar(20)                     		
   hope_job  varchar(200)                     	ְλ
   facephoto  varchar(100)                     	ͷ
   wage  tinyint(2)     0               		
	

qb_hr_content	ҵְλ
   id  int(10)       auto_increment    		ְλԶֵID          
   title  varchar(100)                     		ְλ
   mid  smallint(4)     0                		ģIDǿΪ1
   fid  mediumint(7)     0                		ְλFID
   fname  varchar(50)                     		ְλ
   hits  mediumint(7)     0                		ע
   comments  mediumint(7)     0                	ʱûʹ
   posttime  int(10)     0                		
   list  varchar(10)                     		ֵ
   uid  mediumint(7)     0                		UID
   username  varchar(30)                     		ʺ
   picurl  varchar(150)                     		ʱûʹ
   ispic  tinyint(1)     0                		ʱûʹ
   yz  tinyint(1)     0                		
   yzer  varchar(30)                     		ʱûʹ
   yztime  int(10)     0                		ʱûʹ
   levels  tinyint(2)     0                		ǷƼ,1ΪƼ,0ΪƼ
   levelstime  int(10)     0                		Ƽ
   keywords  varchar(100)                     	ʱûʹ
   ip  varchar(15)                     		ߵIP
   lastfid  mediumint(7)     0                	ʱûʹ
   editer  varchar(30)                     		ʱûʹ
   edittime  int(10)     0                		ʱûʹ
   begintime  int(10)     0                		ʱûʹ
   endtime  int(10)     0                		ʱûʹ
   lastview  int(10)     0                		ʱûʹ
   city_id  mediumint(7)     0    			

qb_hr_content_1 	ҵְλ          
   rid  mediumint(7)       auto_increment             ԶֵID,岻 
   id  int(10)     0                			ID
   fid  mediumint(7)     0                		Ŀ
   uid  mediumint(7)     0                		ߵUID
   content  mediumtext                     		ְλ
   nums  int(5)     0                			Ƹ
   wageyear  tinyint(1)     0                		Ҫ
   asksex  tinyint(1)     0                		ԱҪ
   schoo_age  tinyint(2)     0                	ѧҪ
   wage  tinyint(2)     0                		нˮ
   workplace  varchar(50)                    		
 



qb_brand_module	ģͱ

   id  smallint(4)       auto_increment         	ԶֵģID,ܶطҪõ     
   sort_id  mediumint(5)     0                	ʱûʹ
   name  varchar(50)                     		ģ
   list  smallint(4)     0                		ֵ
   style  varchar(50)                     		ʱûõ
   config  text                     			չֶ1
   config2  text                     			չֶ2,ʱûõ
   comment_type  tinyint(1)     0                	ʱûõ
   ifdp  tinyint(1)     0                		ʱûõ
   template  text                    			ָĸģ


qb_brand_field	ģֶϢ

   id  mediumint(7)       auto_increment      	ԶֵID,岻      
   mid  mediumint(5)     0                		ӦID
   title  varchar(50)                     		ֶ
   field_name  varchar(30)                     	ֶ,MSYQLʹõֶ
   field_type  varchar(15)                     	ֶ,ͻַ
   field_leng  smallint(3)     0                	ֶγ
   orderlist  int(10)     0                		ֵ
   form_type  varchar(15)                     	
   field_inputwidth  smallint(3)     NULL             
   field_inputheight  smallint(3)     0               ĸ߶
   form_set  text                     		,ѡ,ѡĲ
   form_value  text                     		Ĭֵ
   form_units  varchar(30)                     	ʾĵλ
   form_title  text                     		ʾı
   mustfill  tinyint(1)     0                		ǷΪ
   listshow  tinyint(1)     0                		Ƿбʾ
   listfilter  tinyint(1)     NULL                	Ƿбɸѡ
   search  tinyint(1)     0                		ǷΪֶ
   allowview  varchar(255)                     	鿴ֶεû
   allowpost  varchar(255)                     	ֶݵû
   js_check  text                     		JSЧǷϷ
   js_checkmsg  varchar(255)                     	JSЧʾϢ
   classid  mediumint(7)     0                	ֶչʹ
   form_js  text                    			JSչʹ






qb_brand_sort    

   fid  mediumint(7)  UNSIGNED     auto_increment    	ID
   fup  mediumint(7)  UNSIGNED   0                   	ʱûʹ
   name  varchar(50)                     		
   mid  smallint(4)     0                		ʱûʹ
   class  smallint(4)     0                		ʱûʹ
   sons  smallint(4)     0                		ʱûʹ
   type  tinyint(1)     0                		ʱûʹ
   admin  varchar(100)                     		ʱûʹ
   list  int(10)     0                		ֵ
   listorder  tinyint(2)     0                	ʱûʹ
   passwd  varchar(32)                     		ʱûʹ
   logo  varchar(150)                     		ʱûʹ
   descrip  text                     			ʱûʹ
   style  varchar(50)                     		ʱûʹ
   template  text                     		ʱûʹ
   jumpurl  varchar(150)                     		תⲿַ
   maxperpage  tinyint(3)     0                	ʱûʹ
   metatitle  varchar(250)                     	ʱûʹ
   metakeywords  varchar(255)                     	ʱûʹ
   metadescription  varchar(255)                     	ʱûʹ
   allowcomment  tinyint(1)     0                	ʱûʹ
   allowpost  varchar(150)                     	ʱûʹ
   allowviewtitle  varchar(150)                     	ʱûʹ
   allowviewcontent  varchar(150)                     ʱûʹ
   allowdownload  varchar(150)                     	ʱûʹ
   forbidshow  tinyint(1)     0                	ʱûʹ
   config  mediumtext                     		ʱûʹ
   index_show  tinyint(1)     0                	ʱûʹ
   contents  mediumint(4)     0                	ʱûʹ
   tableid  varchar(30)                     		ʱûʹ
   dir_name  varchar(50)                     		ʱûʹ
   ifcolor  tinyint(1)     0               		ʱûʹ        


