COMMENTS_NOT_DELETED
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| COMMENT_ID | NUMBER(38) | N | YES | YES | YES | |
| PAGE_ID | NUMBER(38) | N | YES | YES | YES | |
| USER_ID | NUMBER(38) | N | YES | YES | YES | |
| COMMENT_TYPE | VARCHAR2(30.0) | Y | YES | YES | YES | |
| MESSAGE | CLOB | Y | YES | YES | YES | |
| HTML_P | CHAR(1.0) | Y | YES | YES | YES | |
| RATING | NUMBER(38) | Y | YES | YES | YES | |
| ORIGINATING_IP | VARCHAR2(50.0) | Y | YES | YES | YES | |
| POSTING_TIME | DATE | Y | YES | YES | YES | |
| DELETED_P | CHAR(1.0) | Y | YES | YES | YES | |
| ATTACHMENT | BLOB | Y | 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 | |
| CAPTION | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| ORIGINAL_WIDTH | NUMBER(38) | Y | YES | YES | YES | |
| ORIGINAL_HEIGHT | NUMBER(38) | Y | YES | YES | YES | |
Query:
select "COMMENT_ID","PAGE_ID","USER_ID","COMMENT_TYPE","MESSAGE","HTML_P","RATING","ORIGINATING_IP","POSTING_TIME","DELETED_P","ATTACHMENT","CLIENT_FILE_NAME","FILE_TYPE","FILE_EXTENSION","CAPTION","ORIGINAL_WIDTH","ORIGINAL_HEIGHT"
from comments
where deleted_p is null
or deleted_p = 'f'
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002