ibconsole에서
에러 메시지가 이렇게 나오는데 어딜 봐야 하는지 몰겠네영....ㅠㅠ
디비 만드는것 부터 순서대로 설명좀 해주세영....ㅠㅠ
Unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_15"
Statement: CREATE TABLE membmer(
cst_id varchar(10) NOT NULL PRIMARY KEY
,cst_idno varchar(15) NOT NULL
,cst_nm varchar(20) NOT NULL
,cst_tel1 varchar(5)
,cst_tel2 varchar(5)
,cst_tel3 varchar(5)
,cst_hp1 varchar(5)
,cst_hp2 varchar(5)
,cst_hp3 varchar(5)
,cst_zip varchar(7)
,cst_adr varchar(100)
,cst_hno varchar(100)
,cst_eml varchar(50)
,cst_sex char(1) default 'F'
,marry_yn char(1) default 'N'
,cst_char varchar(300)
,cst_regcd varchar(4)
,cst_ftycd varchar(7)
,cd_empid varchar(10)
,int_srv varchar(5)
,cst_regdt char(8)
,cst_id varchar(10)
)
|