DB.sql

drop database if exists AffiliateMarketing;
create database AffiliateMarketing;
use AffiliateMarketing;

create table UserData(
	UserDataId int auto_increment primary key,
	Username varchar(20) unique,
	UserPassword varchar(255),
	FirstName varchar(30),
	LastName varchar(30),
	EMail varchar(30) unique,
	Country varchar(14),
	PhoneNr varchar(15),
	BirthDate Date,
    Balance decimal(9, 2) DEFAULT '0.00'
);

create table URLs(
	UrlId int auto_increment primary key,
	AmountPerClick decimal(5,2),
	Company varchar(20),
	Category varchar(20),
	UrlValue varchar(200),
	MaxNumClick int,
	ContentInfo varchar(300),
	fk_UserDataId int,
	foreign key (fk_UserDataId) references UserData(UserDataId)
);

create table TrackLinks(
	TrackLinksId int auto_increment primary key,
	TrackingCode varchar(19) unique,
	Visits int,
	fk_UserDataId int,
	fk_UrlId int,
	foreign key (fk_UserDataId) references UserData(UserDataId),
	foreign key (fk_UrlId) references URLs(UrlId)
);

create table BankData(
	BankDataId int auto_increment primary key,
	IBAN varchar(34),
	BIC varchar(8),
	fk_UserDataId int,
	foreign key (fk_UserDataId) references UserData(UserDataId)
);