26 lines
851 B
Plaintext
26 lines
851 B
Plaintext
CREATE TABLE Orders (
|
|
id INT NOT NULL ,
|
|
customer_name VARCHAR(45) NULL ,
|
|
customer_address VARCHAR(45) NULL ,
|
|
deliverydate VARCHAR(10) NOT NULL ,
|
|
state VARCHAR(10) NULL DEFAULT 'New' ,
|
|
destination VARCHAR(10) NOT NULL ,
|
|
prio INT NOT NULL,
|
|
PRIMARY KEY (id) );
|
|
|
|
CREATE TABLE Orderlines (
|
|
id INTEGER PRIMARY KEY,
|
|
orderid INT NOT NULL ,
|
|
article INT NOT NULL ,
|
|
caption VARCHAR(45) NULL ,
|
|
amount DECIMAL(10,0) NOT NULL ,
|
|
amount_unit VARCHAR(2) NOT NULL DEFAULT 'KG' ,
|
|
amount_delivered DECIMAL(10,0) NOT NULL DEFAULT 0.0 ,
|
|
weight DECIMAL(10,0) NOT NULL ,
|
|
weight_unit VARCHAR(2) NOT NULL DEFAULT 'KG' ,
|
|
weight_delivered DECIMAL(10,0) NOT NULL DEFAULT 0.0 ,
|
|
state VARCHAR(10) NULL DEFAULT 'New' ,
|
|
CONSTRAINT uk_IdOrderId UNIQUE (id, orderid) ,
|
|
CONSTRAINT fk_OrderId FOREIGN KEY (orderid) REFERENCES Orders (id)
|
|
);
|