...
Examples
| Code Block |
|---|
|
select *
from mwa.obs_data_file |
...
Definition
Provides details of data files for a specific each observation.
| Column Name | Data Type | Description |
|---|
Type | Units | | col1 | desc1 | type1 | units1 |
col2 | desc2 | type2 | units2 |
|---|
| obs_id | BIGINT | Observation ID |
| filetype | INTEGER | Data file type |
| filetypedescription | VARCHAR | Data file type description |
| count | BIGINT | Count of all files of this type |
| size | BIGINT | Size of all files of this type in bytes |
| archived_count | BIGINT | Count of archived files of this type |
| archived_size | BIGINT | Size of archived files of this type in bytes (excluding deleted files) |
| deleted_count | BIGINT | Count of deleted files of this type |
| deleted_size | BIGINT | Size of deleted files of this type in bytes |
| modtime | TIMESTAMP | Last modification date time (AWST) |
note that the column named `count` is a reserved word in ADQL, so it must appear in quotes.