🗄️ 6. Data Model Basics
Sub-topic 6 of 9
67% Complete
The data model is the foundation of your Siebel application. It defines how information is structured, stored, and related.
Core Data Model Objects
1. Tables
Physical database tables that store data. Siebel table names typically start with S_
Examples:
S_ORG_EXT- Organization/Account dataS_CONTACT- Contact informationS_SRV_REQ- Service Request records
2. Columns
Fields within a table. Column naming conventions:
ROW_ID- Primary key (unique identifier)NAME- Common descriptor fieldPAR_ROW_ID- Foreign key to parent recordX_*- Custom extension columns
3. Indexes
Database indexes improve query performance. Siebel automatically creates indexes for:
- Primary keys (ROW_ID)
- Foreign keys (PAR_ROW_ID, etc.)
- Frequently searched columns
