Project

General

Profile

DocDB_tables.txt

Kyle Hazelwood, 01/15/2015 12:00 PM

 
1
pa1850 DB tables:
2
changed names, straight copies by 7/26/11
3
	rr_ob_pgmpar -> pa4196_pgmpar
4
	rr_c453_config -> pa4196_c453_config
5
	rr_hi_hdr1 -> pa4196_hi_hdr
6
		table_num	- H table # 
7
		plane       
8
		date       
9
		title
10
		----------- ----------- ----------- --------------------------------
11
           1           0   977327362 test save
12
           1           0   977327622 test save
13
		   ......
14
			2           0  1060547432 with QCLP in QCLP mode
15
			2           1  1038854250 Copied from H table 17135708
16
			2           1  1038940346 Copied from H table 17135708
17
			2           1  1045916012 Copied from H table 2?
18

    
19
		  
20
	rr_hi_data1 -> pa4196_hi_data
21
		pkey 	- date in hi_hdr record
22
        id		- 0,1,2,4(first one always for 8.9 GeV,last one for 169 GeV)
23
		energy  - Not beam energy but MI bending magnets' current in AMPS             
24
		R1, ....., R104	- correction currents for trims
25

    
26
		
27
	rr_ob_dc -> not used, DC code cleared.
28
	rr_bpm_data -> pa4196_bpm_data
29
	
30
		create table pa4196_bpm_data (
31
		name		char(8)		not null,
32
		plane		int		not null,
33
		fid			int		not null,
34
		date		int		not null,
35
		title		char(20),
36
		stat		binary(215),
37
		F1  real,	F2 real,  	F3 real,  	F4 real,  .... 	F215 real  
38
		name: 	bpmdeso (desire orbit for normal correction)
39
				bpmdesh ('desire' orbit for compensation, adjust H table)
40

    
41
	rr_ced_data -> pa4196_ced_data
42

    
43
		create table pa4196_ced_data (
44
		name		char(8)		not null,
45
		plane		int		not null,
46
		fid			int		not null,
47
		date		int		not null,
48
		title		char(32),
49
		stat		binary(120),
50
		S1  real,   S2 real,  	S3 real,  	S4 real, ......, S120 real  
51

    
52
		names: 	cedamps(saved trim settings,many records)
53
				cedlimh(trim limits used for H tables for compensations,h/v,a few recods, default 1)
54
					get_cons1,get_deso2,get_limi2.... 
55
				cedlimi(trim limits,h/v,a few recods, default 1)
56
				cedstr(trim strength,h/v,in uRad/amps)
57

    
58
	mi_la_data
59
	mi_la_dir