SysTax - a Database System for Systematics and Taxonomy
SysTax - a Database System for Systematics and Taxonomy
REV_DRUCKLISTEprint stock of data for revision labels of a collection |
constraints | ||
| primary key | |||
| indexes | |||
| roles | LESEN_BG (DELETE, INSERT, SELECT, UPDATE) LESEN_HERB (DELETE, INSERT, SELECT, UPDATE) WWW (SELECT) | ||
| columns | properties | ||
| PFLID | NUMBER(22) NN | ID of botanical potential taxon (points to taxon.pflid) | |
| STUFE | VARCHAR2(1) NN | rank of botanical potential taxon (values: 'S', 'C', 'A', 'G', 'F', 'O', 'K', 'B') | |
| USERID | NUMBER(22) NN | ID of user (points to user_lst.userid) | |
| HERBID | NUMBER(22) NN | ID of specimen (points to herb2.herbid) | |
| BESTIM | VARCHAR2(50) | name of determinator (points to bestim.bestim) | |
| GUELTIG | VARCHAR2(1) | '*' if determination is valid | |
| DETID | NUMBER(22) | ID of kind of determination (e.g. 'det.', 'rev.', 'conf.' etc.) (points to det.detid) | |
| DATUM | VARCHAR2(10) | date of revision | |
| TEXT | VARCHAR2(256) | text of additional remark on determination | |
| ZUSID | NUMBER(22) | ID of annex concerning quality of destination of an accession of a botanical garden or collection (points to zusatz.zusid) | |
20.05.2013