ridi
Tables (3)
ridi_book
- book_code — number — Primary key — NOT NULL — 책
- book_writer_id — varchar2(15) — NOT NULL — 작가
- book_tile — varchar2(300) — NOT NULL — 책
- book_cost — number — 책
- book_count — number — 조회수
- book_GPA — number — 책
- book_content — long — 책
- book_category — varchar2(1000) — 책
- book_cover — varchar2(100) — 책
- book_connect — number — 책
- book_Y_N — char(1) — 연재
- book_update — date — 책
ridi_comment
- comment_writer — varchar2(15) — Primary key — NOT NULL — 댓글
- comment_no — number — NOT NULL — 댓글
- comment_date — date — 댓글
- comment_content — long — 댓글
- comment_rate — number — 책
- comment_like — number — 댓글
- comment_level — number — 댓글
- comment_book_ref — number — 책
- comment_ref — number — 댓글
ridi_member
- member_id — varchar2(15) — Primary key — NOT NULL — 회원
- member_code — number — NOT NULL — 회원
- member_pwd — varchar2( 300 ) — NOT NULL — 회원
- member_name — varchar2( 20 ) — NOT NULL — 회원
- member_no — varchar2(13) — NOT NULL — 회원
- member_age — number — 회원
- member_gender — char( 1 ) — 회원
- member_email — varchar2( 30 ) — 회원
- member_phone — char( 11 ) — NOT NULL — 회원
- member_address — varchar2( 100 ) — 회원
- member_interest — varchar2( 1000 ) — 회원
- member_point — number — 회원
- member_grade — number — 회원
- enrolldate — date — 회원