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 — 회원