alter table1 [SQLD] SQL기본_DDL /* 선수 정보 */CREATE TABLE PLAYER ( PLAYER_ID CHAR (7) NOT NULL , PLAYER_NAME VARCHAR2 (20) NOT NULL , TEAM_ID CHAR (3) NOT NULL , BIRTH_DATE DATE , WEIGHT NUMBER (3) , CONSTRAINT PLAYER_ID_PK PRIMARY KEY (PLAYER_ID) , CONSTRAINT PLAYER_ID_FK FOREIGN KEY (TEAM_ID) REFERENCES TEAM (TEAM_ID) );/* 팀 정보 */CREATE TABLE TEAM ( TEAM_ID CHAR (3) NOT NULL , REGION_NAME VARC.. 2017. 11. 20. 이전 1 다음