UMC week 0
Tables (8)
Announce (공지)
- announce_id — Not Null — Primary key — NOT NULL
- notice_id — Not Null — Foreign key → Notice.notice_id — NOT NULL
- title — Not Null
- text — Not Null
Book (책)
- book_id — Not Null — Primary key — NOT NULL
- title — Not Null
- info — Not Null
- user_id — Not Null — Foreign key → User.user_id — NOT NULL
Category (카테고리)
- book_id — Not Null — Foreign key → Book.book_id — NOT NULL
- SF — Not Null
- romance — Not Null
- science — Not Null
HashTag (해시태그)
- book_id — Not Null — Foreign key → Book.book_id — NOT NULL
- hashtag — Not Null
Marketing (마케팅)
- marketing_id — Not Null — Primary key — NOT NULL
- notice_id — Not Null — Foreign key → Notice.notice_id — NOT NULL
- title — Not Null
- text — Not Null
Notice (알림)
- notice_id — Not Null — Primary key — NOT NULL
Return (책 반납)
- return_id — Not Null — Primary key — NOT NULL
- notice_id — Not Null — Foreign key → Notice.notice_id — NOT NULL
- title — Not Null
- textt (text) — Not Null
User (사용자)
- user_id — Not Null — Primary key — NOT NULL
- name — Not Null
- nickname — Not Null
- call — Not Null
- gender — Not Null
- Kakao_id
- Kakao_email
- Kakao_call
- good — Not Null