Aqua Data Studio 15.0.0-dev-265
Build #: 37671
Built on: 2014-May-02 05:20:23 PM
OS Environment: Windows 8(x64 bit)
Database : Amazon Redshift
Steps to reproduce:
1. Connect to Redshift server --> Go to Databases folder
2. Select any schema
3. Create Table
CREATE TABLE "redshift"."employee" (
"id" int4 NOT NULL DEFAULT 1000,
"name" varchar(25) NULL,
"dept" varchar(25) NULL,
"salary" varchar(25) NULL,
"join_date" date NULL,
"dept_id" int4 NULL,
CONSTRAINT "ppp11" PRIMARY KEY("id")
)
DISTSTYLE EVEN
GO
4. Select and right click on above created table --> Select Tools --> ER Diagram Generator option.
5. In ER Diagram Generator window select Tables in Object type pane and select only above created table in Objects pane,Click on Next button.
6. In ER Diagram window, Drop one table from Entities pane and double click on it.
7. Table properties window opened, Change table properties i.e, Name and add columns in table, click on OK button.
8. Right click on newly added table and select New Relationship option.
9. In Relationship properties window,Select Child Table is from database which is present in ER Diagram.
Here it is observed that columns of table are not listed in Child table.
Please see attached screenshot.
issue is old and is not confined to redshift... continuing to look into issue...