create table switch
(
id_switch integer(5) not null auto_incremente,
nom_switch varchar(15) ,
constraint pk_switch primary key (id_switch)
);
create table operstatus
(
id_oper integer(5) not null auto_incremente,
operstatus varchar(15) ,
constraint pk_operstatus primary key (id_oper)
);
create table vitesse
(
id_vitesse integer(5) not null auto_incremente,
vitesse varchar(15) ,
constraint pk_vitesse primary key (id_vitesse)
);
create table etat_admin
(
id_admin integer(5) not null auto_incremente,
etat_admin varchar(15) ,
constraint pk_etat_admin primary key (id_admin)
);
create table mode
(
id_mode integer(5) not null auto_incremente,
mode varchar(15) ,
constraint pk_mode primary key (id_mode)
);
create table port
(
id_port integer(5) not null auto_incremente,
port varchar(15) ,
id_switch integer(5) not null,
id_oper integer(5) not null,
id_vitesse integer(5) not null,
id_etat_admin integer(5) not null,
id_mode integer(5) not null,
constraint pk_port primary key (id_port),
constraint fk_port_switch foreign key (id_switch) references switch (id_switch),
constraint fk_operstatus_port foreign key (id_oper) references operstatus (id_oper),
constraint fk_vitesse_port foreign key (id_vitesse) references vitesse (id_vitesse),
constraint fk_etat_admin_port foreign key (id_admin) references etat_admin (id_admin),
constraint fk_mode_port foreign key (id_mode) references mode (id_mode)
);
create table mac
(
id_mac integer(5) not null auto_incremente,
adresse_mac varchar(15) ,
id_port integer(5) not null,
constraint pk_mac primary key (id_mac),
constraint fk_mac_port foreign key (id_port) references port (id_port)
);
Partager