library

Tables (7)

Book (국내 도서)

  • Key (bookId) — VARCHAR(36) — Primary key — NOT NULL
  • Field (title) — VARCHAR(36)
  • Field2 (author) — VARCHAR(36)
  • Field3 (publisher) — VARCHAR(36)
  • Field4 (ISBN) — VARCHAR(36)
  • Field

Emotion (감정)

  • Key (emotionId) — VARCHAR(36) — Primary key — NOT NULL
  • Field (emotionName) — VARCHAR(36)
  • Field

Emotion Tag (감정 태그)

  • Key (tagId) — VARCHAR(36) — Primary key — NOT NULL
  • Field (tagName) — VARCHAR(36)
  • Field2 (emotionId) — VARCHAR(36)
  • Field

Notice (공지사항)

  • noticeId — VARCHAR(36) — Primary key — NOT NULL
  • noticePw (공지사항 비밀번호) — VARCHAR(36)
  • noticeTitle (공지사항 제목) — VARCHAR(36)
  • noticeContent (공지사항 내용) — VARCHAR(36)
  • noticeImg (공지사항 이미지) — VARCHAR(36)
  • noticeCreatedAt (공지사항 생성일) — DATE
  • noticeDeletedAt (공지사항 삭제일) — DATE
  • noticeFile (공지사항 파일) — VARCHAR(36)
  • Field

Searching (도서검색)

  • Key (searchId) — VARCHAR(36) — Primary key — NOT NULL
  • Field (memberId) — VARCHAR(36)
  • Field2 (keyword) — VARCHAR(36)
  • Field3 (searchTime) — TIMESTAMP
  • Field

User (회원)

  • Key (userId) — VARCHAR(36) — Primary key — NOT NULL
  • Field (userName) — VARCHAR(36)
  • Field2 (userPassword) — VARCHAR(36)
  • Field (userEmail) — VARCHAR(36)
  • Field (userAddress) — VARCHAR(36)
  • Field (userType) — byte
  • Field (userCreatedAt) — DATE
  • Field (userDeletedAt) — DATE
  • Field (userNickname) — VARCHAR(36)
  • Field (userImage) — VARCHAR(36)
  • Field

User Emotion (회원 감정 태그)

  • Key (userTagId) — VARCHAR(36) — Primary key — NOT NULL
  • Key (userId) — VARCHAR(36) — Foreign key → User.Key — NOT NULL
  • Field (tagId) — VARCHAR(36)
  • Field