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