daily_erd

Tables (6)

Book (Untitled2)

  • 도서ID (도서이름) — bigint — Primary key — NOT NULL
  • 도서이름 (book_name) — varchar(100)

Like (Untitled6)

  • 좋아요ID (like_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
  • 게시글ID (post_id) — bigint — Foreign key → Post.게시글ID — NOT NULL
  • 유저ID (user_id2) — bigint — Foreign key → Post.유저ID — NOT NULL
  • 생성일 (created_at) — datetime

Member (Untitled)

  • 멤버ID (member_id) — bigint — Primary key — NOT NULL — 회원의 고유 id
  • 멤버이름 (member_name) — varchar(100) — 유저 이름

Post (Untitled5)

  • 게시글ID (post_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
  • 게시글제목 (title) — varchar(255)
  • 게시글작성자ID (author_id) — bigint

Rental (Untitled3)

  • 대여기록ID (rental_id) — bigint — Primary key — NOT NULL
  • 멤버ID (member_id2) — bigint — Foreign key → Member.멤버ID — NOT NULL — 회원의 고유 id
  • 도서ID (도서이름) — bigint — Foreign key → Book.도서ID — NOT NULL
  • 대여일 (created_at) — datetime — 대여한 날짜

User (Untitled4)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL
  • 유저이름 (user_name) — varchar(100)