| 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