Improve AD_Index; AD_View; foreign keys management

Description

  • Add 2 tabs to the Table and Column window: One for index definition and one for view definition

  • Index definition should be available for all tables except IsView=Y

  • View definition should only be available if IsView=Y

  • Create a process to create database index and view from the definition above

  • When it's a unique index, allow user to select an error message from AD_Message (The idea is we can perform unique validation in the future and able to show context sensitive error message)

Environment

None

Assignee

Elaine Tan

Reporter

Elaine Tan

Labels

None

Tested By

None

Components

Fix versions

Priority

Major
Configure