||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.
||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.
||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.
||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.
||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.
||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.
||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.
||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 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.
||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.