8 lines
322 B
SQL
8 lines
322 B
SQL
CREATE TABLE IF NOT EXISTS rca (
|
|
id SERIAL PRIMARY KEY,
|
|
incident_id integer NOT NULL REFERENCES incident(id),
|
|
rca_link text,
|
|
status text NOT NULL,
|
|
created_at timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
); |