테이블 스크립트 에러
- 작성자 :
- 유*만
- 작성일 :
- 2011-01-10 13:57:17
- 조회수 :
- 2,381
- 구분 :
- 실행환경
- 진행상태 :
- 완료
Q
수정해서 다시 올려주셨으면 합니다.
#HY000Can't create table 'lcndb.comtnbndtdiary' (errno: 150)
----------------------------------------------------
CREATE TABLE `COMTNBNDTDIARY` (
`BNDT_ID` varchar(20) NOT NULL,
`BNDT_DE` char(8) NOT NULL,
`BNDT_CECK_SE` varchar(2) NOT NULL,
`BNDT_CECK_CD` varchar(10) NOT NULL,
`CHCK_STTUS` varchar(1000) DEFAULT NULL,
`FRST_REGISTER_ID` varchar(20) DEFAULT NULL,
`FRST_REGISTER_PNTTM` date DEFAULT NULL,
`LAST_UPDUSR_ID` varchar(20) DEFAULT NULL,
`LAST_UPDUSR_PNTTM` date DEFAULT NULL,
PRIMARY KEY (`BNDT_ID`,`BNDT_DE`,`BNDT_CECK_SE`,`BNDT_CECK_CD`),
CONSTRAINT `FK_COMTNBND_REFERENCE_COMTNBND` FOREIGN KEY (`BNDT_ID`, `BNDT_DE`) REFERENCES `COMTNBNDTMANAGE` (`BNDT_ID`, `BNDT_DE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
#HY000Can't create table 'lcndb.comtnmtgplacefxtrs' (errno: 150)
----------------------------------------------------
CREATE TABLE `COMTNMTGPLACEFXTRS` (
`MTG_PLACE_ID` char(20) NOT NULL,
`FXTRS_CD` varchar(14) NOT NULL,
`QUANTITY` decimal(20,0) NOT NULL,
`FRST_REGISTER_ID` varchar(20) DEFAULT NULL,
`FRST_REGISTER_PNTTM` date DEFAULT NULL,
`LAST_UPDUSR_ID` varchar(20) DEFAULT NULL,
`LAST_UPDUSR_PNTTM` date DEFAULT NULL,
PRIMARY KEY (`MTG_PLACE_ID`,`FXTRS_CD`),
UNIQUE KEY `COMTNMTGPLACEFXTRS_PK` (`MTG_PLACE_ID`,`FXTRS_CD`),
KEY `COMTNMTGPLACEFXTRS_FK2` (`MTG_PLACE_ID`),
CONSTRAINT `FK_COMTNMTG_RELATIONS_COMTNMTG` FOREIGN KEY (`MTG_PLACE_ID`) REFERENCES `COMTNMTGPLACEMANAGE` (`MTG_PLACE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
#HY000Can't create table 'lcndb.comtnbndtdiary' (errno: 150)
----------------------------------------------------
CREATE TABLE `COMTNBNDTDIARY` (
`BNDT_ID` varchar(20) NOT NULL,
`BNDT_DE` char(8) NOT NULL,
`BNDT_CECK_SE` varchar(2) NOT NULL,
`BNDT_CECK_CD` varchar(10) NOT NULL,
`CHCK_STTUS` varchar(1000) DEFAULT NULL,
`FRST_REGISTER_ID` varchar(20) DEFAULT NULL,
`FRST_REGISTER_PNTTM` date DEFAULT NULL,
`LAST_UPDUSR_ID` varchar(20) DEFAULT NULL,
`LAST_UPDUSR_PNTTM` date DEFAULT NULL,
PRIMARY KEY (`BNDT_ID`,`BNDT_DE`,`BNDT_CECK_SE`,`BNDT_CECK_CD`),
CONSTRAINT `FK_COMTNBND_REFERENCE_COMTNBND` FOREIGN KEY (`BNDT_ID`, `BNDT_DE`) REFERENCES `COMTNBNDTMANAGE` (`BNDT_ID`, `BNDT_DE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
#HY000Can't create table 'lcndb.comtnmtgplacefxtrs' (errno: 150)
----------------------------------------------------
CREATE TABLE `COMTNMTGPLACEFXTRS` (
`MTG_PLACE_ID` char(20) NOT NULL,
`FXTRS_CD` varchar(14) NOT NULL,
`QUANTITY` decimal(20,0) NOT NULL,
`FRST_REGISTER_ID` varchar(20) DEFAULT NULL,
`FRST_REGISTER_PNTTM` date DEFAULT NULL,
`LAST_UPDUSR_ID` varchar(20) DEFAULT NULL,
`LAST_UPDUSR_PNTTM` date DEFAULT NULL,
PRIMARY KEY (`MTG_PLACE_ID`,`FXTRS_CD`),
UNIQUE KEY `COMTNMTGPLACEFXTRS_PK` (`MTG_PLACE_ID`,`FXTRS_CD`),
KEY `COMTNMTGPLACEFXTRS_FK2` (`MTG_PLACE_ID`),
CONSTRAINT `FK_COMTNMTG_RELATIONS_COMTNMTG` FOREIGN KEY (`MTG_PLACE_ID`) REFERENCES `COMTNMTGPLACEMANAGE` (`MTG_PLACE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
A
안녕하세요.. 유지만님..
foreign key 테이블 순서 상의 문제로..
순서를 변경하여 가이드에 재반영하였습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
foreign key 테이블 순서 상의 문제로..
순서를 변경하여 가이드에 재반영하였습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
