create table if not exists Land (
	ID int unsigned not null auto_increment,
	Naam varchar(90) not null,
	primary key (ID),
	unique(Naam)
);

create table if not exists Locatie (
	ID int unsigned not null auto_increment,
	LandID int unsigned not null,
	Naam varchar(90) not null,
	primary key (ID),
	foreign key (LandID) references Land(ID),
	unique(Naam)
);

create table if not exists Merk (
	ID int unsigned not null auto_increment,
	Naam varchar(90) not null,
	primary key (ID),
	unique(Naam)
);

create table if not exists Hoofdkantoor (
	ID int unsigned not null auto_increment,
	LocatieID int unsigned not null,
	MerkID int unsigned not null,
	primary key (ID),
	foreign key (LocatieID) references Locatie(ID),
	foreign key (MerkID) references Merk(ID)
);

create table if not exists `Type` (
	ID int unsigned not null auto_increment,
	Naam varchar(90) not null,
	MerkID int unsigned not null,
	Vermogen int unsigned not null,
	primary key (ID),
	foreign key (MerkID) references Merk(ID),
	unique(Naam)
);