This Oracle SQL query keeps giving me errors and I can't seem to fix it. Please how and what to do to fix it? create tab
Posted: Sat Nov 27, 2021 2:43 pm
This Oracle SQL query keeps giving me errors and I can't seem to
fix it. Please how and what to do to fix it?
create table Account
(
UserName varchar (15) primary key,
Password varchar(10) not null,
Phone number (10) not null,
Email varchar (30) not null
);
create table Region
(
RegionID varchar (15) primary key,
local varchar(10) not null,
WorldWide varchar(10) not null
);
create table Character
(
CharName varchar(10) primary key,
Lvl num(2) not null,
User_Name varchar(15) not null,
constraint fk_UN foreign key (User_Name) references Account
(UserName)
Type varchar(10) not null,
HP number (5) not null,
MP number (5) not null,
Region_ID varchar (15) not null,
constraint fk_RI foreign key (Region_ID) references Region
(RegionID)
);
create table Inventory
(
SpaceNum number(10) primary key,
Category varchar(15) not null
);
create table Item
(
ItemName varchar(10) primary key,
ItemType number(10) not null,
ItemDmg number(3) not null,
Space_Num number(10) not null,
constraint fk_SN foreign key (Space_Num) references Inventory
(SpaceNum)
);
create table Map
(
MapID number(10) primary key
);
create table pet
(
petName varchar(10) not null,
PetHP number(3) not null,
attack number(2) not null,
Map_ID number(10) not null,
constraint fk_MI foreign key (Map_ID) references Map (MapID)
);
desc Account;
desc Character;
desc Region;
desc Inventory;
desc Item;
desc Map;
desc pet;
fix it. Please how and what to do to fix it?
create table Account
(
UserName varchar (15) primary key,
Password varchar(10) not null,
Phone number (10) not null,
Email varchar (30) not null
);
create table Region
(
RegionID varchar (15) primary key,
local varchar(10) not null,
WorldWide varchar(10) not null
);
create table Character
(
CharName varchar(10) primary key,
Lvl num(2) not null,
User_Name varchar(15) not null,
constraint fk_UN foreign key (User_Name) references Account
(UserName)
Type varchar(10) not null,
HP number (5) not null,
MP number (5) not null,
Region_ID varchar (15) not null,
constraint fk_RI foreign key (Region_ID) references Region
(RegionID)
);
create table Inventory
(
SpaceNum number(10) primary key,
Category varchar(15) not null
);
create table Item
(
ItemName varchar(10) primary key,
ItemType number(10) not null,
ItemDmg number(3) not null,
Space_Num number(10) not null,
constraint fk_SN foreign key (Space_Num) references Inventory
(SpaceNum)
);
create table Map
(
MapID number(10) primary key
);
create table pet
(
petName varchar(10) not null,
PetHP number(3) not null,
attack number(2) not null,
Map_ID number(10) not null,
constraint fk_MI foreign key (Map_ID) references Map (MapID)
);
desc Account;
desc Character;
desc Region;
desc Inventory;
desc Item;
desc Map;
desc pet;