title: Does my MySQL schema make sense? Any recommendations?
body: <p>I need to create a database that stores the following content (about 5,765 entries total): <a href="http://s18.postimg.org/s73exwemf/Capture.jpg" rel="nofollow">http://s18.postimg.org/s73exwemf/Capture.jpg</a></p>
  
  <p>I'm using MySQL Workbench to create my schema. So far I have one table with the following columns:</p>
  
  <p><strong>EPSG Code</strong> (INT) - PK, NN </p>
  
  <p><strong>CRS_NAME</strong> CHAR(50) - UQ</p>
  
  <p><strong>CRS_TYPE</strong> - ENUM('Projected', 'Geographic 2D', 'Geographic 3D', 'Geocentric', 'Vertical', 'Compound')</p>
  
  <p><strong>PROJ_FILE</strong> - CHAR(800)</p>
  
  <hr>
  
  <p>Do my dataypes make sense? Generally, I will retrieve the CRS Name, type and proj file contents using the EPSG code. But sometimes, the only information available may be the CRS name. That's why I made CRS_NAME a unique index.</p>
  
  <p>Does that make sense? I'm new to SQL and I'm enjoying it so far.</p>