aecmall stands for Advanced ECMall.
ECMall's database use MyISAM engine and so doesn't work with foreign key. I will change the tables' engine to InnoDB add foreign keys to it, and modify the code to working with foreign keys. I will draw a diagram for the database.