4 Defining Tables
This section contains information on the following topics.
- About Tables
The tables that store data in the Oracle Life Sciences Data Hub are Oracle tables with additional metadata developed especially for Oracle LSH. - Creating a Table
When you create a Table in a Work Area, you are actually creating an instance of a Table definition. - Setting and Modifying Table Attributes
When you create a new Table definition and/or Table instance, the system populates its attribute values. - Using the Table Properties Screen
If you are working in a Work Area, you see the properties of both the Table instance and the Table definition it references. If you are working directly on the definition in an Application Area or Domain, you see only the properties of the definition. - Defining Table Columns
To create a new Table Column: - Defining Table Constraints and Indexes
This section contains the following topics. - Modifying Tables
If you have the necessary privileges, you can modify a Table either through an instance of it in a Work Area or directly in the definition in its Domain or Application Area.