독서어플
테이블 (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