
那位帮看一下这个数据库代码属于什么数据库阿 然后再帮忙给看看能不能连接 谢谢了
droptableemployeecascade;droptablerewardcascade;droptableuserscascade;droptabletransl...
drop table employee cascade;
drop table reward cascade;
drop table users cascade;
drop table translate cascade;
create table employee(
EmployeeID varchar(6) NOT NULL,
UserName varchar(20) NOT NULL,
Sex varchar(10) NOT NULL,
Branch varchar(40) NOT NULL,
Birthday date NOT NULL,
NativePlace varchar(20) NOT NULL,
Marriage varchar(20) NOT NULL,
IdentityID varchar(18) NOT NULL,
Politics varchar(20) NOT NULL,
Folk varchar(20) NOT NULL,
Education varchar(20) NOT NULL,
Department varchar(40),
GraduateDate date,
University varchar(40),
AccumulateID varchar(20) NOT NULL,
AdministrationLevel varchar(20) NOT NULL,
Duty varchar(40) NOT NULL,
Position varchar(40) NOT NULL,
ForeignLanguage varchar(20),
FLLevel varchar(20),
ComputerLevel varchar(20),
Phone varchar(20),
MobilePhone varchar(11),
Address varchar(50) NOT NULL,
Incumbency varchar(20) NOT NULL,
IncumbencyType varchar(20) NOT NULL,
Resume varchar(400),
constraint employee_pkey primary key (EmployeeID)
);
create table reward(
RewardNO int NOT NULL,
EmployeeID varchar(6) NOT NULL,
Position varchar(20) NOT NULL,
RewardPunish varchar(10) NOT NULL,
Rewardcontent varchar(50) NOT NULL,
Reason varchar(100) NOT NULL,
Branch varchar(40) NOT NULL,
HandleName varchar(20) NOT NULL,
StartDate date NOT NULL,
CancelDate date,
CancelReason varchar(100),
Remark varchar(400),
constraint reward_pkey primary key (RewardNO),
constraint reward_fkey_EmployeeID foreign key (EmployeeID) references employee(EmployeeID)
);
create table users(
UserName varchar(16) NOT NULL,
Password varchar(16) NOT NULL,
constraint users_pkey primary key (UserName)
);
create table translate(
TranslateNO int NOT NULL,
EmployeeID varchar(6) NOT NULL,
TranslateDate date NOT NULL,
PriorBranch varchar(40) NOT NULL,
NextBranch varchar(40) NOT NULL,
PriorDuty varchar(40) NOT NULL,
NextDuty varchar(40) NOT NULL,
HandleName varchar(20) NOT NULL,
Remark varchar(400),
constraint translate_pkey primary key (TranslateNO),
constraint translate_fkey_EmployeeID foreign key (EmployeeID) references employee(EmployeeID)
);
实在不不懂啊 初涉编程,下了一份东西却不明白,
跪求高人给指点一下,看看这个是什么数据库的,
最好帮忙测试一下
别嫌分数少,真的没有太多几分了 我去弄点让后追加阿
如果我想把这些连接成SQL server数据库 应该添加些什么啊 展开
drop table reward cascade;
drop table users cascade;
drop table translate cascade;
create table employee(
EmployeeID varchar(6) NOT NULL,
UserName varchar(20) NOT NULL,
Sex varchar(10) NOT NULL,
Branch varchar(40) NOT NULL,
Birthday date NOT NULL,
NativePlace varchar(20) NOT NULL,
Marriage varchar(20) NOT NULL,
IdentityID varchar(18) NOT NULL,
Politics varchar(20) NOT NULL,
Folk varchar(20) NOT NULL,
Education varchar(20) NOT NULL,
Department varchar(40),
GraduateDate date,
University varchar(40),
AccumulateID varchar(20) NOT NULL,
AdministrationLevel varchar(20) NOT NULL,
Duty varchar(40) NOT NULL,
Position varchar(40) NOT NULL,
ForeignLanguage varchar(20),
FLLevel varchar(20),
ComputerLevel varchar(20),
Phone varchar(20),
MobilePhone varchar(11),
Address varchar(50) NOT NULL,
Incumbency varchar(20) NOT NULL,
IncumbencyType varchar(20) NOT NULL,
Resume varchar(400),
constraint employee_pkey primary key (EmployeeID)
);
create table reward(
RewardNO int NOT NULL,
EmployeeID varchar(6) NOT NULL,
Position varchar(20) NOT NULL,
RewardPunish varchar(10) NOT NULL,
Rewardcontent varchar(50) NOT NULL,
Reason varchar(100) NOT NULL,
Branch varchar(40) NOT NULL,
HandleName varchar(20) NOT NULL,
StartDate date NOT NULL,
CancelDate date,
CancelReason varchar(100),
Remark varchar(400),
constraint reward_pkey primary key (RewardNO),
constraint reward_fkey_EmployeeID foreign key (EmployeeID) references employee(EmployeeID)
);
create table users(
UserName varchar(16) NOT NULL,
Password varchar(16) NOT NULL,
constraint users_pkey primary key (UserName)
);
create table translate(
TranslateNO int NOT NULL,
EmployeeID varchar(6) NOT NULL,
TranslateDate date NOT NULL,
PriorBranch varchar(40) NOT NULL,
NextBranch varchar(40) NOT NULL,
PriorDuty varchar(40) NOT NULL,
NextDuty varchar(40) NOT NULL,
HandleName varchar(20) NOT NULL,
Remark varchar(400),
constraint translate_pkey primary key (TranslateNO),
constraint translate_fkey_EmployeeID foreign key (EmployeeID) references employee(EmployeeID)
);
实在不不懂啊 初涉编程,下了一份东西却不明白,
跪求高人给指点一下,看看这个是什么数据库的,
最好帮忙测试一下
别嫌分数少,真的没有太多几分了 我去弄点让后追加阿
如果我想把这些连接成SQL server数据库 应该添加些什么啊 展开
2个回答
展开全部
这个仅仅是个SQL语句,大多数支持外键的数据库都可以正常执行上面的SQL
如果想使用mysql来执行的话需要使用innodb类型表
如果想使用mysql来执行的话需要使用innodb类型表

2023-08-15 广告
通常情况下,我们会按照结构模型把系统产生的数据分为三种类型:结构化数据、半结构化数据和非结构化数据。结构化数据,即行数据,是存储在数据库里,可以用二维表结构来逻辑表达实现的数据。最常见的就是数字数据和文本数据,它们可以某种标准格式存在于文件...
点击进入详情页
本回答由光点科技提供
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询