t_process_parameter

-- Table: t_process_parameter

-- DROP TABLE t_process_parameter;

CREATE TABLE t_process_parameter
(
  process_parameter_id bigint NOT NULL DEFAULT nextval('process_parameter_seq'::regclass),
  process_message_id bigint,
  process_parameter_key character varying(100),
  process_parameter_value text,
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT t_process_parameter_pkey PRIMARY KEY (process_parameter_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE t_process_parameter
  OWNER TO sts;

-- Index: idx_process_parameter_01

-- DROP INDEX idx_process_parameter_01;

CREATE UNIQUE INDEX idx_process_parameter_01
  ON t_process_parameter
  USING btree
  (process_message_id, process_parameter_key COLLATE pg_catalog."default");