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

FOLLOW

    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