我对dynamoDb还不熟悉,我正在尝试掌握它的窍门,但我不知道如何在单表dynamoDb中存储“master”表的详细信息。
例如,以这个电影数据库为例。
category table(refer this as a master table)
+----+----------+
| id | category |
+----+----------+
| 1 | thriller |
+----+----------+
| 2 | horror |
+----+----------+
| 3 | romantic |
+----+----------+
movie table (category_id is FK)
+----+-----------+-------------+
| id | name | category_id |
+----+-----------+-------------+
| 1 | gone girl | 1 |
+----+-----------+-------------+
| 2 | get out | 1 |
+----+-----------+-------------+
| 3 | seven | 1 |
+----+-----------+-------------+
| 4 | us | 2 |
+----+-----------+-------------+
| 5 | it | 2 |
+----+-----------+-------------+
如何在dynamoDb中建模,如果我想得到所有可能的类别,查询会是什么。想想看电影桌上没有更多的Fk了。