xan [xan_PRISM_DW.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

platform

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	row_id	Integer			nextval('platform_row_id_seq'::regclass)
	row_entry_date	TimeStampWithTimeZone			now()
	row_update_date	TimeStampWithTimeZone			now()
	organization_id	Integer
	type_id	Integer
	short_name	VarChar(50)
	platform_handle	VarChar(100)
	fixed_lon	Double
	fixed_lat	Double
	active	Boolean
	begin_date	TimeStamp
	end_date	TimeStamp
	project_id	Integer
	long_name	VarChar(200)
	description	VarChar(1000)
	url	VarChar(200)
	obs_freq_type	VarChar(50)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
platform_organization_id_fkey	core.organization	core.platform	row_id	organization_id
platform_project_id_fkey	core.project	core.platform	row_id	project_id
platform_type_id_fkey	core.platform_type	core.platform	row_id	type_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
platform_id_fkey	core.platform	core.collection	row_id	platform_id
sensor_platform_id_fkey	core.platform	core.sensor	row_id	platform_id

Used in Diagrams

Diagram Name

core