SysTax - a Database System for Systematics and Taxonomy
SysTax - a Database System for Systematics and Taxonomy
OBJEKTmultimedial objects |
constraints | ||
| primary key | PK_OBJEKT | ||
| indexes | OBJEKT_OBJID (OBJID) OBJEKT_OBJARTID (OBJARTID) | ||
| roles | BIG (SELECT) INS_INFO (DELETE, INSERT, UPDATE) LESEN_INFO (SELECT) WWW (SELECT) | ||
| columns | properties | ||
| URLID | NUMBER(22) | source of object (ID of url) | |
| OBJSIZE | NUMBER(22) | size of object in bytes | |
| OBJID | NUMBER(22) NN | ID of object (points to textobj.objid, oleobj.objid, soundobj.objid, objmov.objid, imgobj.objid, img_thumb.objid) | |
| OBJARTID | NUMBER(22) NN | ID of kind of object (points to objart.objartid) | |
| FILENAME | VARCHAR2(256) | original filename of object on client side | |
| MIMETYPE | VARCHAR2(100) | mime type of object | |
| BEM | VARCHAR2(512) | short comment on object | |
| COPYRIGHT | VARCHAR2(128) | copyright | |
| PERID | NUMBER(22) | source of object (ID of person) | |
| INSTID | NUMBER(22) | source of object (ID of institute) | |
| LIT2ID | NUMBER(22) | source of object (ID of literature) | |
| ASEITE | NUMBER(22) | first page in literature | |
| ESEITE | NUMBER(22) | last page in literature | |
| ABB | VARCHAR2(64) | auxiliary pages in literature | |
| HERBID | NUMBER(22) | source of object (ID of specimen) | |
| OWNERID | NUMBER(22) | userid of owner of data set | |
| READ_REID | NUMBER(22) | reading permissions | |
| UPD_REID | NUMBER(22) | writing permissions | |
| CREATORID | NUMBER(22) | userid of creator of data set | |
| CREATEDATUM | CHAR(10) | date of creation of data set | |
| MODUSERID | NUMBER(22) | userid of last editor | |
| MODDATUM | CHAR(10) | date of last modification of data set | |
| EXTFILENAME | VARCHAR2(30) | filename of object on server side | |
| TITLE | VARCHAR2(350) | title of object | |
| DESCR | VARCHAR2(512) | short description of object | |
| HERBUPD | CHAR(1) | '*': in neue Struktur überführt (über info anstelle herbid) | |
| OBJDATE | VARCHAR2(20) | date of object creation | |
| OBJTIME | VARCHAR2(20) | time of object creation | |
| AUTHOR | VARCHAR2(50) | author of object | |
| WWW_HIDE_ORIG | CHAR(1) | ||
| NOT_YET | CHAR(1) | ||
| PROJID | NUMBER(22) | ID of project the creator of this dataset was assinged to | |
20.06.2013