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