From a PhixFlow Datasource, you can bring up a list of the tables in that database. The list show all the tables for the Datasource that the users defined in the datasource instances have permission to view.
For each table, you can bring up:
- the data in the table
- a list of the attributes defined in that table
Depending on where you call up the table list from, it will be either a simple list with only the name of each table, or a detailed list.
Detailed table list
In the detailed table list, the following fields are shown for each table:
HELPDEVTODO: confirm this in the new gui
| Field | Description |
|---|---|
| OWNER | The table owner |
| TABLENAME | The name of the table |
| TABLESPACENAME | That tablespace this table is contained in |
| NUMROWS | Approximate number of rows in this table. Note that this information is based on stats collected by the database, and in some cases may not be fully up-to-date. |
Table actions
You can do the following things from the table list:
- Show data in table - double-click on the table
- Bring up a simple list of the table attributes - select Show Table Attributes from the right-click menu
- Bring up a detailed list of the table attributes - select Show Attribute Details from the right-click menu
- Create a collector for the stream - HELPDEVTODO: drag doesn't currently work drag the table onto a model view, or select Create a Collector from the right-click menu
Forms: Table Attributes
A Table is a reference to an external database table object.
...
Table Attributes are the columns of an external Table.
| Anchor | ||||
|---|---|---|---|---|
|
There are two forms of the Table Attribute list:
- Detailed list - Shows the table attribute name plus other (database specific) details
- Simple list - Just shows the table attribute names
In both cases the lists show all the tables attributes for the parent Datasource that the user defined in the Datasource Instance has permission to viewselected Table.
The list below gives the column headers returned for an Oracle database. See Oracle documentation for more details.
| Field | Description |
|---|---|
| OWNER | The Schema Owner |
| TABLENAME | The name of the table. | TABLESPACE
| COLUMNID | The Oracle tablespace configured Oracle's internal id for the tablecolumn. |
| COLUMNNAME | Approximate number of rows in this table. Note that this information is based on stats data collected by Oracle and may or may not be up to date. |
...
| The name of the attribute | |
| DATATYPE | The Oracle data type. |
| CHARLENGTH | For character types, the column length in characters (not necessarily the same as the length in bytes depending on character sets). |
| DATAPRECISION | For numeric types, the data precision. |
| DATASCALE | For numeric types, the data scale. |
| NULLABLE | Set to "Y" if the column is nullable |
Table Attribute Actions
The following actions are possible from a Table Attribute list:
- Double clicking on a Table entry pops up a Data Grid showing the first page of data returned from the table.
- Dragging a table and dropping it on Selecting several attributes and dragging onto a modelling pane creates a Database Collector which is linked to the original Datasource. The Collector will be set up to fetch all just the table fields selected columns and all the table data. From the right-click context menu you can choose to view the table attributes (a simple or detailed list). See Table Attributes.