powerdesigner的一个简单问题
我用powerdesigner的逻辑模型设计了一套数据表,现在把它生成mssql的物理模型并准备生成sql文档导出,但是导出sql脚本的时候程序报错
aborted due to errors detected during the verification of the model.
在result list里显示
check model里显示
Checking package ...
- Circular references
- Constraint name uniqueness
Error The following objects do not have unique constraint names:
-> Reference 'Relationship_22'
-> Reference 'Relationship_32'
-> Reference 'Relationship_23'
-> Reference 'Relationship_24'
- Constraint name maximum length
- Circular dependencies
- Shortcut code uniqueness
Checking table ...
- Table name uniqueness
- Table code uniqueness
- Table name maximum length
- Table code maximum length
- Existence of column
- Existence of index
Warning The following table has no index:
-> Table '工资考勤月表'
-> Table '多语言表'
-> Table '语种表'
-> Table '翻译表'
- Existence of key
Warning The following table has no key:
-> Table '工资考勤月表'
-> Table '多语言表'
-> Table '语种表'
-> Table '翻译表'
- Number of auto-incremented columns
- Existence of reference
Warning The following table has no reference:
-> Table '指标表'
-> Table '消息表'
- Table mapping not defined
- Column mapping not defined
- Clustered key uniqueness
Checking column of table
- Column name uniqueness
- Column code uniqueness
- Column code maximum length
- Domain divergence
- Column mandatory
- Detect inconsistencies between check parameters
- Precision > Maximum Length
- Undefined data type
- Foreign key column data type divergence
- Foreign key column constraint divergence
- Column with sequence not in a key
- Auto-incremented column with data type not numeric
- Missing computed column expression
Checking index of table
- Index name uniqueness
- Index code uniqueness
- Index code maximum length
- Existence of index column
- Table index column count
- Index inclusion
Checking key of table
- Key name uniqueness
- Key code uniqueness
- Key code maximum length
- Existence of column
- Key inclusion
- Multi-column key has sequence column
Checking reference ...
- Reference name uniqueness
- Reference code uniqueness
- Reflexive and mandatory reference
- Existence of reference join
Error The following reference has no reference join:
-> Reference 'Relationship_23'
-> Reference 'Relationship_23'
-> Reference 'Relationship_24'
- Reference code maximum length
- Incomplete join
- Join order
7 error(s), 10 warning(s).
The Physical Data Model is incorrect, there are 7 errors.
不知道出了什么问题,因为当生成物理模型的时候我没有选择生成数据库时是没有出现错误的
请各位指教