blob: a002a40fe108f05b52dd751b73ba43bac9dd4a77 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
--
-- Copyright (c) 2020-2021 science+computing ag and other contributors
--
-- This program and the accompanying materials are made
-- available under the terms of the Eclipse Public License 2.0
-- which is available at https://www.eclipse.org/legal/epl-2.0/
--
-- SPDX-License-Identifier: EPL-2.0
--
-- Your SQL goes here
CREATE TABLE jobs (
id SERIAL PRIMARY KEY NOT NULL,
submit_id INTEGER REFERENCES submits(id) NOT NULL,
endpoint_id INTEGER REFERENCES endpoints(id) NOT NULL,
package_id INTEGER REFERENCES packages(id) NOT NULL,
image_id INTEGER REFERENCES images(id) NOT NULL,
artifact_id INTEGER REFERENCES artifacts(id) NOT NULL,
container_hash VARCHAR NOT NULL,
script_text TEXT NOT NULL,
log_text TEXT NOT NULL
)
|