Documentation for database : BiblioDB

Table : annotations

Name	Type	Description
Field Summary
id	Serial
user_id	users(id)
content	text

Name	Type	PrKey	Unq	NotN	MUnq	Def	Idx1
Sql Summary
id	int
user_id	int
content	varchar(32,000)

Field	Import	On Update	On Delete
Foreign Keys
user_id	users(id)	NO ACTION	NO ACTION

Sql Commands

INSERT INTO identifier_types VALUES (1, 'isbn');
INSERT INTO identifier_types VALUES (2, 'doi');
INSERT INTO identifier_types VALUES (3, 'sici');
INSERT INTO identifier_types VALUES (4, 'lccn');
INSERT INTO identifier_types VALUES (5, 'pmid');

INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS

INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS