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