|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| ROOT_MSG_ID | VARCHAR2(18.0) | Y | NO | NO | NO | |
| TOPIC_ID | NUMBER(38) | N | YES | YES | YES | |
| POSTING_TIME | DATE | Y | YES | YES | YES |
select substr(sort_key,1,6) as root_msg_id, topic_id, posting_time from bboard where refers_to is not null