북클리

테이블 (10)

AUTHOR

  • author_id — NUMBER
  • author_name — VARCHAR2(100) — NOT NULL
  • author_intro — VARCHAR2(500)

BOOK

  • book_id — NUMBER
  • title — VARCHAR2(200) — NOT NULL
  • author_id — NUMBER
  • category_id — NUMBER
  • description — VARCHAR2(1000)
  • publish_date — DATE

CATEGORY

  • category_id — NUMBER
  • category_name — VARCHAR2(100) — NOT NULL

FAVORITE

  • fav_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • book_id — NUMBER — NOT NULL

PAYMENT

  • pay_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • sub_id — NUMBER — NOT NULL
  • pay_date — DATE
  • pay_amount — NUMBER — NOT NULL

READING_HISTORY

  • history_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • book_id — NUMBER — NOT NULL
  • last_page — NUMBER
  • read_date — DATE

REVIEW

  • review_id — NUMBER
  • user_id — NUMBER — NOT NULL
  • book_id — NUMBER — NOT NULL
  • rating — NUMBER
  • content — VARCHAR2(1000)
  • reg_date — DATE

SUBSCRIPTION

  • sub_id — NUMBER
  • sub_name — VARCHAR2(100) — NOT NULL
  • price — NUMBER — NOT NULL
  • period — NUMBER — NOT NULL

USER

  • user_id — NUMBER
  • user_email — VARCHAR2(100) — NOT NULL
  • user_pw — VARCHAR2(100) — NOT NULL
  • user_name — VARCHAR2(50) — NOT NULL
  • join_date — DATE
  • role — VARCHAR2(20)

사용자 (Untitled)