sqlquery1.sql

来自「桌面销售管理系统 JDBC的基本应用」· SQL 代码 · 共 25 行

create database Shop

create table Department
(
	D_id int not null primary key identity(1,1),
	D_name varchar(50) not null,
	D_remark varchar(500)
)
create table Employee
(
	E_id int not null primary key identity(1,1),
	D_id int not null references Department(D_id),
	E_name varchar(10) not null,
	E_sex bit,
	E_age int,
	E_tel varchar(20),
	E_address varchar(20)
)
create table Product
(
	P_id int not null primary key identity(1,1),
	P_name varchar(50) not null,
	P_price money,
	P_remark varchar(100)
)