Primary Table Example
Primary tables define the documents in a primary/detail relationship. Assign an identifying number to each document. The following table is an example primary table, called my_primary:
| Column Name | Column Type | Description |
|---|---|---|
article_id |
NUMBER |
Document ID, unique for each document (primary key) |
author |
VARCHAR2(30) |
Author of document |
title |
VARCHAR2(50) |
Title of document |
body |
CHAR(1) |
Dummy column to specify in CREATE INDEX |
Note: Your primary table must include a primary key column when you use the DETAIL_DATASTORE type.