Stock database
CREATE TABLE csim_stock(
stock_id INT NOT NULL AUTO_INCREMENT,
product_code VARCHAR(24) NULL,
description_1 VARCHAR(45) NULL,
description_2 VARCHAR(45) NULL,
size VARCHAR(35) NULL,
interchange VARCHAR(35) NULL,
model VARCHAR(35) NULL,
brand VARCHAR(35) NULL,
typ VARCHAR(35) NULL,
list_price DECIMAL(7,2) NULL,
sellin_price_A DECIMAL(7,2) NULL,
sellin_price_B DECIMAL(7,2) NULL,
wholesale_price DECIMAL(7,2) NULL,
offer DECIMAL(7,2) NULL,
r1 VARCHAR(20) NULL,
r2 VARCHAR(20) NULL,
r3 VARCHAR(20) NULL,
r4 VARCHAR(20) NULL,
spi DECIMAL(7,2) NULL,
qty_on_hand SMALLINT NULL,
uom VARCHAR(4) NULL,
grup VARCHAR(15) NULL,
location VARCHAR(8) NULL,
min_qty SMALLINT NULL,
reorder_qty SMALLINT NULL,
perorder_qty SMALLINT NULL,
supplier VARCHAR(8) NULL,
last_purchased_price DECIMAL NULL,
submission_date DATE,
index
PRIMARY KEY ( stock_id )
);
Settings
CREATE TABLE csim_settings(
settings_name VARCHAR(20) NOT NULL,
settings_value VARCHAR (100) NOT NULL,
);
