 #
 
 create table individual(
-  individual_id int not null auto_increment,
-  name varchar(255) not null,
-  description varchar(255) not null,
+  sample_id int not null,
   gender enum('Male', 'Female', 'Unknown') default 'Unknown' NOT NULL,
   father_individual_id int,
   mother_individual_id int,
   
-  primary key(individual_id),
-  key name_idx (name)
-);
-
+  primary key(sample_id)
+);
 
 
 

create table allele_group(
	allele_group_id int not null auto_increment,
	variation_group_id int not null,
	population_id int,
	name varchar(255),
	source_id int,
	frequency float,

# allele_1 - first allele in the genotype
# allele_2 - second allele in the genotype
# frequency - frequency of the genotype in the population
# sample_id - foreign key, references population table
#

create table population_genotype (
