SQL Power Software Forum

This message was edited 1 time. Last update was at 2016-09-07 04:36:50

I was very pleased to discover SQL Power Architect recently but I've come across an issue.

I'm trying to reverse engineer a PostgreSQL DB and finding that the FKs are getting dropped. Not all of them, just some. There doesn't seem to be a pattern that I can tell.

Frustratingly I did find the following topic when I did a search, but it's coming up as not existing: Losing some Foreign Keys when reverse engineering Postgresql databases

One of the tables I'm having problems with follows - only financial_year_id gets its FK:

-- Table: public.asset_value

-- DROP TABLE public.asset_value;

CREATE TABLE public.asset_value
(
  id integer NOT NULL DEFAULT nextval('asset_value_id_seq'::regclass),
  update_date timestamp with time zone NOT NULL,
  create_date timestamp with time zone NOT NULL,
  asset_value_type_dict_id integer NOT NULL,
  depreciation_method_dict_id integer NOT NULL,
  depreciation_rate numeric(3,2) NOT NULL,
  event_date_id integer NOT NULL,
  financial_year_id integer NOT NULL,
  valuation_date integer NOT NULL,
  year_end_value numeric(7,5) NOT NULL,
  CONSTRAINT asset_value_pkey PRIMARY KEY (id),
  CONSTRAINT asset_value_asset_value_type_dict_id_dict FOREIGN KEY (asset_value_type_dict_id)
      REFERENCES public.dict (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT asset_value_depreciation_method_dict_id_dict FOREIGN KEY (depreciation_method_dict_id)
      REFERENCES public.dict (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT asset_value_event_date_id_event_date FOREIGN KEY (event_date_id)
      REFERENCES public.event_date (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT asset_value_financial_year_id_financial_year FOREIGN KEY (financial_year_id)
      REFERENCES public.financial_year (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT asset_value_valuation_date_event_date FOREIGN KEY (valuation_date)
      REFERENCES public.event_date (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.asset_value
  OWNER TO postgres;