firstproject

Tables (5)

Board (게시글)

  • board_id (Key) — Long — Primary key — NOT NULL
  • title (Field2) — String
  • author (Field3) — String
  • content (Field4) — String
  • view (Field5) — int
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL

Comment (댓글)

  • comment_id (Key) — Long — Primary key — NOT NULL
  • content (Field3) — String
  • parent (Field4) — Comment
  • board_id (Key2) — Long — Foreign key → Board.board_id — NOT NULL
  • member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL

Likes (좋아요)

  • likes_id (Key) — Long — Primary key — NOT NULL
  • board_id (Key2) — Long — Foreign key → Board.board_id — NOT NULL
  • member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL

Member (회원)

  • member_id (Key) — Long — Primary key — NOT NULL
  • loginId (Field) — String
  • name (Field2) — String
  • password (Field3) — String
  • role (Field4) — Role
  • provider (Field5) — String
  • providerId (Field6) — String

Notice (알림)

  • notice_id (Key) — Long — Primary key — NOT NULL
  • content (Field3) — String
  • isChecked (Field4) — boolean
  • sender (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • receiver (Key3) — Long — Foreign key → Member.member_id — NOT NULL