0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
28 lines
978 B
SQL
28 lines
978 B
SQL
CREATE TABLE case_intent_version
|
|
(
|
|
version_id SERIAL NOT NULL PRIMARY KEY,
|
|
reviewer TEXT NOT NULL,
|
|
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
|
|
);
|
|
CREATE TABLE case_intent
|
|
(
|
|
id SERIAL NOT NULL PRIMARY KEY,
|
|
case_intent_string TEXT NOT NULL,
|
|
description TEXT NOT NULL,
|
|
author TEXT NOT NULL
|
|
);
|
|
CREATE TABLE case_intent_parent_join
|
|
(
|
|
case_intent_id BIGINT NOT NULL,
|
|
case_intent_parent_id BIGINT NOT NULL,
|
|
constraint fk_case_intent_id foreign key (case_intent_id) references case_intent(id),
|
|
constraint fk_case_intent_parent_id foreign key (case_intent_parent_id) references case_intent(id)
|
|
);
|
|
CREATE TABLE case_intent_version_join
|
|
(
|
|
case_intent_id BIGINT NOT NULL,
|
|
case_intent_version_id INT NOT NULL,
|
|
constraint fk_case_intent_id foreign key (case_intent_id) references case_intent(id),
|
|
constraint fk_case_intent_version_id foreign key (case_intent_version_id) references case_intent_version(version_id)
|
|
);
|