CREATE TABLE device_table (
device_id CHAR(5) NOT NULL,
product_type CHAR VARYING(15) NOT NULL,
model CHAR VARYING(50) NOT NULL,
manufacturer CHAR VARYING(15),
production_year INTEGER,
customer_id INTEGER NOT NULL,
note CHAR VARYING(100),
FOREIGN KEY (customer_id) REFERENCES customer_table (customer_id),
PRIMARY KEY (device_id)
);
device_id CHAR(5) NOT NULL,
product_type CHAR VARYING(15) NOT NULL,
model CHAR VARYING(50) NOT NULL,
manufacturer CHAR VARYING(15),
production_year INTEGER,
customer_id INTEGER NOT NULL,
note CHAR VARYING(100),
FOREIGN KEY (customer_id) REFERENCES customer_table (customer_id),
PRIMARY KEY (device_id)
);