Project_Empathy

Tables (18)

Book

  • book_seq — number — Primary key — NOT NULL
  • book_title — varchar2(100)
  • book_writer — varchar2(50)
  • book_date — varchar2(30) — 책발행일
  • book_price — number
  • book_likecount — number — 밀리의 서재 참고바람 이 책을 소장한 서재 수 혹은 이책을 좋아요한 유저 수
  • book_content — varchar2(3000)

Event (event)

  • Key (event_seq) — number — Primary key — NOT NULL
  • Field (date) — varchar2(50)
  • Field (event_content) — varchar2(2000)

Event_list (recommendation list)

  • Key (event_list) — varchar2(200) — Primary key — NOT NULL
  • Field

Keyword (keyword)

  • Key (key_seq) — varchar2(50) — Primary key — NOT NULL
  • Field (key_name) — varchar2(200)

Keyword_list (event list)

  • Key (key_seq) — varchar2(50) — Foreign key → Keyword.Key — NOT NULL

Member

  • id — varchar2(50) — Primary key — NOT NULL — member id
  • pw — varchar2(50)
  • email — varchar2(50)
  • name — varchar2(30)
  • display-name — varchar2(50)
  • gender — varchar2(4)
  • address — varchar2(100)
  • phone — number(13)

Message

  • mes_seq — number — Primary key — NOT NULL
  • id — varchar2(20)
  • getter_id — varchar2(20)
  • date — varchar2(20)
  • mes_content

Recommend (Untitled15)

  • rec_seq — number — Primary key — NOT NULL
  • book_seq (book_seq2) — number — Foreign key → Book.book_seq — NOT NULL

Reply (reply)

  • rep_seq — number — Primary key — NOT NULL
  • rev_seq — number
  • id — varchar2(50)
  • date — varchar2(20)
  • rep_content — varchar2(1000)

Reply LIST (Untitled2)

  • rev_seq — number — Foreign key → Review.rev_seq — NOT NULL
  • rep_seq — number — Foreign key → Reply.rep_seq — NOT NULL

Review (review)

  • rev_seq — number — Primary key — NOT NULL
  • book_seq — number
  • id — varchar2(50)
  • date — varchar2(20)
  • rev_title — varchar2(500)
  • rev_content — varchar2(5000)

Review_list (review list)

  • id — varchar2(50) — Foreign key → Member.id — NOT NULL — member id
  • rev_seq — number — Foreign key → Review.rev_seq — NOT NULL

Tag (tag)

  • tag_seq — number — Primary key — NOT NULL
  • tag_content — varchar2(200)

Tag_list (keyword list)

  • tag_seq (tag_seq2) — number — Foreign key → Tag.tag_seq — NOT NULL
  • book_seq (book_seq2) — number — Foreign key → Book.book_seq — NOT NULL

achievement (Untitled)

  • achi_seq — number — Primary key — NOT NULL
  • achi_title — varchar2(200)
  • achi_contemt — varchar2(2000)

achievement list (achievement_list)

  • achi_seq — number — Foreign key → achievement.achi_seq — NOT NULL
  • id — varchar2(50) — Foreign key → Member.id — NOT NULL — member id

message_list (Message list)

  • id — varchar2(50) — Foreign key → Member.id — NOT NULL — member id
  • mes_seq — number — Foreign key → Message.mes_seq — NOT NULL

recommend list (recommend)

  • rec_seq — number — Foreign key → Recommend.rec_seq — NOT NULL
  • id — varchar2(50) — Foreign key → Member.id — NOT NULL — member id