current structure for database

innoDB engine is applied. ( not sure what it is for. just for reference
in further extension_