독서어플

테이블 (11)

Report (report)

  • report_id (Key) — Long — 기본 키 — NOT NULL
  • review_id (Field6) — Long — NOT NULL
  • reporter_id (Field2) — Long — NOT NULL
  • reported_id (Field3) — Long — NOT NULL
  • report_type (Field) — varchar(255) — NOT NULL
  • description (Field4) — varchar(255) — NOT NULL
  • report_date (Field5) — datetime — NOT NULL
  • isProcessed (blooean) — bit(1) — NOT NULL

Suspend

  • Suspend_Id (Key) — Long — 기본 키 — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL
  • isSuspended (Field) — bit(1) — NOT NULL
  • start_date (Field3) — datetime — NOT NULL
  • end_date (Field2) — datetime — NOT NULL
  • reason (정지사유) — varchar(50) — NOT NULL

User

  • user_Id (Long) — Long — 기본 키 — NOT NULL
  • kakaoId (Field) — Long
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • name — varchar(10) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • birthday — datetime — NOT NULL
  • phone_number — varchar(11) — NOT NULL
  • created_date (create_date) — datetime — NOT NULL
  • modify_date (Field2) — datetime — NOT NULL
  • role_type (Key2) — varchar(255) — 외래 키 → role_info.role_code — NOT NULL

book

  • book_Id (Key) — Long — 기본 키 — NOT NULL
  • isbn13 (Field9) — varchar(255) — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • author (Field2) — varchar(255) — NOT NULL
  • publisher (Field3) — varchar(255) — NOT NULL
  • description (Field4) — varchar(255) — NOT NULL
  • buy_link (Field5) — varchar(255) — NOT NULL
  • image_link (Field6) — varchar(255) — NOT NULL
  • category_id (Field10) — varchar(255) — NOT NULL
  • category_name (Field8) — varchar(255) — NOT NULL

event (Untitled2)

  • event_id (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • start_date (Field3) — datetime — NOT NULL
  • end_date (Field4) — datetime — NOT NULL
  • image_link (Field5) — varchar(255) — NOT NULL

level_info (Untitled)

  • level_Id (Key) — Long — 기본 키 — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL
  • level (Field2) — int(10) — NOT NULL
  • level_count (Field) — int(10) — NOT NULL

profile

  • profile_Id (Key) — Long — 기본 키 — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL
  • upload_name (Field2) — varchar(255) — NOT NULL
  • original_name (Field) — varchar(255) — NOT NULL
  • iamge_url (Field3) — varchar(255) — NOT NULL

review

  • review_Id (Key) — Long — 기본 키 — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL
  • book_Id (Key2) — Long — 외래 키 → book.book_Id — NOT NULL
  • nickname (Field5) — varchar(255) — NOT NULL
  • content (Field) — varchar(50) — NOT NULL
  • star_rating (Field2) — Double — NOT NULL
  • created_date (Field3) — datetime — NOT NULL
  • modify_date (Field4) — datetime — NOT NULL

role_info (Untitled3)

  • role_code (Key) — varchar(255) — 기본 키 — NOT NULL
  • role_description (Field) — varchar(255) — NOT NULL

support (Untitled5)

  • supprot_id (Key) — Long — 기본 키 — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL
  • support_type (Field) — varchar(255) — NOT NULL
  • content (Field2) — varchar(255) — NOT NULL
  • request_date (Field3) — LocalDateTime — NOT NULL
  • reply_date (Field6) — LocalDateTime
  • isProcessed (Field4) — bit(1) — NOT NULL
  • reply_content (Field5) — varchar(255) — NOT NULL

wishlist (Untitled4)

  • wishlist_Id (Key) — Long — 기본 키 — NOT NULL
  • book_Id (Key2) — Long — 외래 키 → book.book_Id — NOT NULL
  • user_Id (Long) — Long — 외래 키 → User.user_Id — NOT NULL