Detail Table Example
Detail tables contain the text for a document, whose content is usually stored across a number of rows.
The following detail table my_detail is related to the primary table my_primary with the article_id column. This column identifies the primary document to which each detail row (sub-document) belongs.
| Column Name | Column Type | Description |
|---|---|---|
article_id |
NUMBER |
Document ID that relates to primary table |
seq |
NUMBER |
Sequence of document in the primary document defined by article_id |
text |
VARCHAR2 |
Document text |