 #
 # Table containing individuals.  An individual is a single member of a population.
 #
-#  individual            - PK, unique internal identifier
-#  name                  - name of individual
+#  sample_id             - PK, unique internal identifier
 #  gender                - the sex of this individual
 #  father_individual_id  - self referential id, the father of this individual if known
 #  mother_individual_id  - self referential id, the mother of this individual if known

# of the group of people used in the assay.
#
create table population_structure (
  super_population_id int not null,
  sub_population_id int not null,

  unique(super_population_id, sub_population_id),
  key sub_pop_idx (sub_population_id, super_population_id)
);



# variation_id	- FK to variation table
# allele_1	- One of the alleles of the genotype
# allele_2	- The other allele of the genotype
# sample_id     - foreign key, references individual table

create table individual_genotype_single_bp (
  variation_id int not null,
  allele_1 char,
  allele_2 char,
  sample_id int,

  key variation_idx(variation_id),
  key sample_idx(sample_id)
) MAX_ROWS = 100000000;

#
