@AVINASH KULKARNI 

Hardware CI(s) stored in cmdb_ci_hardware table 

Software CI(s) stored in cmdb_ci_software table

Both the above tables extend the cmdb_ci table, When you run the mid server the discovery tool will take the help of IRE rules defined in the CI class manager and will populate the CI(s) to their respective classes.