FS_VERSIONS_DENORM_VIEW
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| FILE_ID | NUMBER(38) | N | YES | YES | YES | |
| FILE_TITLE | VARCHAR2(500.0) | N | NO | NO | NO | |
| FOLDER_P | CHAR(1.0) | Y | NO | NO | NO | |
| OWNER_ID | NUMBER(38) | N | NO | NO | NO | |
| PUBLIC_P | CHAR(1.0) | Y | NO | NO | NO | |
| VERSION_ID | NUMBER(38) | N | YES | YES | YES | |
| VERSION_DESCRIPTION | VARCHAR2(500.0) | Y | YES | YES | YES | |
| CREATION_DATE | DATE | 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 | |
| N_BYTES | NUMBER(38) | Y | YES | YES | YES | |
| AUTHOR_ID | NUMBER(38) | N | YES | YES | YES | |
| AUTHOR_NAME | VARCHAR2(201.0) | Y | NO | NO | NO | |
| OWNER_NAME | VARCHAR2(201.0) | Y | NO | NO | NO | |
| DELETED_P | CHAR(1.0) | Y | NO | NO | NO | |
Query:
(
select
fs_versions.file_id,
file_title,
folder_p,
owner_id,
public_p,
fs_versions.version_id,
version_description,
creation_date,
client_file_name,
file_type,
file_extension,
n_bytes,
author_id,
author_user.first_names || ' ' || author_user.last_name as author_name,
owner_user.first_names || ' ' || owner_user.last_name as owner_name,
deleted_p
from
fs_versions,
fs_files,
users author_user,
users owner_user
where
fs_versions.author_id = author_user.user_id and
fs_files.owner_id = owner_user.user_id and
fs_versions.file_id = fs_files.file_id
)
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002