# app_version

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE "app_version" ("id" varchar PRIMARY KEY NOT NULL, "appId" varchar NOT NULL, "label" varchar(255), "sourceArtifactId" integer NOT NULL, "bundleArtifactId" integer, "buildAttempts" integer NOT NULL DEFAULT (0), "buildStatus" varchar(16) NOT NULL DEFAULT ('queued'), "buildStatusUpdatedAt" datetime(3), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "bindings" text NOT NULL DEFAULT '[]', "description" TEXT, CONSTRAINT "CHK_app_version_buildStatus" CHECK ("buildStatus" IN ('queued', 'running', 'succeeded', 'failed')), CONSTRAINT "FK_e9aeab5b1db8dc77708231ae44e" FOREIGN KEY ("appId") REFERENCES "app" ("id") ON DELETE CASCADE, CONSTRAINT "FK_9f1db6f02f5a0d1ae2f2b41a327" FOREIGN KEY ("sourceArtifactId") REFERENCES "app_artifact" ("id") ON DELETE RESTRICT, CONSTRAINT "FK_2ab536cbf97d71bad59517afee5" FOREIGN KEY ("bundleArtifactId") REFERENCES "app_artifact" ("id") ON DELETE SET NULL)
```

</details>

## Columns

| Name | Type | Default | Nullable | Children | Parents | Comment |
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
| appId | varchar |  | false |  | [app](app.md) |  |
| bindings | TEXT | '[]' | false |  |  |  |
| buildAttempts | INTEGER | 0 | false |  |  |  |
| buildStatus | varchar(16) | 'queued' | false |  |  |  |
| buildStatusUpdatedAt | datetime(3) |  | true |  |  |  |
| bundleArtifactId | INTEGER |  | true |  | [app_artifact](app_artifact.md) |  |
| createdAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false |  |  |  |
| description | TEXT |  | true |  |  |  |
| id | varchar |  | false | [app](app.md) |  |  |
| label | varchar(255) |  | true |  |  |  |
| sourceArtifactId | INTEGER |  | false |  | [app_artifact](app_artifact.md) |  |
| updatedAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false |  |  |  |

## Constraints

| Name | Type | Definition |
| ---- | ---- | ---------- |
| - | CHECK | CHECK ("buildStatus" IN ('queued', 'running', 'succeeded', 'failed')) |
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (bundleArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE |
| - (Foreign key ID: 1) | FOREIGN KEY | FOREIGN KEY (sourceArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE |
| - (Foreign key ID: 2) | FOREIGN KEY | FOREIGN KEY (appId) REFERENCES app (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE |
| id | PRIMARY KEY | PRIMARY KEY (id) |
| sqlite_autoindex_app_version_1 | PRIMARY KEY | PRIMARY KEY (id) |

## Indexes

| Name | Definition |
| ---- | ---------- |
| IDX_2ab536cbf97d71bad59517afee | CREATE INDEX "IDX_2ab536cbf97d71bad59517afee" ON "app_version" ("bundleArtifactId")  |
| IDX_9f1db6f02f5a0d1ae2f2b41a32 | CREATE INDEX "IDX_9f1db6f02f5a0d1ae2f2b41a32" ON "app_version" ("sourceArtifactId")  |
| IDX_e9aeab5b1db8dc77708231ae44 | CREATE INDEX "IDX_e9aeab5b1db8dc77708231ae44" ON "app_version" ("appId")  |
| sqlite_autoindex_app_version_1 | PRIMARY KEY (id) |

## Relations

```mermaid
erDiagram

"app_version" }o--|| "app" : "FOREIGN KEY (appId) REFERENCES app (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"app_version" }o--o| "app_artifact" : "FOREIGN KEY (bundleArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app" }o--o| "app_version" : "FOREIGN KEY (draftVersionId) REFERENCES app_version (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app" }o--o| "app_version" : "FOREIGN KEY (publishedVersionId) REFERENCES app_version (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app_version" }o--|| "app_artifact" : "FOREIGN KEY (sourceArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE"

"app_version" {
  varchar appId FK
  TEXT bindings
  INTEGER buildAttempts
  varchar_16_ buildStatus
  datetime_3_ buildStatusUpdatedAt
  INTEGER bundleArtifactId FK
  datetime_3_ createdAt
  TEXT description
  varchar id PK
  varchar_255_ label
  INTEGER sourceArtifactId FK
  datetime_3_ updatedAt
}
"app" {
  datetime_3_ createdAt
  varchar draftVersionId FK
  varchar id PK
  varchar_128_ name
  varchar_128_ namespace
  varchar_36_ projectId FK
  varchar publishedVersionId FK
  datetime_3_ updatedAt
  varchar_16_ visibility
}
"app_artifact" {
  varchar appId
  datetime_3_ createdAt
  INTEGER id
  INTEGER sizeBytes
  TEXT storageKey
  varchar_2_ storedAt
  datetime_3_ updatedAt
  varchar_16_ uploadStatus
}
```

---

> Generated by [tbls](https://github.com/k1LoW/tbls)