29 lines
1.0 KiB
SQL
29 lines
1.0 KiB
SQL
-- SPDX-License-Identifier: LicenseRef-ConusAI-Template-1.0
|
|
create table `proposals` (
|
|
`id` char(36) primary key,
|
|
`version` integer not null,
|
|
`created_at` datetime(6) not null,
|
|
`updated_at` datetime(6) not null,
|
|
`org_id` char(36) not null,
|
|
`workspace_id` char(36) not null,
|
|
`project_id` char(36) not null,
|
|
`status` text not null,
|
|
`target_key` text not null,
|
|
`target_record_id` text,
|
|
`written_record_id` text,
|
|
`change` json not null,
|
|
`evidence` json not null,
|
|
`model` text not null,
|
|
`prompt_version` text not null,
|
|
`created_by` text not null,
|
|
`edited_by` text,
|
|
`edited_at` text,
|
|
`decided_by` text,
|
|
`decided_at` text,
|
|
`reason` text
|
|
) engine=InnoDB default charset=utf8mb4;
|
|
|
|
create index `proposals_org_id_workspace_id_project_id_status_idx` on `proposals` (`org_id`, `workspace_id`, `project_id`, `status`(191));
|
|
|
|
create index `proposals_org_id_workspace_id_project_id_target_key_tar_25412770` on `proposals` (`org_id`, `workspace_id`, `project_id`, `target_key`(191), `target_record_id`(191));
|