public.app_version
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| appId |
uuid |
|
false |
|
public.app |
|
| buildAttempts |
integer |
0 |
false |
|
|
|
| buildStatus |
varchar(16) |
'queued'::character varying |
false |
|
|
Build state: queued, running, succeeded, or failed |
| buildStatusUpdatedAt |
timestamp(3) with time zone |
|
true |
|
|
|
| bundleArtifactId |
integer |
|
true |
|
public.app_artifact |
|
| createdAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| id |
uuid |
|
false |
public.app |
|
|
| label |
varchar(255) |
|
true |
|
|
|
| sourceArtifactId |
integer |
|
false |
|
public.app_artifact |
|
| updatedAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
Constraints
| Name |
Type |
Definition |
| CHK_app_version_buildStatus |
CHECK |
CHECK ((("buildStatus")::text = ANY ((ARRAY['queued'::character varying, 'running'::character varying, 'succeeded'::character varying, 'failed'::character varying])::text[]))) |
| FK_2ab536cbf97d71bad59517afee5 |
FOREIGN KEY |
FOREIGN KEY ("bundleArtifactId") REFERENCES app_artifact(id) ON DELETE SET NULL |
| FK_9f1db6f02f5a0d1ae2f2b41a327 |
FOREIGN KEY |
FOREIGN KEY ("sourceArtifactId") REFERENCES app_artifact(id) ON DELETE RESTRICT |
| FK_e9aeab5b1db8dc77708231ae44e |
FOREIGN KEY |
FOREIGN KEY ("appId") REFERENCES app(id) ON DELETE CASCADE |
| PK_f2573b981a7eac664875e7483ac |
PRIMARY KEY |
PRIMARY KEY (id) |
| app_version_appId_not_null |
n |
NOT NULL "appId" |
| app_version_buildAttempts_not_null |
n |
NOT NULL "buildAttempts" |
| app_version_buildStatus_not_null |
n |
NOT NULL "buildStatus" |
| app_version_createdAt_not_null |
n |
NOT NULL "createdAt" |
| app_version_id_not_null |
n |
NOT NULL id |
| app_version_sourceArtifactId_not_null |
n |
NOT NULL "sourceArtifactId" |
| app_version_updatedAt_not_null |
n |
NOT NULL "updatedAt" |
Indexes
| Name |
Definition |
| IDX_2ab536cbf97d71bad59517afee |
CREATE INDEX "IDX_2ab536cbf97d71bad59517afee" ON public.app_version USING btree ("bundleArtifactId") |
| IDX_9f1db6f02f5a0d1ae2f2b41a32 |
CREATE INDEX "IDX_9f1db6f02f5a0d1ae2f2b41a32" ON public.app_version USING btree ("sourceArtifactId") |
| IDX_e9aeab5b1db8dc77708231ae44 |
CREATE INDEX "IDX_e9aeab5b1db8dc77708231ae44" ON public.app_version USING btree ("appId") |
| PK_f2573b981a7eac664875e7483ac |
CREATE UNIQUE INDEX "PK_f2573b981a7eac664875e7483ac" ON public.app_version USING btree (id) |
Relations
erDiagram
"public.app_version" }o--|| "public.app" : "FOREIGN KEY (#quot;appId#quot;) REFERENCES app(id) ON DELETE CASCADE"
"public.app_version" }o--o| "public.app_artifact" : "FOREIGN KEY (#quot;bundleArtifactId#quot;) REFERENCES app_artifact(id) ON DELETE SET NULL"
"public.app" }o--o| "public.app_version" : "FOREIGN KEY (#quot;draftVersionId#quot;) REFERENCES app_version(id) ON DELETE SET NULL"
"public.app" }o--o| "public.app_version" : "FOREIGN KEY (#quot;publishedVersionId#quot;) REFERENCES app_version(id) ON DELETE SET NULL"
"public.app_version" }o--|| "public.app_artifact" : "FOREIGN KEY (#quot;sourceArtifactId#quot;) REFERENCES app_artifact(id) ON DELETE RESTRICT"
"public.app_version" {
uuid appId FK
integer buildAttempts
varchar_16_ buildStatus
timestamp_3__with_time_zone buildStatusUpdatedAt
integer bundleArtifactId FK
timestamp_3__with_time_zone createdAt
uuid id
varchar_255_ label
integer sourceArtifactId FK
timestamp_3__with_time_zone updatedAt
}
"public.app" {
timestamp_3__with_time_zone createdAt
uuid draftVersionId FK
uuid id
varchar_128_ name
varchar_128_ namespace
varchar_36_ projectId FK
uuid publishedVersionId FK
timestamp_3__with_time_zone updatedAt
varchar_16_ visibility
}
"public.app_artifact" {
uuid appId
timestamp_3__with_time_zone createdAt
integer id
integer sizeBytes
text storageKey
varchar_2_ storedAt
timestamp_3__with_time_zone updatedAt
varchar_16_ uploadStatus
}
Generated by tbls