📄 数据库定义.txt
字号:
在查询分析器中输入以下代码：
CREATE DATABASE BasicInfo
//建立入库信息表
use BasicInfo
CREATE TABLE GetintoInformation
(
入库编号 VARCHAR(10) NOT NULL ,
入库物资编号 NUMERIC(10) NOT NULL,
物资名称 VARCHAR(20) NOT NULL,
规格 VARCHAR(20),
类别 VARCHAR(20),
单位 VARCHAR(20),
数量 NUMERIC(6) ,
价格 NUMERIC(6) ,
入库时间 VARCHAR(20) NOT NULL,
经办人 VARCHAR(20) NOT NULL,
仓库号 VARCHAR(20) NOT NULL,
PRIMARY KEY (入库编号)
);
use BasicInfo
INSERT INTO GetintoInformation
VALUES('INAaaa',200601,'钢材','立方形','材料','吨','100',2000,'2005-01-23','Mr Zhang','A');
INSERT INTO GetintoInformation
VALUES('INAaab',200602,'木材','立方形','材料','千克','50',100,'2005-09-21', 'Miss Liu','A');
INSERT INTO GetintoInformation
VALUES('INAaac',200603,'塑料','立方形','材料','千克','200',450,'2005-02-23', 'Mr Zhang','A');
INSERT INTO GetintoInformation
VALUES('INAaad',200604,'泡沫','长方形','材料','千克','600',850,'2005-03-04', 'Mr Peng', 'A');
INSERT INTO GetintoInformation
VALUES('INBbbb',200605,'水果','整箱装','食物','千克','700',1005,'2005-03-14','Mr Zhang','B');
INSERT INTO GetintoInformation
VALUES('INBbbc',200606,'肉食','冷冻','食物','千克','400',652,'2005-04-12','Mr Yang','B');
INSERT INTO GetintoInformation
VALUES('INBbbd',200607,'大米','袋装','食物','吨','625',850,'2005-04-21','Mr Zhang', 'B');
INSERT INTO GetintoInformation
VALUES('INCccc',200608,'面粉','袋装','食物','吨','20',50,'2005-04-21','Mr Zhang','C');
INSERT INTO GetintoInformation
VALUES('INCccd',200609,'小汽车','崭新','交通工具','辆',1,82500,'2005-05-11','Mr Yang','C');
INSERT INTO GetintoInformation
VALUES('INCcce',200610,'三轮车','半新','交通工具','辆','20',6500,'2005-04-23','Mr Yang','C');
INSERT INTO GetintoInformation
VALUES('INCccf',200611,'电焊','半旧','工具','把','90',450,'2005-04-23','Mr Yang', 'C');
INSERT INTO GetintoInformation
VALUES('INCccg',200612,'充气筒','崭新','工具','件','20',850,'2005-05-01','Mr Zhang','C');
//建立出库信息表
use BasicInfo
CREATE TABLE GetoutInformation
(
出库编号 VARCHAR(10) NOT NULL ,
出库物资编号 NUMERIC(10) NOT NULL,
物资名称 VARCHAR(20) NOT NULL,
规格 VARCHAR(20),
类别 VARCHAR(20),
单位 VARCHAR(20),
数量 NUMERIC(6) ,
价格 NUMERIC(6) ,
出库时间 VARCHAR(20) NOT NULL,
经办人 VARCHAR(20) NOT NULL,
仓库号 VARCHAR(20) NOT NULL,
PRIMARY KEY (出库编号)
);
use BasicInfo
INSERT INTO GetoutInformation
VALUES('OUTAaaa',200601,'钢材','立方形','材料','吨','100',2000,'2006-01-23','Mr Zhang','A');
INSERT INTO GetoutInformation
VALUES('OUTAaab',200602,'木材','立方形','材料','千克','50',100,'2006-09-21', 'MissLiu','A');
INSERT INTO GetoutInformation
VALUES('OUTAaac',200603,'塑料','立方形','材料','千克','200',450,'2006-02-23', 'MrZhang','A');
INSERT INTO GetoutInformation
VALUES('OUTAaad',200604,'泡沫','长方形','材料','千克','600',850,'2006-03-04', 'Mr Peng','A');
INSERT INTO GetoutInformation
VALUES('OUTBbbb',200605,'水果','整箱装','食物','千克','700',1005,'2006-03-14','MrZhang','B');
INSERT INTO GetoutInformation
VALUES('OUTBbbc',200606,'肉食','冷冻','食物','千克','400',652,'2006-04-12','Mr Yang','B');
INSERT INTO GetoutInformation
VALUES('OUTBbbd',200607,'大米','袋装','食物','吨','625',850,'2006-04-21','Mr Zhang', 'B');
INSERT INTO GetoutInformation
VALUES('OUTCccc',200608,'面粉','袋装','食物','吨','20',50,'2006-04-21','Mr Zhang','C');
INSERT INTO GetoutInformation
VALUES('OUTCccd',200609,'小汽车','崭新','交通工具','辆',1,82500,'2006-05-11','Mr Yang','C');
INSERT INTO GetoutInformation
VALUES('OUTCcce',200610,'三轮车','半新','交通工具','辆','20',6500,'2006-04-23','MrYang','C');
INSERT INTO GetoutInformation
VALUES('OUTCccf',200611,'电焊','半旧','工具','把','90',450,'2006-04-23','Mr Yang', 'C');
INSERT INTO GetintoInformation
VALUES('OUTCccg',200612,'充气筒','崭新','工具','件','20',850,'2006-05-01','Mr Zhang','C');
//建立余额信息表
use BasicInfo
CREATE TABLE RemainInformation
(
编号 NUMERIC(10) NOT NULL ,
名称 VARCHAR(20) NOT NULL,
规格 VARCHAR(20) NOT NULL,
类别 VARCHAR(20) NOT NULL,
单位 VARCHAR(20) NOT NULL,
剩余数量 NUMERIC(6) NOT NULL,
PRIMARY KEY (编号)
);
use BasicInfo
INSERT INTO RemainInformation
VALUES(200601,'钢材','立方形','材料','吨','90');
INSERT INTO RemainInformation
VALUES(200602,'木材','长方形','材料','千克','170');
INSERT INTO RemainInformation
VALUES(200603,'塑料','立方形','材料','千克','400');
INSERT INTO RemainInformation
VALUES(200604,'泡沫','长方形','材料','千克','800');
INSERT INTO RemainInformation
VALUES(200605,'水果','整箱装','食物','千克','520');
INSERT INTO RemainInformation
VALUES(200606,'肉食','冷冻','食物','千克','320');
INSERT INTO RemainInformation
VALUES(200607,'大米','袋装','食物','吨','980');
INSERT INTO RemainInformation
VALUES(200608,'面粉','袋装','食物','吨','20');
INSERT INTO RemainInformation
VALUES(200609,'小汽车','崭新','交通工具','辆','2');
INSERT INTO RemainInformation
VALUES(200610,'三轮车','半新','交通工具','辆','60');
INSERT INTO RemainInformation
VALUES(200611,'电焊','半旧','工具','把','0');
INSERT INTO RemainInformation
VALUES(200612,'充气筒','崭新','工具','件','3');
//建立需求信息表
use BasicInfo
CREATE TABLE RequestInformation
(
物资编号 VARCHAR(10) NOT NULL,
物资名称 VARCHAR(10) NOT NULL,
单位 VARCHAR(10) NOT NULL,
需求数量 NUMERIC(10),
deadline VARCHAR(10) NOT NULL,
PRIMARY KEY(物资编号)
);
use BasicInfo
INSERT INTO RequestInformation
VALUES(200601, '钢材', '吨', 30, '2006-05-01');
INSERT INTO RequestInformation
VALUES(200602, '木材', '千克',200, '2006-05-11');
INSERT INTO RequestInformation
VALUES(200603, '塑料', '千克',30, '2006-06-21');
INSERT INTO RequestInformation
VALUES(200604, '泡沫', '千克',215, '2006-07-16');
INSERT INTO RequestInformation
VALUES(200605, '水果', '千克',120, '2006-05-28');
INSERT INTO RequestInformation
VALUES(200606, '肉食', '千克',500, '2006-05-08');
INSERT INTO RequestInformation
VALUES(200607, '大米', '吨',30, '2006-05-09');
INSERT INTO RequestInformation
VALUES(200608, '面粉', '吨',11, '2006-06-01');
INSERT INTO RequestInformation
VALUES(200609, '小汽车', '辆',1, '2007-01-01');
INSERT INTO RequestInformation
VALUES(200610, '三轮车', '辆',10, '2006-09-26');
INSERT INTO RequestInformation
VALUES(200611, '电焊', '把',30, '2006-05-02');
INSERT INTO RequestInformation
VALUES(200612, '充气筒', '件',50, '2006-12-22');
//建立基本信息表
use BasicInfo
CREATE TABLE BasicInformation
(
编号 NUMERIC(10) NOT NULL ,
名称 VARCHAR(20) NOT NULL,
规格 VARCHAR(20) NOT NULL,
类别 VARCHAR(20) NOT NULL,
单位 VARCHAR(20) NOT NULL,
数量 NUMERIC(6) NOT NULL,
PRIMARY KEY (编号)
);
use BasicInfo
INSERT INTO BasicInformation
VALUES(200601,'钢材','立方形','材料','吨','100');
INSERT INTO BasicInformation
VALUES(200602,'木材','长方形','材料','千克','200');
INSERT INTO BasicInformation
VALUES(200603,'塑料','立方形','材料','千克','500');
INSERT INTO BasicInformation
VALUES(200604,'泡沫','长方形','材料','千克','1000');
INSERT INTO BasicInformation
VALUES(200605,'水果','整箱装','食物','千克','1000');
INSERT INTO BasicInformation
VALUES(200606,'肉食','冷冻','食物','千克','500');
INSERT INTO BasicInformation
VALUES(200607,'大米','袋装','食物','吨','1000');
INSERT INTO BasicInformation
VALUES(200608,'面粉','袋装','食物','吨','20');
INSERT INTO BasicInformation
VALUES(200609,'小汽车','崭新','交通工具','辆','3');
INSERT INTO BasicInformation
VALUES(200610,'三轮车','半新','交通工具','辆','100');
INSERT INTO BasicInformation
VALUES(200611,'电焊','半旧','工具','把','100');
INSERT INTO BasicInformation
VALUES(200612,'充气筒','崭新','工具','件','20');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -