QZnSM6bN

1IF EXISTS (SELECT * FROM customer) DROP TABLE customer;
2CREATE TABLE customer (
3	customer_id INT NOT NULL,
4	customer_priority INT,
5	customer_name VARCHAR(20),
6	customer_group_id INT,
7	PRIMARY KEY (customer_id)
8);
9IF EXISTS (SELECT * FROM sales_order) DROP TABLE sales_order;
10CREATE TABLE sales_order(
11	sales_order_id INT NOT NULL,
12	customer_id INT NOT NULL,
13	product_id INT NOT NULL,
14	so_quantity numeric(18,2),
15	so_tolerance numeric(18,2),
16	shipped_quantity numeric(18,2),
17	so_status INT,
18	orig_due_date date,
19	so_due_date date,
20	release_date date,
21	ship_to_location VARCHAR(50),
22	original_from_date date,
23	PRIMARY KEY (sales_order_id)
24);
25IF EXISTS (SELECT * FROM standard_operation)DROP TABLE standard_operation;
26CREATE TABLE standard_operation(
27	product_id INT NOT NULL,
28	resource_id INT NOT NULL,
29	component_product INT,
30	alternate_pref INT,
31	standard_op_no INT,
32	operation_type char(1),
33	standard_time INT,
34	yield_percent float
35);
36IF EXISTS (SELECT * FROM product)DROP TABLE product;
37CREATE TABLE product(
38	product_id INT NOT NULL,
39	product_desc VARCHAR(100),
40	product_usage_type varchar(1),
41	product_min_weight numeric(18,2),
42	product_max_weight numeric(18,2),
43	product_group varchar(10),
44	product_type varchar(10),
45	PRIMARY KEY (product_id)
46);
47IF EXISTS (SELECT * FROM resource)DROP TABLE resource;
48CREATE TABLE resource(
49	resource_id INT NOT NULL,
50	resource_desc varchar(50),
51	wearout_factor INT,
52	start_maintenance date,
53	end_maintenance date,
54	res_status INT,
55	PRIMARY KEY (resource_id)
56);