FS_VERSIONS_LATEST
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| VERSION_ID | NUMBER(38) | N | YES | YES | YES | |
| FILE_ID | NUMBER(38) | N | YES | YES | YES | |
| VERSION_CONTENT | BLOB | Y | YES | YES | YES | |
| VERSION_DESCRIPTION | VARCHAR2(500.0) | Y | YES | YES | YES | |
| CREATION_DATE | DATE | N | YES | YES | YES | |
| AUTHOR_ID | NUMBER(38) | N | YES | YES | YES | |
| CLIENT_FILE_NAME | VARCHAR2(500.0) | Y | YES | YES | YES | |
| FILE_TYPE | VARCHAR2(100.0) | Y | YES | YES | YES | |
| FILE_EXTENSION | VARCHAR2(50.0) | Y | YES | YES | YES | |
| SUPERSEDED_BY_ID | NUMBER(38) | Y | YES | YES | YES | |
| N_BYTES | NUMBER(38) | Y | YES | YES | YES | |
| URL | VARCHAR2(200.0) | Y | YES | YES | YES | |
Query:
select "VERSION_ID","FILE_ID","VERSION_CONTENT","VERSION_DESCRIPTION","CREATION_DATE","AUTHOR_ID","CLIENT_FILE_NAME","FILE_TYPE","FILE_EXTENSION","SUPERSEDED_BY_ID","N_BYTES","URL" from fs_versions where superseded_by_id is null
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002