CREATE TYPE "public"."tangled_pipeline_status_status" AS ENUM('pending', 'running', 'failed', 'timeout', 'cancelled', 'success');--> statement-breakpoint
CREATE TYPE "public"."tangled_pipeline_trigger_metadata_kind" AS ENUM('push', 'pull_request', 'manual');--> statement-breakpoint
CREATE TYPE "public"."tangled_vouch_kind" AS ENUM('vouch', 'denounce');--> statement-breakpoint
CREATE TABLE "tangled_artifact" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"name" text,
	"repo" text,
	"repo_did" text,
	"tag" text,
	"created_at" timestamp with time zone,
	"artifact_ref" text,
	"artifact_size" integer,
	"artifact_mime_type" text,
	CONSTRAINT "tangled_artifact_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_artifact_cid_only_null_if_deleted" CHECK (("tangled_artifact"."cid" is not null or "tangled_artifact"."deleted" = true)),
	CONSTRAINT "tangled_artifact_non_null_fields" CHECK (("tangled_artifact"."deleted" = true or ("tangled_artifact"."name" is not null and "tangled_artifact"."tag" is not null and "tangled_artifact"."created_at" is not null and "tangled_artifact"."artifact_ref" is not null and "tangled_artifact"."artifact_size" is not null and "tangled_artifact"."artifact_mime_type" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_collaborator" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"repo" text,
	"repo_did" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_collaborator_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_collaborator_cid_only_null_if_deleted" CHECK (("tangled_collaborator"."cid" is not null or "tangled_collaborator"."deleted" = true)),
	CONSTRAINT "tangled_collaborator_non_null_fields" CHECK (("tangled_collaborator"."deleted" = true or ("tangled_collaborator"."subject" is not null and "tangled_collaborator"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_follow" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_follow_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_follow_cid_only_null_if_deleted" CHECK (("tangled_follow"."cid" is not null or "tangled_follow"."deleted" = true)),
	CONSTRAINT "tangled_follow_non_null_fields" CHECK (("tangled_follow"."deleted" = true or ("tangled_follow"."subject" is not null and "tangled_follow"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_issue" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"repo" text,
	"repo_did" text,
	"title" text,
	"body" text,
	"created_at" timestamp with time zone,
	"mentions" text[],
	"references" text[],
	CONSTRAINT "tangled_issue_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_issue_cid_only_null_if_deleted" CHECK (("tangled_issue"."cid" is not null or "tangled_issue"."deleted" = true)),
	CONSTRAINT "tangled_issue_non_null_fields" CHECK (("tangled_issue"."deleted" = true or ("tangled_issue"."title" is not null and "tangled_issue"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_issue_comment" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"issue" text,
	"body" text,
	"created_at" timestamp with time zone,
	"reply_to" text,
	"mentions" text[],
	"references" text[],
	CONSTRAINT "tangled_issue_comment_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_issue_comment_cid_only_null_if_deleted" CHECK (("tangled_issue_comment"."cid" is not null or "tangled_issue_comment"."deleted" = true)),
	CONSTRAINT "tangled_issue_comment_non_null_fields" CHECK (("tangled_issue_comment"."deleted" = true or ("tangled_issue_comment"."issue" is not null and "tangled_issue_comment"."body" is not null and "tangled_issue_comment"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_issue_state" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"issue" text,
	"state" text,
	CONSTRAINT "tangled_issue_state_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_issue_state_cid_only_null_if_deleted" CHECK (("tangled_issue_state"."cid" is not null or "tangled_issue_state"."deleted" = true)),
	CONSTRAINT "tangled_issue_state_non_null_fields" CHECK (("tangled_issue_state"."deleted" = true or ("tangled_issue_state"."issue" is not null and "tangled_issue_state"."state" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_knot" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_knot_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_knot_cid_only_null_if_deleted" CHECK (("tangled_knot"."cid" is not null or "tangled_knot"."deleted" = true)),
	CONSTRAINT "tangled_knot_non_null_fields" CHECK (("tangled_knot"."deleted" = true or "tangled_knot"."created_at" is not null))
);
--> statement-breakpoint
CREATE TABLE "tangled_knot_member" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"domain" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_knot_member_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_knot_member_cid_only_null_if_deleted" CHECK (("tangled_knot_member"."cid" is not null or "tangled_knot_member"."deleted" = true)),
	CONSTRAINT "tangled_knot_member_non_null_fields" CHECK (("tangled_knot_member"."deleted" = true or ("tangled_knot_member"."subject" is not null and "tangled_knot_member"."domain" is not null and "tangled_knot_member"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_label_definition" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"name" text,
	"value_type" text,
	"value_format" text,
	"value_enum" text[],
	"scope" text[],
	"color" text,
	"created_at" timestamp with time zone,
	"multiple" boolean,
	CONSTRAINT "tangled_label_definition_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_label_definition_cid_only_null_if_deleted" CHECK (("tangled_label_definition"."cid" is not null or "tangled_label_definition"."deleted" = true)),
	CONSTRAINT "tangled_label_definition_non_null_fields" CHECK (("tangled_label_definition"."deleted" = true or ("tangled_label_definition"."name" is not null and "tangled_label_definition"."value_type" is not null and "tangled_label_definition"."value_format" is not null and "tangled_label_definition"."scope" is not null and "tangled_label_definition"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_label_op" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"performed_at" timestamp with time zone,
	"add" jsonb,
	"delete" jsonb,
	CONSTRAINT "tangled_label_op_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_label_op_cid_only_null_if_deleted" CHECK (("tangled_label_op"."cid" is not null or "tangled_label_op"."deleted" = true)),
	CONSTRAINT "tangled_label_op_non_null_fields" CHECK (("tangled_label_op"."deleted" = true or ("tangled_label_op"."subject" is not null and "tangled_label_op"."add" is not null and "tangled_label_op"."delete" is not null and "tangled_label_op"."performed_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_pipeline" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"trigger_metadata_kind" "tangled_pipeline_trigger_metadata_kind",
	"trigger_metadata_repo_knot" text,
	"trigger_metadata_repo_did" text,
	"trigger_metadata_repo_repo_did" text,
	"trigger_metadata_repo_repo" text,
	"trigger_metadata_repo_default_branch" text,
	"trigger_metadata_push_ref" text,
	"trigger_metadata_push_new_sha" text,
	"trigger_metadata_push_old_sha" text,
	"trigger_metadata_pull_source_branch" text,
	"trigger_metadata_pull_target_branch" text,
	"trigger_metadata_pull_source_sha" text,
	"trigger_metadata_pull_action" text,
	"trigger_metadata_manual" jsonb,
	"workflows" jsonb,
	CONSTRAINT "tangled_pipeline_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_pipeline_cid_only_null_if_deleted" CHECK (("tangled_pipeline"."cid" is not null or "tangled_pipeline"."deleted" = true)),
	CONSTRAINT "tangled_pipeline_non_null_fields" CHECK (("tangled_pipeline"."deleted" = true or ("tangled_pipeline"."trigger_metadata_kind" is not null and "tangled_pipeline"."trigger_metadata_repo_knot" is not null and "tangled_pipeline"."trigger_metadata_repo_did" is not null and "tangled_pipeline"."trigger_metadata_repo_default_branch" is not null and "tangled_pipeline"."workflows" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_pipeline_status" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"pipeline" text,
	"workflow" text,
	"status" "tangled_pipeline_status_status",
	"created_at" timestamp with time zone,
	"error" text,
	"exit_code" integer,
	CONSTRAINT "tangled_pipeline_status_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_pipeline_status_cid_only_null_if_deleted" CHECK (("tangled_pipeline_status"."cid" is not null or "tangled_pipeline_status"."deleted" = true)),
	CONSTRAINT "tangled_pipeline_status_non_null_fields" CHECK (("tangled_pipeline_status"."deleted" = true or ("tangled_pipeline_status"."pipeline" is not null and "tangled_pipeline_status"."workflow" is not null and "tangled_pipeline_status"."status" is not null and "tangled_pipeline_status"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_public_key" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"key" text,
	"name" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_public_key_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_public_key_cid_only_null_if_deleted" CHECK (("tangled_public_key"."cid" is not null or "tangled_public_key"."deleted" = true)),
	CONSTRAINT "tangled_public_key_non_null_fields" CHECK (("tangled_public_key"."deleted" = true or ("tangled_public_key"."key" is not null and "tangled_public_key"."name" is not null and "tangled_public_key"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_pull" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"title" text,
	"body" text,
	"rounds" jsonb,
	"source_branch" text,
	"source_repo" text,
	"source_repo_did" text,
	"target_branch" text,
	"target_repo" text,
	"target_repo_did" text,
	"created_at" timestamp with time zone,
	"mentions" text[],
	"references" text[],
	"dependent_on" text,
	CONSTRAINT "tangled_pull_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_pull_cid_only_null_if_deleted" CHECK (("tangled_pull"."cid" is not null or "tangled_pull"."deleted" = true)),
	CONSTRAINT "tangled_pull_non_null_fields" CHECK (("tangled_pull"."deleted" = true or ("tangled_pull"."target_branch" is not null and "tangled_pull"."title" is not null and "tangled_pull"."created_at" is not null and "tangled_pull"."rounds" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_pull_comment" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"pull" text,
	"body" text,
	"created_at" timestamp with time zone,
	"mentions" text[],
	"references" text[],
	CONSTRAINT "tangled_pull_comment_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_pull_comment_cid_only_null_if_deleted" CHECK (("tangled_pull_comment"."cid" is not null or "tangled_pull_comment"."deleted" = true)),
	CONSTRAINT "tangled_pull_comment_non_null_fields" CHECK (("tangled_pull_comment"."deleted" = true or ("tangled_pull_comment"."pull" is not null and "tangled_pull_comment"."body" is not null and "tangled_pull_comment"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_pull_status" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"pull" text,
	"status" text,
	CONSTRAINT "tangled_pull_status_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_pull_status_cid_only_null_if_deleted" CHECK (("tangled_pull_status"."cid" is not null or "tangled_pull_status"."deleted" = true)),
	CONSTRAINT "tangled_pull_status_non_null_fields" CHECK (("tangled_pull_status"."deleted" = true or ("tangled_pull_status"."pull" is not null and "tangled_pull_status"."status" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_reaction" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"reaction" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_reaction_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_reaction_cid_only_null_if_deleted" CHECK (("tangled_reaction"."cid" is not null or "tangled_reaction"."deleted" = true)),
	CONSTRAINT "tangled_reaction_non_null_fields" CHECK (("tangled_reaction"."deleted" = true or ("tangled_reaction"."subject" is not null and "tangled_reaction"."reaction" is not null and "tangled_reaction"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_ref_update" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"ref" text,
	"committer_did" text,
	"owner_did" text,
	"repo_did" text,
	"repo_name" text,
	"old_sha" text,
	"new_sha" text,
	"meta_is_default_ref" boolean,
	"meta_lang_breakdown" jsonb,
	"meta_commit_count" jsonb,
	CONSTRAINT "tangled_ref_update_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_ref_update_cid_only_null_if_deleted" CHECK (("tangled_ref_update"."cid" is not null or "tangled_ref_update"."deleted" = true)),
	CONSTRAINT "tangled_ref_update_non_null_fields" CHECK (("tangled_ref_update"."deleted" = true or ("tangled_ref_update"."ref" is not null and "tangled_ref_update"."committer_did" is not null and "tangled_ref_update"."repo_name" is not null and "tangled_ref_update"."old_sha" is not null and "tangled_ref_update"."new_sha" is not null and "tangled_ref_update"."meta_is_default_ref" is not null and "tangled_ref_update"."meta_commit_count" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_spindle" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_spindle_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_spindle_cid_only_null_if_deleted" CHECK (("tangled_spindle"."cid" is not null or "tangled_spindle"."deleted" = true)),
	CONSTRAINT "tangled_spindle_non_null_fields" CHECK (("tangled_spindle"."deleted" = true or "tangled_spindle"."created_at" is not null))
);
--> statement-breakpoint
CREATE TABLE "tangled_spindle_member" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"instance" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_spindle_member_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_spindle_member_cid_only_null_if_deleted" CHECK (("tangled_spindle_member"."cid" is not null or "tangled_spindle_member"."deleted" = true)),
	CONSTRAINT "tangled_spindle_member_non_null_fields" CHECK (("tangled_spindle_member"."deleted" = true or ("tangled_spindle_member"."subject" is not null and "tangled_spindle_member"."instance" is not null and "tangled_spindle_member"."created_at" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_star" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"subject" text,
	"subject_did" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_star_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_star_cid_only_null_if_deleted" CHECK (("tangled_star"."cid" is not null or "tangled_star"."deleted" = true)),
	CONSTRAINT "tangled_star_non_null_fields" CHECK (("tangled_star"."deleted" = true or "tangled_star"."created_at" is not null))
);
--> statement-breakpoint
CREATE TABLE "tangled_string" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"filename" text,
	"description" text,
	"created_at" timestamp with time zone,
	"contents" text,
	CONSTRAINT "tangled_string_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_string_cid_only_null_if_deleted" CHECK (("tangled_string"."cid" is not null or "tangled_string"."deleted" = true)),
	CONSTRAINT "tangled_string_non_null_fields" CHECK (("tangled_string"."deleted" = true or ("tangled_string"."filename" is not null and "tangled_string"."description" is not null and "tangled_string"."created_at" is not null and "tangled_string"."contents" is not null)))
);
--> statement-breakpoint
CREATE TABLE "tangled_vouch" (
	"did" text NOT NULL,
	"rev" text NOT NULL,
	"rkey" text NOT NULL,
	"cid" text,
	"deleted" boolean NOT NULL,
	"kind" "tangled_vouch_kind",
	"reason" text,
	"created_at" timestamp with time zone,
	CONSTRAINT "tangled_vouch_did_rkey_pk" PRIMARY KEY("did","rkey"),
	CONSTRAINT "tangled_vouch_cid_only_null_if_deleted" CHECK (("tangled_vouch"."cid" is not null or "tangled_vouch"."deleted" = true)),
	CONSTRAINT "tangled_vouch_non_null_fields" CHECK (("tangled_vouch"."deleted" = true or ("tangled_vouch"."kind" is not null and "tangled_vouch"."created_at" is not null)))
);