teamProject
테이블 (7)
리뷰게시판 (novel_review_board)
- review_seq — int — 기본 키 — NOT NULL
- review_content (review_cotent) — vachar(2000)
- review_date — datetime
- review_ip — varchar(15)
- review_star_grade — int
소설정보 (novel_information)
- novel_seq — int — 기본 키 — NOT NULL
- novel_genre — varchar(20)
- novel_title — varchar(100)
- novel_writer — varchar(20)
- novel_img — varchar(500)
- novel_content — varchar(2000)
- platform_series — varchar(500)
- platform_kakao — varchar(500)
- platform_ridi — varchar(500)
요청리스트 (novel_orgin_request)
- request_seq — int — 기본 키 — NOT NULL
- request_title — varchar(100)
- request_category — varchar(20)
원작소설 (novel_orgin_list)
- orgin_seq — int — 기본 키 — NOT NULL
- orgin_title — varchar(100)
- orgin_webtoon — char(2)
- orgin_drama — char(2)
- orgin_movie — char(2)
커뮤니티 게시글 (novel_free_board)
- free_seq — int — 기본 키 — NOT NULL
- free_category — varchar(20)
- free_subject — varchar(50)
- free_content — varchar(2000)
- free_date — datetime
- free_ip — varchar(15)
- free_hit — int
- 추천 (free_like) — int
커뮤니티 댓글 (novel_free_comment)
- cmt_seq — int — 기본 키 — NOT NULL
- cmt_content — varchar(1000)
- cmt_date — datetime
- cmt_status — varchar(8)
회원정보 (novel_user_information)
- user_seq — int — 기본 키 — NOT NULL
- user_email — varchar(50)
- user_nickname — varchar(30)
- user_password — varchar(30)
- user_gender — char(2)
- user_birth — varchar(10)
- user_cdate — datetime
- user_grade — varchar(10)