create table FixedType (
       constellation     char(4) not null,
       ObjectName        varchar(30) not null,
       ClassCode         enum('D', 'S', 'V'),
       SpectralClass	    char(2),
       hours	            int,
       minutes	          int,
       TimeSec	          int,
       degrees           int,
       AngleSec          int,
       magnitude         float,
       primary key(constellation, ObjectName)
);

create table ClassCodeRef (
       ClassCode     enum('D', 'S', 'V') not null primary key,
       ClassCodeName varchar(255)
);