orderTable

orderTable contains orders for production.

less than a minute

Usage

This table stores orders for product production

Structure

key	data type	description	example
`order_id`	`serial`	Auto incrementing id	0
`order_name`	`text`	Name of the order	Scarjit-500-DaVinci-1-24062022
`product_id`	`serial`	Product id to produce	1
`begin_timestamp`	`timestamptz`	Begin timestamp of the order	0
`end_timestamp`	`timestamptz`	End timestamp of the order	10000
`target_units`	`integer`	How many product to produce	500
`asset_id`	`serial`	Which asset to produce on (see assetTable )	1

Relations

DDL

CREATE TABLE IF NOT EXISTS orderTable
(
    order_id        SERIAL          PRIMARY KEY,
    order_name      TEXT            NOT NULL,
    product_id      SERIAL          REFERENCES productTable (product_id),
    begin_timestamp TIMESTAMPTZ,
    end_timestamp   TIMESTAMPTZ,
    target_units    INTEGER,
    asset_id        SERIAL          REFERENCES assetTable (id),
    unique (asset_id, order_name),
    CHECK (begin_timestamp < end_timestamp),
    CHECK (target_units > 0),
    EXCLUDE USING gist (asset_id WITH =, tstzrange(begin_timestamp, end_timestamp) WITH &&) WHERE (begin_timestamp IS NOT NULL AND end_timestamp IS NOT NULL)
);

Last modified May 5, 2023: feat: finishing touches (1147002)