BJBJ - ERD for posting
Tables (15)
BookLikes
- Key (book_like_id) — bigInt — Primary key — NOT NULL
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Comment
- Key (comment_id) — bigInt — Primary key — NOT NULL
- Field (comment_grp) — int
- Field (comment_grps) — int
- Field (comment_grpl) — int
- Field (comment_content) — varchar(255)
- Field (created_date) — date
- Key (paragraph_id) — bigInt — Foreign key → Paragraph.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Paragraph
- Key (paragraph_id) — bigInt — Primary key — NOT NULL
- Field (paragraph_content) — varchar(255)
- Field (paragraph_color) — varchar(30)
- Field (created_date) — date
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Review
- Key (review_id) — bigInt — Primary key — NOT NULL
- Field (review_content) — varchar(255)
- Field (review_grade) — int
- Field (created_date) — date
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Scrap
- Key (scrap_id) — bigInt — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
- Key (paragraph_id) — bigInt — Foreign key → Paragraph.Key — NOT NULL
Untitled (UserImg)
- Key (img_id) — bigint — Primary key — NOT NULL
- Field (img_name) — varchar(64)
- Field (img_path) — text
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Untitled (Follow)
- Key (follow_id) — bigInt — Primary key — NOT NULL
- Key (followings) — bigint — Foreign key → User.Key — NOT NULL
- Key (followers) — bigint — Foreign key → User.Key — NOT NULL
Untitled (preferred)
- Key (preffered_id) — bigint — Primary key — NOT NULL
- Field (score) — int
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Untitled (Hashtag)
- Key (hashtag_id) — bigint — Primary key — NOT NULL
- Field (hashtag_name) — text
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
Untitled (Genre)
- Key (genre_id) — bigint — Primary key — NOT NULL
- Field (genre_name) — varchar(16)
Untitled (Author)
- Key (author_id) — bigint — Primary key — NOT NULL
- Field (author_name) — varchar(16)
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (Book)
- Key (book_id) — bigint — Primary key — NOT NULL
- Field (book_isbn) — varchar(16)
- Field (book_title) — varchar(32)
- Field (book_publisher) — varchar(16)
- Field (book_price) — integer
- Field (book_description) — text
- Field (book_score) — float
- Field (book_grade) — float
Untitled (BookImg)
- Key (book_img_id) — bigint — Primary key — NOT NULL
- Field (book_fimg_name) — varchar(64)
- Field (book_fimg_path) — text
- Field (book_bimg_name) — varchar(64)
- Field (book_bimg_path) — text
- Field (book_simg_name) — varchar(64)
- Field (book_simg_path) — text
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (BookGenre)
- Key (book_genre_id) — bigint — Primary key — NOT NULL
- Key (book_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL
User
- Key (user_id) — bigint — Primary key — NOT NULL
- Field (created_date) — datetime
- Field (email) — varchar(64)
- Field (username) — varchar(32)
- Field (nickname) — varchar(32)
- Field (password) — varchar(128)
- Field (type) — int
- Field (role) — varchar(32)
- Field (age) — int
- Field (sex) — int