Read-Me-ERD
Tables (13)
BOOK
- book_id — Primary key — NOT NULL
- book_image_id — Foreign key → IMAGE.image_id — NOT NULL
- title
- author
- translator
- link — 구매링크
BOOK_CATEGORY
- category_id — Foreign key → CATEGORY.category_id — NOT NULL
- book_id — Foreign key → BOOK.book_id — NOT NULL
CATEGORY
- category_id — Primary key — NOT NULL
- name — NOT NULL
GROUP
- group_id — Primary key — NOT NULL
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- book_id — Foreign key → BOOK.book_id — NOT NULL
- address
- position
- tag
- capacity
GROUP_USERS
- group_id — Foreign key → GROUP.group_id — NOT NULL
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- profile_img — Foreign key → USER.profile_img — NOT NULL
- is_deleted
- deleted_at
IMAGE
- image_id — Primary key — NOT NULL
- type
- url
LIKE_SHORTFORM
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- shortForm_id — Foreign key → SHORTFORM.shortForm_id — NOT NULL
SHORTFORM
- shortForm_id — Primary key — NOT NULL
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- book_id — Foreign key → BOOK.book_id — NOT NULL
- shortform_image_id — Foreign key → IMAGE.image_id — NOT NULL
- phrase
- title — 숏폼 제목
- content — 숏폼 내용
- tag
- is_deleted
- deleted_at
SHORTFORM_COMMENT
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- shortForm_id — Foreign key → SHORTFORM.shortForm_id — NOT NULL
- book_id — Foreign key → SHORTFORM.book_id — NOT NULL
- shortform_image_id — Foreign key → SHORTFORM.shortform_image_id — NOT NULL
- comment — 댓글 내용
- is_deleted
- deleted_at
USER
- user_id — int — Primary key — NOT NULL — 관리자 식별
- profile_img — Foreign key → IMAGE.image_id — NOT NULL
- account — string — NOT NULL — @read_me, 중복 불가
- nickname — string — NOT NULL
- email
- comment
- social_id
- provider
USER_BOOK
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- book_id — Foreign key → BOOK.book_id — NOT NULL
USER_FAVORITE
- user_id — int — Foreign key → USER.user_id — NOT NULL — 관리자 식별
- category_id — Foreign key → CATEGORY.category_id — NOT NULL