xan [xan_PRISM_DW.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

collection

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	row_id	Integer			nextval('collection_row_id_seq'::regclass)
	row_entry_date	TimeStampWithTimeZone			now()
	row_update_date	TimeStampWithTimeZone			now()
	type_id	Integer
	short_name	VarChar(100)
	long_name	VarChar(200)
	description	VarChar(1000)
	fixed_date	TimeStamp
	min_date	TimeStamp
	max_date	TimeStamp
	fixed_lon	Double
	min_lon	Double
	max_lon	Double
	fixed_lat	Double
	min_lat	Double
	max_lat	Double
	fixed_z	Double
	min_z	Double
	max_z	Double
	qualifier	VarChar(20)
	platform_id	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
collection_type_id_fkey	core.collection_type	core.collection	row_id	type_id
platform_id_fkey	core.platform	core.collection	row_id	platform_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
collection_id_fkey	core.collection	core.collection_group	row_id	collection_id
spat_coll_id_fkey	core.collection	core.collection_group	row_id	spat_coll_id
time_coll_id_fkey	core.collection	core.collection_group	row_id	time_coll_id
multi_obs_collection_id_fkey	core.collection	core.multi_obs	row_id	collection_id

Used in Diagrams

Diagram Name

core