[DB]데이터베이스 SQL 제약 조건 5가지/ PRIMARY key /Foreign key/unique/check /deault /코드 포함 복붙 가능
제약 조건 종류 CREATE TABLE userlist( id VARCHAR2(10) CONSTRAINT id_pk PRIMARY key, name varchar2(10) not null ) CREATE TABLE fk_member( code number(2) NOT NULL , id VARCHAR2(20) NOT NULL CONSTRAINT id_fk REFERENCES MEMBER(id) , etc VARCHAR2(10) ) CREATE TABLE userlist( id VARCHAR2(10) CONSTRAINT id_pk PRIMARY key, jumin char(13) not null CONSTRAINT jumin_un unique ) CREATE TABLE ck_Test( NAME VARCHAR..