modu

Tables (7)

Authority (권한)

  • 권한ID (AUTH_ID) — enum(User,Admin) — Primary key — NOT NULL
  • 인덱스 (Index)

BookMarks (북마크)

  • 북마크_ID (BookMarks_ID) — Primary key — NOT NULL
  • 게시글_ID (Board_Id) — Foreign key → board.게시글_ID — NOT NULL
  • 유저_ID (User_Id) — Foreign key → Members.유저_ID — NOT NULL

Category (카테고리)

  • 카테고리_ID (CATEGORY_ID) — Enum(Food..etc) — Primary key — NOT NULL

File (Untitled4)

  • 파일_ID (File_Id) — Primary key — NOT NULL
  • 게시글_ID (Board_Id) — Foreign key → board.게시글_ID — NOT NULL
  • 카테고리_ID (CATEGORY_ID) — Enum — Foreign key → board.카테고리_ID — NOT NULL
  • 이미지 (images)

Members (유저)

  • 유저_ID (User_Id) — Primary key — NOT NULL
  • 권한ID (AUTH_ID) — Foreign key → Authority.권한ID — NOT NULL
  • 로그인ID (LOGIN_ID) — 카카오이메일
  • 이름 (NAME) — 이메일('@')
  • 수정일자 (ModifiedDate)
  • 생성일자 (CreateDate)

board (게시글)

  • 게시글_ID (Board_Id) — Primary key — NOT NULL
  • 카테고리_ID (CATEGORY_ID) — Enum — Foreign key → Category.카테고리_ID — NOT NULL
  • 유저_ID (User_Id) — Foreign key → Members.유저_ID — NOT NULL
  • 제목 (Title)
  • 내용 (Content)
  • 조회수 (view_count)
  • 작성일자 (CreateDate)
  • 수정일자 (ModifideDate)
  • 별점 (Field)
  • 북마크 (BookMarks)

comment (댓글)

  • 댓글_ID (Key) — Primary key — NOT NULL
  • 유저_ID (User_Id) — Foreign key → Members.유저_ID — NOT NULL
  • 권한ID (AUTH_ID2) — Foreign key → Members.권한ID — NOT NULL
  • 게시글_ID (board_Id) — Foreign key → board.게시글_ID — NOT NULL
  • 카테고리_ID (CATEGORY_ID) — Enum — Foreign key → board.카테고리_ID — NOT NULL
  • 댓글_내용 (content)
  • 만든날짜 (createDate) — (?)
  • Field