xan [xan_PRISM_DW.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sensor

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	row_id	Integer			nextval('sensor_row_id_seq'::regclass)
	row_entry_date	TimeStampWithTimeZone			now()
	row_update_date	TimeStampWithTimeZone			now()
	platform_id	Integer
	type_id	Integer
	short_name	VarChar(50)
	m_type_id	Integer
	fixed_z	Double
	active	Boolean
	begin_date	TimeStamp
	end_date	TimeStamp
	s_order	Integer			1
	url	VarChar(200)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
sensor_m_type_id_fkey	core.m_type	core.sensor	row_id	m_type_id
sensor_platform_id_fkey	core.platform	core.sensor	row_id	platform_id
sensor_type_id_fkey	core.sensor_type	core.sensor	row_id	type_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
multi_obs_sensor_id_fkey	core.sensor	core.multi_obs	row_id	sensor_id

Used in Diagrams

Diagram Name

core