I'm really a Database design greenhorn. I only do it because we have no one on staff who can do it and the database will be the backend for a application I am writing. The target database is Oracle 9. I've attached a jpg of the ERD. I would appreciate any pointers, suggestions or corrections.
Yes, it is unique. Thanks. The idea is to be able to support any future additional document types in addition to the type represented by the nasageneral table. The database is basically a listing of documents (of a specific type) that have or will be imported into another system. I've updated the model and attached the changes.