4abb12f71f
* removed the deleted_at column and removed one extra space in the resolved,duplicated messages * changed rca input entity stucture * changes text in tests of rca service
10 lines
382 B
SQL
10 lines
382 B
SQL
CREATE TABLE IF NOT EXISTS rca_input (
|
|
id SERIAL PRIMARY KEY,
|
|
incident_id integer NOT NULL REFERENCES incident(id),
|
|
document_type character varying(100),
|
|
identifier_keys text[] DEFAULT '{}'::text[],
|
|
provider_name character varying(100),
|
|
is_active boolean DEFAULT true,
|
|
created_at timestamp without time zone,
|
|
updated_at timestamp without time zone
|
|
); |