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