Schema |
An IJC Schema is a collection of Entities and Data Trees that are defined for a database connection. As such it reflects all the database tables and related artifacts available from the database connection. |
Data Tree |
A Data Tree in IJC provides a hierarchical representation of relational data, allowing master detail data to be represented. Views belong to a Data Tree , and display the data represented by it. You can create multiple Views for a Data Tree , and these Views will be coordinated in terms of data and selection. When a query is performed, it is applied to the contents of the Data Tree. |
View |
A View in IJC offers a visual representation of data. For example, IJC currently supports two view types: the Grid View , which emphasizes data display from a single database table, and the Form View , which allows more complex reports to be built, including those for master-detail data. |
Grid View |
The Grid View provides a tabular (or spreadsheet like) view of data. It is the simplest View of data provided in Instant JChem. In comparison, the Form View provides a more sophisticated way to view data. |
Form View |
The Form View allows you to design a form which you can use to view and analyse your data. In comparison to the Grid View , it provides a more sophisticated way to view your data and allows you to use relational data. |
Widget |
A Widget is a component of the Form View. It occupies a rectangular region of the form and is responsible for displaying its data in a manner particular to the Widget. |
Entity |
An Entity represents a set of data that can be represented as a set of rows and columns. In the simplest case, it represents a database table, but more complex arrangements are also possible. |
Relationship |
A Relationship represents an assocation between rows in 2 Entities. For each row in one Entity there will be one or more associated rows in the other Entity. The type of Relationship provides a restriction on the number of associated rows. |
Fields |
Fields represent the columns of the row/column paradigm of an IJC Entity. Typically a field represents a column from a database table, though more complex arrangements are also possible. Some fields have values that are editable whilst other types have their values automatically generated. |
Schema Editor |
The Schema Editor allows you to manage all table Entities existing under a selected database connection. From the Schema Editor , you can view settings for tables as well as individual Fields. You can also edit tables and Fields , such as by adding or deleting, renaming or customizing. The Schema Editor can be accessed by choosing Edit Schema from the right-click menu of a connection node ( or ) in the Projects Window. |