数据库设计概念

users         departments     sub-departments
-------       -------         -------
id            id              id
name          name            name
email
password
created
modified

posts         photos        profiles
-------       -------       -------
id            thumbnail     id
content       large         photo_id
created       created       user_id
user_id       profile_id    department_id
profile_id    id            sub-department_id

users have one department
users have one sub-department
users have many posts
users have one photo
users have one profile

CakePHP 我的个人资料模型片段如下:

var $belongsTo = array('User', 'Department', 'Sub_Department', 'Photo')
var $hasMany = array('Comment');

如果你现在在想“WTF是垃圾吗?”。我就在你身边。这个协会从事脚手架工作。但我不想在真正开始插入逻辑时遇到麻烦。

我在这一点上有点迷失了。任何帮助都将不胜感激。你会如何实施这一点?