Need assistance building a Mysql Database

I need assistance building a mysql database help manage 263 network monitors... but i've been running into foreign key Constraint failures issues when trying to import records via csv files using workbench.

The CSV files will be attached

Here is a snippet of my code

CREATE TABLE GSTORMAIN (

GID INT NOT NULL AUTO_INCREMENT,

Hostname VARCHAR(40) NOT NULL,

IPAddress VARCHAR(16) NOT NULL,

serial VARCHAR(20) NOT NULL,

model VARCHAR(5) NULL,

Devicetype VARCHAR(20) NULL,

NumberOfDrives int,

Addr_ID INT,

Status_ID INT,

Supman_ID INT,

CardCap_ID INT,

os_ID INT,

SiteContact_ID INT,

ArecaVer_ID INT,

foreign key (Addr_ID) references Address (Addr_ID),

foreign key (Status_ID) references Gstatus (Status_ID),

foreign key (Supman_ID) references Supervisor (Supman_ID),

foreign key (CardCap_ID) references CaptureCard (CardCap_ID),

foreign key (os_ID) references OperatingSystem (os_ID),

foreign key (SiteContact_ID) references SiteContact (SiteContact_ID),

foreign key (Arecaver_ID) references Arecaver (Arecaver_ID),

PRIMARY KEY (GID)

);

CREATE TABLE Lom (

GID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

LomCardSwitch VARCHAR(50),

LomURL VARCHAR(50),

LomIP VARCHAR(50),

LomGW VARCHAR(50),

LomMASK VARCHAR(50),

FOREIGN KEY (GID) REFERENCES GSTORMAIN (GID)

);

CREATE TABLE Monitor (

GID INT PRIMARY KEY,

TransportSwitch VARCHAR(50),

Monitor1_switch VARCHAR(50),

Monitor2_Switch VARCHAR(50),

Monitor3_switch VARCHAR(50),

Monitor4_switch VARCHAR(50),

Monitor5_switch VARCHAR(50),

Monitor6_switch VARCHAR(50),

Monitor7_Switch VARCHAR(50),

Monitor8_Switch VARCHAR(50),

TrafficCopyMethod VARCHAR(20),

FOREIGN KEY (GID) REFERENCES gstormain (GID)

);

CREATE TABLE WINDOWS_KEYS (

GID INT PRIMARY KEY,

Windows_Product_Keys VARCHAR(50),

FOREIGN KEY (GID) REFERENCES gstormain (GID)

);

Delete Table Sitcontact

CREATE TABLE SiteContact (

SiteContact_ID INT AUTO_INCREMENT,

FirstName VARCHAR(20),

LastName VARCHAR(30),

Phone VARCHAR(12),

PRIMARY KEY (SiteContact_ID)

);

CREATE TABLE OperatingSystem (

OS_ID INT NOT NULL AUTO_INCREMENT,

OperationSys VARCHAR(10),

PRIMARY KEY (os_ID)

);

Create Table Supervisor (

Supman_ID INT NOT NULL AUTO_INCREMENT,

SupportManager VARCHAR(40),

PRIMARY KEY (Supman_ID)

);

Create Table GStatus (

Status_ID INT not null auto_increment,

Status VARCHAR(12),

PRIMARY KEY (Status_ID)

);

I am attaching the CSV files i am trying to import into the tables

Administracija podatkovnih baz Programiranje podatkovnih baz MySQL PHP SQL

ID projekta: #15532391

Več o projektu