Hi. In pgAdminIII I see this on res_country_state table create code
-- Table: res_country_state
-- DROP TABLE res_country_state;
CREATE TABLE res_country_state
(
id serial NOT NULL,
create_uid integer, -- Created by
code character varying(3) NOT NULL, -- State Code
create_date timestamp without time zone, -- Created on
name character varying NOT NULL, -- State Name
country_id integer NOT NULL, -- Country
write_uid integer, -- Last Updated by
write_date timestamp without time zone, -- Last Updated on
CONSTRAINT res_country_state_pkey PRIMARY KEY (id),
CONSTRAINT res_country_state_country_id_fkey FOREIGN KEY (country_id)
REFERENCES res_country (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL,
CONSTRAINT res_country_state_create_uid_fkey FOREIGN KEY (create_uid)
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL,
CONSTRAINT res_country_state_write_uid_fkey FOREIGN KEY (write_uid)
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL
)
WITH (
OIDS=FALSE
);
ALTER TABLE res_country_state
OWNER TO postgres;
COMMENT ON TABLE res_country_state
IS 'Country state';
COMMENT ON COLUMN res_country_state.create_uid IS 'Created by';
COMMENT ON COLUMN res_country_state.code IS 'State Code';
COMMENT ON COLUMN res_country_state.create_date IS 'Created on';
COMMENT ON COLUMN res_country_state.name IS 'State Name';
COMMENT ON COLUMN res_country_state.country_id IS 'Country';
COMMENT ON COLUMN res_country_state.write_uid IS 'Last Updated by';
COMMENT ON COLUMN res_country_state.write_date IS 'Last Updated on';
On Heidi I see this create code tab:
CREATE TABLE "res_partner_title" (
"id" INTEGER NOT NULL DEFAULT E'',
"create_uid" INTEGER NULL DEFAULT NULL,
"domain" VARCHAR NOT NULL,
"create_date" TIMESTAMP NULL,
"name" VARCHAR NOT NULL,
"shortcut" VARCHAR NULL DEFAULT NULL,
"write_uid" INTEGER NULL DEFAULT NULL,
"write_date" TIMESTAMP NULL,
"name_fr" VARCHAR NOT NULL,
"shortcut_fr" VARCHAR NULL DEFAULT NULL
)
;
COMMENT ON COLUMN "res_partner_title"."id" IS E'';
COMMENT ON COLUMN "res_partner_title"."create_uid" IS E'';
COMMENT ON COLUMN "res_partner_title"."domain" IS E'';
COMMENT ON COLUMN "res_partner_title"."create_date" IS E'';
COMMENT ON COLUMN "res_partner_title"."name" IS E'';
COMMENT ON COLUMN "res_partner_title"."shortcut" IS E'';
COMMENT ON COLUMN "res_partner_title"."write_uid" IS E'';
COMMENT ON COLUMN "res_partner_title"."write_date" IS E'';
COMMENT ON COLUMN "res_partner_title"."name_fr" IS E'';
COMMENT ON COLUMN "res_partner_title"."shortcut_fr" IS E'';
Nowhere I can find the primary key, constraints nor the comments. Does these features are planned to be added shortly in Heidi?
Thanks