[DB] 무결성 테이블 만들기 (연습문제)
create table country ( country_id serial primary key, country_name varchar(30) not null ); create table users( user_pk SERIAL, user_id VARCHAR(10) NOT NULL UNIQUE, user_pw varchar not null, user_age NUMERIC(3) NOT NULL, register_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, country_cd SERIAL NOT NULL REFERENCES country(country_id) ON DELETE CASCADE, PRIMARY KEY(user_pk, country_cd) ); CREATE TABLE t..
2022.02.18