Mentors_ERD

Tables (7)

banword (금지어 테이블)

  • id (Key) — int — Primary key — NOT NULL
  • words (Field) — varchar — Primary key
  • user_author_email (Field3) — varchar — Foreign key → board.user_author_email
  • id (pk2) — Foreign key → board.tag_id

board (글)

  • id (pk) — int — Primary key — NOT NULL
  • user_author_email (Field3) — varchar — Foreign key → user(NN).email
  • ban_words (fk) — varchar — Foreign key → banword.words
  • tag_id (pk2) — Foreign key → tag.id
  • nickname_author (Field7) — varchar
  • title (Field1) — varchar
  • content (Field2) — varchar
  • dt_create (Field4) — varchar
  • dt_modify (Field5) — datetime
  • like (Field6) — int
  • image (Field8) — image

comment (댓글)

  • id (pk) — Primary key — NOT NULL
  • id_nickname (pk, fk) — int — Foreign key → user(NN).id_nickname — NOT NULL
  • board_id (pk2) — int — Foreign key → board.id — NOT NULL
  • id (pk22) — Foreign key → board.tag_id
  • content (Field) — varchar

like (하트)

  • user_email (pk) — varchar — Foreign key → user(NN).email
  • board_id (.) — int — Foreign key → board.id — NOT NULL
  • id (pk2) — Foreign key → board.tag_id

nicknames(NN) (닉네임)

  • id (pk,) — int — Primary key — NOT NULL
  • names (Field) — varchar

tag (태그 기반 조회 (M:N))

  • id (pk) — Primary key
  • content (.) — varchar — NOT NULL

user(NN) (유저)

  • email (Field) — varchar — Primary key
  • id_nickname (pk, fk) — int — Foreign key → nicknames(NN).id — NOT NULL
  • password (Field2) — varchar
  • id (pk) — int — NOT NULL