1.file --> new model --> Physical_Data_Model
[img]http://dl2.iteye.com/upload/attachment/0089/8359/9deb6e0f-9a6d-32c0-b482-7ecbd01f4449.bmp[/img]
2.创建表
[img]http://dl2.iteye.com/upload/attachment/0089/8361/75411d32-3e68-3ca9-81e9-edf52ca552c7.bmp[/img]
3.添加列
[img]http://dl2.iteye.com/upload/attachment/0089/8363/8387addb-8efc-3b98-aa48-9781ea12ef54.bmp[/img]
4.设置外键
从字表拉到父表
[img]http://dl2.iteye.com/upload/attachment/0089/8365/328dd11b-6750-3075-b260-009896887da4.bmp[/img]
双击连线
[img]http://dl2.iteye.com/upload/attachment/0089/8367/ef83f9e5-81cb-3fe9-a0c9-b8da38e1f769.bmp[/img]
注:有可能会自动给你生成一列并做为外键列,这个时候重新选择一下你要关联的列,自动创建的列自动消失。
5.生成sql脚本
[img]http://dl2.iteye.com/upload/attachment/0089/8369/ff2331e6-c56d-3269-b96d-2b5f91048038.bmp[/img]
[img]http://dl2.iteye.com/upload/attachment/0089/8371/3096f07a-b220-3b94-b952-69fb638785e2.bmp[/img]
[img]http://dl2.iteye.com/upload/attachment/0089/8359/9deb6e0f-9a6d-32c0-b482-7ecbd01f4449.bmp[/img]
2.创建表
[img]http://dl2.iteye.com/upload/attachment/0089/8361/75411d32-3e68-3ca9-81e9-edf52ca552c7.bmp[/img]
3.添加列
[img]http://dl2.iteye.com/upload/attachment/0089/8363/8387addb-8efc-3b98-aa48-9781ea12ef54.bmp[/img]
4.设置外键
从字表拉到父表
[img]http://dl2.iteye.com/upload/attachment/0089/8365/328dd11b-6750-3075-b260-009896887da4.bmp[/img]
双击连线
[img]http://dl2.iteye.com/upload/attachment/0089/8367/ef83f9e5-81cb-3fe9-a0c9-b8da38e1f769.bmp[/img]
注:有可能会自动给你生成一列并做为外键列,这个时候重新选择一下你要关联的列,自动创建的列自动消失。
5.生成sql脚本
[img]http://dl2.iteye.com/upload/attachment/0089/8369/ff2331e6-c56d-3269-b96d-2b5f91048038.bmp[/img]
[img]http://dl2.iteye.com/upload/attachment/0089/8371/3096f07a-b220-3b94-b952-69fb638785e2.bmp[/img]