Contains a list of all files stored in the archive
with a version number, storage location on CD, size, file status, quality
info and file catagory for storing on CD. Note that the pdc table allows
NULL values for the observation number (obsno) column since this value
is set to NULL for shape-1 files (e.g. CALG files). Shape-2 files are linked
to the revolution, and are therefore attached (by default) to the LWS parallel
observation for that revolution. Note that postcards and survey products,
which are browse products (browse products are icons, postcards and survey
products), are also included in the pdc table (not like the icons which
are not included).
| Columns |
| Name | Datatype | Null |
| obsno | int | Yes |
| filename | char(13) | No |
| version | char(4) | No |
| size | int | Yes |
| opt_loc | varchar(40) | No |
| mag_loc | varchar(40) | No |
| category | char(2) | Yes |
| shape | tinyint | Yes |
| qual_status | char(1) | Yes |
| user_q | char(8) | Yes |
| qual_date | char(6) | Yes |
| dispatch | char(1) | Yes |
| file_status | char(5) | Yes |
| dist_status | char(1) | Yes |
| comment | varchar(80) | Yes |
column category
File category. The optical disk category for this product. 'EC', 'EL', 'EP', 'ES' for ERD for the four instruments, 'EX' for general ERD, e.g. GEHK and AOCS, 'XX' for everything else, e.g. SPD, AAR. Products which don't get archived onto CD, e.g. CALG files, have category 'ZZ'. `OX' meaning a higher processing levels than ERD. Note that the values in this column are not used anymore in the ISO Data Archive, they were taken over from the pdc table in the IPA database.column comment
Descriptive text. Mainly used to document each version of a CALG file. Probably NULL for other files.column dispatch
Dispatch flag. Some files should not be distributed to an observer. These will have this flag set to 'N', otherwise 'Y'.column dist_status.
Distribution status. 'Y' if distributed by Product Distribution System (PDS), 'N' if not, 'E' if error.column file_status
File status.column filename
FITS filename.column mag_loc
Magnetic disk array location.column obsno
Observation number constructed as follows:revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
Please see SCREW 385.column opt_loc
Primary optical disk location.column qual_date
Date quaility set. In yy/ddd format.column qual_status
Quality status of product.column shape
Product shape (1,2,3 or 4).column size
File size. Units: bytes.column user_q
Quality operator.column version
File version. The file version is calculated from the processing date by the formula:1932 + 372 * (year - 100) + 31*month + day
|
Table Usage (MB) |
Distribution of Table Space |
|
Data |
156.84 |
Data |
36.49 % |
|
Indexes |
267.74 |
Indexes |
62.28 % |
|
Unused |
5.30 |
Unused |
1.23 % |
|
Total |
429.88 |
Number
of Rows |
1669501 |
| Dependencies |
| Referencing Objects |
| Object Name | Object Type |
| dbo.pdc.pdc_ux | INDEX |
| dbo.pdc.pdc_ix1 | INDEX |
| dbo.pdc.pdc_ix2 | INDEX |
| dbo.pdc.pdc_ix3 | INDEX |
| dbo.pdc.pdc_filename | INDEX |
| Referenced Objects |
| Object Name | Object Type |
| DDL |
CREATE TABLE dbo.pdc
(
obsno int NULL,
filename char(13) NOT NULL,
version char(4) NOT NULL,
size int NULL,
opt_loc varchar(40) NOT NULL,
mag_loc varchar(40) NOT NULL,
category char(2) NULL,
shape tinyint NULL,
qual_status char(1) NULL,
user_q char(8) NULL,
qual_date char(6) NULL,
dispatch char(1) NULL,
file_status char(5) NULL,
dist_status char(1) NULL,
comment varchar(80) NULL
)
LOCK ALLPAGES
go