observation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obs_key serial 10 √ nextval('observation_obs_key_seq'::regclass)
field_observation.obs_key field_observation_obs_key_fkey C
dataproduct_type varchar 16 √ null
assoc_idx int4 10 √ null
calib_level int4 10 √ null
obs_collection varchar 16 √ null
obs_id varchar 16 √ null
target varchar 32 √ null
ra float8 17,17 √ null
dec float8 17,17 √ null
t_min float8 17,17 √ null
t_max float8 17,17 √ null
exptime float8 17,17 √ null
wavelength_region varchar 16 √ null
filter varchar 16 √ null
em_min float8 17,17 √ null
em_max float8 17,17 √ null
target_classification varchar 255 √ null
obs_title varchar 255 √ null
t_obs_release float8 17,17 √ null
instrument_name varchar 32 √ null
proposal_pi varchar 255 √ null
proposal_id varchar 8 √ null
proposal_type varchar 16 √ null
project varchar 16 √ null
sequence_number int4 10 √ null
footprint varchar 1024 √ null
jpegurl varchar 36 √ null
dataurl varchar 36 √ null
datarights varchar 16 √ null
mtflag int4 10 √ null
srcden float8 17,17 √ null
intenttype varchar 16 √ null
obsid varchar 16 √ null
objid varchar 16 √ null
objid1 varchar 16 √ null
distance float8 17,17 √ null
visit varchar 4 √ null
area float8 17,17 √ null

Indexes

Constraint Name Type Sort Column(s)
observation_pkey Primary key Asc obs_key

Relationships

Close relationships within degrees of separation