t_process_message

-- Table: t_process_message

-- DROP TABLE t_process_message;

CREATE TABLE t_process_message
(
  process_message_id bigint NOT NULL DEFAULT nextval('process_message_seq'::regclass),
  process_name character varying(100),
  process_no character varying(100),
  tenant_id bigint,
  process_create_datetime character varying(14),
  process_queue_datetime character varying(14),
  process_finish_datetime character varying(14),
  process_status character varying(1),
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  ref_id bigint DEFAULT (-99),
  tag_id bigint DEFAULT (-99),
  flg_reprocess character varying(1) DEFAULT 'N'::character varying,
  prev_process_message_id bigint DEFAULT (-99),
  line_queue character varying(100) DEFAULT ''::character varying,
  CONSTRAINT t_process_message_pkey PRIMARY KEY (process_message_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE t_process_message
  OWNER TO sts;

-- Index: idx_process_message_01

-- DROP INDEX idx_process_message_01;

CREATE UNIQUE INDEX idx_process_message_01
  ON t_process_message
  USING btree
  (process_name COLLATE pg_catalog."default", process_no COLLATE pg_catalog."default", tenant_id);