Dumped on 2004-09-08

Index of database - jstock

public

events
exchange
indicator
indicatorparameters
lines
notes
panels
tickers
watchlist

Table: events

events Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	serial	NOT NULL
	eventshort	character varying(5)
	event	character varying(20)

Permissions which apply to events
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: exchange

exchange Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	serial	NOT NULL
	exchangename	character varying(20)	NOT NULL

Permissions which apply to exchange
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: indicator

indicator Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	integer	NOT NULL
	indicator	character varying(31)	UNIQUE NOT NULL

Permissions which apply to indicator
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: indicatorparameters

indicatorparameters Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	integer	NOT NULL
	tickerid	integer
	indicatorid	integer	NOT NULL
	parameternumber	smallint
	parametervalue	character varying(63)
	panelid	smallint

Permissions which apply to indicatorparameters
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: lines

lines Structure
F-Key	Name	Type	Description
	index	integer
	tickerid	integer
	datex1	character(8)
	valuey1	double precision
	datex2	character(8)
	valuey2	double precision
	indicatorid	integer
	panelid	smallint

Permissions which apply to lines
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: notes

notes Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	serial	NOT NULL
	tickerid	integer
	note	text

Permissions which apply to notes
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: panels

panels Structure
F-Key	Name	Type	Description
	"index"		PRIMARY KEY
	index	smallint	NOT NULL
	panelname	character varying(63)

Permissions which apply to panels
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
kaare	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: tickers

tickers Structure
F-Key	Name	Type	Description
	index	integer
	exchangeid	integer
	ticker	character varying(15)

Permissions which apply to tickers
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: watchlist

watchlist Structure
F-Key	Name	Type	Description
	tickerid	integer	PRIMARY KEY

Permissions which apply to watchlist
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
jstock	♦	♦	♦	♦	♦
postgres	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict