INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
DATATYPES | SQL SUMMARY | TRIGGERS |
Table : annotations |
Field Summary | ||
Name | Type | Description |
---|---|---|
id | Serial | |
user_id | users(id) | |
content | text |
Sql Summary | |||||||
Name | Type | PrKey | Unq | NotN | MUnq | Def | Idx1 |
---|---|---|---|---|---|---|---|
id | int | ||||||
user_id | int | ||||||
content | varchar(32,000) |
Foreign Keys | |||
Field | Import | On Update | On Delete |
---|---|---|---|
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 |