title: table creating regarding social networking post
body: <p>I want to design structure for posting image,video,url, audio,text etc for users.</p>
  
  <p>I have create</p>
  
  <pre><code>CREATE TABLE users (
      userID INT NOT NULL AUTO_INCREMENT,
      firstName VARCHAR(50),
      lastName VARCHAR(50),
      password CHAR(32),
      PRIMARY KEY (userID)
  );
  
  
   CREATE TABLE post(
             postID INT NOT NULL AUTO_INCREMENT,
             message VARCHAR(200)
          PRIMARY KEY (postID));
  </code></pre>
  
  <p>MY question is should I design different tables for storing image,video,url etc</p>
  
  <p>like 
  Image table</p>
  
  <pre><code>CREATE TABLE post_image(
                 imageID INT NOT NULL AUTO_INCREMENT,
                 imgPATH VARCHAR(200)
              PRIMARY KEY (imageID));
  </code></pre>
  
  <p>same of video,link etc.</p>
  
  <p>Or it can be done only in single table.</p>