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