App logicstics & changes due to scope creep
        Posted  
        
            by Kevin Brown
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Kevin Brown
        
        
        
        Published on 2010-05-11T23:18:34Z
        Indexed on 
            2010/05/11
            23:24 UTC
        
        
        Read the original article
        Hit count: 331
        
I started an app that was initially a testing platform--user management, and managers that can view their employees tests.
Recently, functionality has been extended (not built yet) to allow users to complete a test in place of an employee--basically adding a record, but no user.
I have three tables in use for this: users(contains user info for login/security), profiles (all personal info: address, height, etc.), and survey (contains survey answers for user).
How do I extend my application to encompass this functionality with minimal change to the structure?
I assume that the best way to do this would be to insert records to the tables profiles and survey, and have no username/password/email? There MUST be a user_id associated b/c the tables are linked through the user_ids...
© Stack Overflow or respective owner