There are a total of 26 tables in the 4ppt database. Some are more important than others. Contains a row for each spool of fiber received from Kurary. Includes results from Kurary lot tests. No foreign keys.
Primary key is subspool number.
Each spool of fiber is tested for bumps and has the bumps cut out. This naturally leaves us with several subspools for each spool, of varying lengths. At one point it was felt that these should have their own table. FK to parent spool. This flashes 20 LEDs on a length of fiber, so we saved all 20 light measurements for each spool.