/* 
This is the database creation script for the Turtle Tracking System reference application.
This script was developed to create the database using Java DB (aka Derby)
*/

create table TTS.Breed(
  breed_code varchar(4) not null,
  breed_name varchar(30) not null,
  primary key(breed_code)
);

create table TTS.Location (
   location_code varchar (4) not null,
   location_name varchar(20) not null,
   location_latitude int,
   location_longitude int,
   primary key(location_code)
);

create table TTS.Specimen (
   specimen_id int NOT NULL GENERATED ALWAYS AS IDENTITY,
   specimen_weight int,
   specimen_length int,
   specimen_health varchar(2),
   breed_code varchar(4) not null,
   location_code varchar(4) not null,
   primary key(specimen_id)
);