덕재

테이블 (8)

board (Untitled2)

  • board_id (Key) — 기본 키 — NOT NULL
  • created_at (Field)
  • content (Field2)
  • title (Field3)
  • user_id (Key3) — 외래 키 → user.user_id — NOT NULL
  • kind_id (Key2) — 외래 키 → kind.kind_id — NOT NULL

board_like (Untitled4)

  • board_like_id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → user.user_id — NOT NULL
  • board_id (Key3) — 외래 키 → board.board_id — NOT NULL

category (Untitled10)

  • catgegory_id (Key) — 기본 키 — NOT NULL
  • category_name (Field)
  • kind_id (Key2) — 외래 키 → kind.kind_id — NOT NULL

comment (Untitled3)

  • comment_id (Key) — 기본 키 — NOT NULL
  • content (Field)
  • created_at (Field3)
  • user_id (Key2) — 외래 키 → user.user_id — NOT NULL
  • board_id (Key3) — 외래 키 → board.board_id — NOT NULL

comment_like (Untitled6)

  • comment_like_id (Key) — 기본 키 — NOT NULL
  • comment_id (Key2) — 외래 키 → comment.comment_id — NOT NULL
  • board_like_id (Key3) — 외래 키 → board_like.board_like_id — NOT NULL

image (Untitled5)

  • image_id (Key) — 기본 키 — NOT NULL
  • board (Field)
  • url (Field2)
  • board_id (Key2) — 외래 키 → board.board_id — NOT NULL

kind (Untitled9)

  • kind_id (Key) — 기본 키 — NOT NULL
  • kind_name (Field)

user (Untitled)

  • user_id (Key) — 기본 키 — NOT NULL
  • id (Field)
  • password (Field2)
  • nickname (Field6)