xan [xan_PRISM_DW.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

multi_obs

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	row_id	Integer			nextval('multi_obs_row_id_seq'::regclass)
	row_entry_date	TimeStampWithTimeZone			now()
	row_update_date	TimeStampWithTimeZone			now()
	platform_handle	VarChar(100)
	sensor_id	Integer
	m_type_id	Integer
	m_date	TimeStamp
	m_lon	Double
	m_lat	Double
	m_z	Double
	m_value	Double
	m_value_2	Double
	m_value_3	Double
	m_value_4	Double
	m_desc	VarChar(50)
	qc_level	Integer
	qc_flag	VarChar(100)
	collection_id	Integer

Indexes
Name	Table	Columns	Unique	Clustered
i_multi_obs_1	core.multi_obs	collection_id
i_multi_obs_2	core.multi_obs	sensor_id
i_multi_obs_3	core.multi_obs	m_date

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
multi_obs_collection_id_fkey	core.collection	core.multi_obs	row_id	collection_id
multi_obs_m_type_id_fkey	core.m_type	core.multi_obs	row_id	m_type_id
multi_obs_sensor_id_fkey	core.sensor	core.multi_obs	row_id	sensor_id

Parent Relations (none)

Used in Diagrams

Diagram Name

core