代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/340597/3284635
sql patient.sql
USE Hospital
GO
CREATE TABLE Patient
( Id int IDENTITY PRIMARY KEY,
Name varchar(50),
IDNum varchar(30),
Sex varchar(2),
Age int,
Marry varchar(8)
www.eeworm.com/read/340597/3284636
sql medicine.sql
USE Hospital
GO
CREATE TABLE Medicine
( MedId int IDENTITY PRIMARY KEY,
MedName varchar(50),
TypeId int,
UnitId int,
BuyPrice float, --进货价格，计算利润用
SalePrice
www.eeworm.com/read/340597/3284638
sql basetype.sql
USE Hospital
GO
CREATE TABLE BaseType
(Id int PRIMARY KEY IDENTITY,
TypeId tinyint,
TypeName varchar(30)
)
GO
www.eeworm.com/read/340597/3284641
sql payitems.sql
USE Hospital
GO
CREATE TABLE PayItems
( PayId int IDENTITY PRIMARY KEY,
RegId int, -- 登记编号
ItemId int, -- 收费项目编号
PNum int, -- 收费数量
Price float,-- 销售价格
PType
www.eeworm.com/read/340597/3284642
sql doctor.sql
USE Hospital
GO
CREATE TABLE Doctor
( Id int IDENTITY PRIMARY KEY,
Name varchar(50) NOT NULL,
Sex varchar(2) NOT NULL,
Age int,
DeptId int,
Title varchar(50)
www.eeworm.com/read/340597/3284643
sql items.sql
USE Hospital
GO
CREATE TABLE Items
( ItemId int IDENTITY PRIMARY KEY,
ItemName varchar(50) NOT NULL,
Total int,
UnitId int,
BuyPrice float,
SalePrice float
www.eeworm.com/read/340597/3284644
sql registration.sql
USE Hospital
GO
CREATE TABLE Registration
( RegId int PRIMARY KEY,
PatId int,--患者
DocId int, --医生名称
RegDate varchar(20), --日期
UserName varchar(20) --用户名
)
GO
www.eeworm.com/read/340597/3284647
sql users.sql
USE Hospital
GO
CREATE TABLE Users
(UserName varchar(40) PRIMARY KEY,
Pwd varchar(40) NOT NULL,
User_Type tinyint NOT NULL
)
GO
INSERT INTO Users Values('Admin', '888888', 1)
GO
www.eeworm.com/read/340102/3291837
sql wsms.sql
/*==============================================================*/
/* Database name: WSMS */
/* DBMS name: ORACLE Version 9i