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)