Columns |
Name | Datatype | Null |
lineid | numeric(6,0) | No |
obsno | int | No |
type | char(1) | Yes |
wl | decimal(9,5) | No |
freq | decimal(12,5) | No |
wn | decimal(11,5) | No |
abs_em | char(3) | No |
linewidth | decimal(12,5) | Yes |
linewidth_unit | char(16) | Yes |
resolving_power | decimal(10,2) | Yes |
aperture | varchar(32) | Yes |
flux | real | Yes |
flux_unit | char(16) | Yes |
flux_density | real | Yes |
flux_density_unit | char(16) | Yes |
sn | decimal(10,3) | Yes |
peak_intensity | real | Yes |
peak_intensity_unit | char(16) | Yes |
line_to_continuum_ratio | decimal(9,3) | Yes |
opacity | decimal(9,3) | Yes |
gas_solid | char(5) | Yes |
detection_flag | char(1) | Yes |
identification | char(32) | Yes |
transition | char(32) | Yes |
ads_code | char(19) | No |
comments | char(255) | Yes |
Table Usage (MB) |
Distribution of Table Space |
Data |
0.23 |
Data |
69.64 % |
Indexes |
0.07 |
Indexes |
20.83 % |
Unused |
0.03 |
Unused |
9.52 % |
Total |
0.33 |
Number
of Rows |
1044 |
Dependencies |
Referencing Objects |
Object Name | Object Type |
dbo.iasd_line.line_pk | INDEX |
dbo.iasd_line.line_obsno_ix | INDEX |
dbo.iasd_line.line_ix | INDEX |
Referenced Objects |
Object Name | Object Type |
DDL |
CREATE TABLE dbo.iasd_line ( lineid numeric(6,0) IDENTITY, obsno int NOT NULL, type char(1) NULL, wl decimal(9,5) NOT NULL, freq decimal(12,5) NOT NULL, wn decimal(11,5) NOT NULL, abs_em char(3) NOT NULL, linewidth decimal(12,5) NULL, linewidth_unit char(16) NULL, resolving_power decimal(10,2) NULL, aperture varchar(32) NULL, flux real NULL, flux_unit char(16) NULL, flux_density real NULL, flux_density_unit char(16) NULL, sn decimal(10,3) NULL, peak_intensity real NULL, peak_intensity_unit char(16) NULL, line_to_continuum_ratio decimal(9,3) NULL, opacity decimal(9,3) NULL, gas_solid char(5) NULL, detection_flag char(1) NULL, identification char(32) NULL, transition char(32) NULL, ads_code char(19) NOT NULL, comments char(255) NULL ) LOCK ALLPAGES go