51,408
社区成员
发帖
与我相关
我的任务
分享Together 6.1的composition关联好象不起作用？？？？？
在UML中，如果两个类建立了composition关联，那么client端类的生命将由supplier端决定。映射到数据库中则是supplier表的OID将作为client表的主键。
但我用together产生MS SQL 2000表时，却不能将supplier表的主键作为client表的主键 ？？！！
regards!
但我用together产生MS SQL 2000表时，却不能将supplier表的主键作为client表的主键 ？？！！
regards!
...全文
请发表友善的回复…
发表回复
IPOz 2003-07-17
- 打赏
- 举报
而且int型属性都会自动加个identity :((((
CREATE TABLE "Department"
(
"depart_id" int identity,
"depart_name" sysname,
CONSTRAINT "PK_Department" PRIMARY KEY ("depart_id")
)
CREATE TABLE "Employee"
(
"emp_id" int identity,
"emp_sex" int identity,
"emp_name" sysname,
"depart_id" int identity,
CONSTRAINT "PK_Employee" PRIMARY KEY ("emp_id")
)
who can help me out?
CREATE TABLE "Department"
(
"depart_id" int identity,
"depart_name" sysname,
CONSTRAINT "PK_Department" PRIMARY KEY ("depart_id")
)
CREATE TABLE "Employee"
(
"emp_id" int identity,
"emp_sex" int identity,
"emp_name" sysname,
"depart_id" int identity,
CONSTRAINT "PK_Employee" PRIMARY KEY ("emp_id")
)
who can help me out?
