[DB] 에브리타임 유저 , 게시판 디비 설계
DROP TABLE IF EXISTS boards; DROP TABLE IF EXISTS users; CREATE TABLE users( u_id SERIAL UNIQUE, user_id VARCHAR NOT NULL, register TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UNIQUE (user_id), PRIMARY KEY (u_id, user_id) ); CREATE TABLE boards( b_id SERIAL, user_id VARCHAR DEFAULT '익명' NOT NULL, title VARCHAR NOT NULL, content TEXT NOT NULL, u_id INTEGER, register TIMESTAMP DEFAULT CURRENT_TIMESTAMP, ..
2022.02.20