forked from xraypy/XrayDB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
xraydb.schema
33 lines (33 loc) · 1.88 KB
/
xraydb.schema
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
CREATE TABLE elements (atomic_number integer primary key,
element text, molar_mass real, density real);
CREATE TABLE xray_levels (id integer primary key, element text,
iupac_symbol text, absorption_edge real, fluorescence_yield real,
jump_ratio real);
CREATE TABLE xray_transitions (id integer primary key, element text,
iupac_symbol text, siegbahn_symbol text, initial_level text,
final_level text, emission_energy real, intensity real);
CREATE TABLE Coster_Kronig (id integer primary key, element text,
initial_level text, final_level text,
transition_probability real, total_transition_probability real);
CREATE TABLE photoabsorption (id integer primary key, element text,
log_energy text, log_photoabsorption text,
log_photoabsorption_spline text);
CREATE TABLE scattering (id integer primary key, element text,
log_energy text,
log_coherent_scatter text, log_coherent_scatter_spline text,
log_incoherent_scatter text, log_incoherent_scatter_spline text);
CREATE TABLE Waasmaier (id integer primary key,
atomic_number integer, element text, ion text,
offset real, scale text, exponents text);
CREATE TABLE KeskiRahkonen_Krause (id integer primary key,
atomic_number integer, element text, edge text, width float);
CREATE TABLE Krause_Oliver (id integer primary key,
atomic_number integer, element text, edge text, width float);
CREATE TABLE corelevel_widths (id integer primary key,
atomic_number integer, element text, edge text, width float);
CREATE TABLE Chantler (id integer primary key,
element text, sigma_mu real, mue_f2 real, density real,
corr_henke float, corr_cl35 float, corr_nucl float,
energy text, f1 text, f2 text, mu_photo text,
mu_incoh text, mu_total text);
CREATE TABLE Version (id integer primary key, tag text, date text, notes text);