mysql - Android应用程序的数据库设计

Question

我想创建一个 android 应用程序在线销售产品。我需要维护产品及其类别的数据库，如下所示。

 1. category
 2. subcategories
 3. sub subcategories

n级类别。我也想维护 Google play 之类的应用程序评级数据库。
我应该如何设计数据库？

Answer 1

Google Play 的类别和产品结构与此类似:

Apps    Games        Arcade & Action            Flying Simulator            Ingress        Brain & Puzzle            The Room            The Room Two            Where's My Water?            Cut the Rope    Business        OfficeSuite Por 7        Docs To Go Premium KeyBooks    Arts & Entertainment        Art            Wuthering Heights

创建以下内容:

Table: categoryColumns: category_id, category_name, parent_category_idTable: productColumns: product_id, product_nameTable: category_productColumns: category_product_id, product_id, category_id

并插入数据如下:

分类表:

1, Apps, null2, Games, 13, Arcade & Action, 24, Brain & Puzzle, 25, Business, 17, Books, null8, Arts & Entertainment, 79, Art, 8

产品表:

100, Flying Simulator101, Ingress102, The Room103, The Room Two104, Where's My Water?105, Cut the Rope106, OfficeSuite Por 7107, Docs To Go Premium Key108, Wuthering Heights

类别_产品:

1000, 100, 31001, 101, 31002, 102, 41003, 103, 41004, 104, 41005, 105, 41006, 106, 51007, 107, 51008, 108, 9

您可以对评分做同样的事情。创建一个product_rating 表。