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