34,593
社区成员
发帖
与我相关
我的任务
分享
featureID featureName typeId
1 AAA 100
2 BBB 100
CREATE TABLE caseType (
typeId varchar(50) NOT NULL PRIMARY key ,
typeName varchar(50) NULL,
remark char(18) NULL
)
CREATE TABLE FeatureAttribute (
featureID varchar(50) NOT NULL PRIMARY key ,
featureName varchar(50) NULL,
typeId varchar(50) NULL
)
ALTER TABLE FeatureAttribute
ADD FOREIGN KEY (typeId)
REFERENCES caseType
insert into caseType
select '100','A',''
insert into FeatureAttribute
select '1','AAA','100'
select * from caseType
select * from FeatureAttribute
typeId typeName remark
100 A
featureID featureName typeId
1 AAA 100