Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/DesignDocs/283430"
< EclipseLink | DesignDocs
(→API) |
(→Config files) |
||
| Line 49: | Line 49: | ||
* orm.xml | * orm.xml | ||
<source lang="xml"> | <source lang="xml"> | ||
| − | <index name="EMP_NAME" unique="true"> | + | <index name="EMP_NAME" table="EMPLOYEE" unique="true"> |
<column name="F_NAME"/> | <column name="F_NAME"/> | ||
<column name="L_NAME"/> | <column name="L_NAME"/> | ||
Revision as of 16:06, 25 August 2010
Design Specification: Indexes
Document History
| Date | Author | Version Description & Notes |
|---|---|---|
| 2010-08-25 | James | 0.1 Draft |
Project overview
Concepts
Requirements
Design Constraints
Functionality
Testing
Define indexes for some test schemas. Need to test on all databases.
API
- Index
- @Index(name, table, unique, columns[])
- @Indexes
Config files
- orm.xml
<index name="EMP_NAME" table="EMPLOYEE" unique="true"> <column name="F_NAME"/> <column name="L_NAME"/> </index>
Documentation
Should be documented under extended annotations, and schema generation.
Open Issues
| Issue # | Owner | Description / Notes |
|---|---|---|
| 1 | What databases support indexes, do any use a different syntax? |
Decisions
| Issue # | Description / Notes | Decision |
|---|
Future Considerations
- Other DDL options.