Cola-Board
Tables (3)
User (로그인(사용자))
- email (pk) — varchar — Primary key — NOT NULL
- password (Field) — varchar
- author_id (Key) — Foreign key → board.id — NOT NULL
- nickname (key) — int — Foreign key → random_nickname.id — NOT NULL
board (게시판)
- id (Key) — Primary key — NOT NULL
- title (제목) — varchar(50)
- content (내용) — text
- dt_created (작성일) — datetime
- dt_modified (수정일) — datetime
- author_id (작성자) — int
random_nickname (랜덤닉네임)
- id (PK) — int — Primary key — NOT NULL
- nickname (FK) — varchar