SchemaSpy - Table istsos.demo.event

Stores Observation's eventTime.

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id_eti

bigserial

√

nextval('demo.event_time_id_eti_seq'::regclass)

measures.id_eti_fk	measures_id_eti_fk_fkey C
positions.id_eti_fk	positions_id_eti_fk_fkey C

id_prc_fk

int4

procedures.id_prc

event_time_id_prc_fk_fkey C

time_eti

timestamptz

35,6

Table contained 1,866 rows at Mon Jul 13 17:15 CEST 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
id_eti	Primary key	Asc	event_time_pkey
id_eti + time_eti	Performance	Asc/Asc	ety_prc_date
id_prc_fk + time_eti	Must be unique	Asc/Asc	event_time_id_prc_fk_key