백엔드
테이블 (5)
Book (책)
- Book Id (book_id) — int — 기본 키 — NOT NULL
- Name (name) — varchar(100) — NOT NULL
- URL (url) — varchar(255) — NOT NULL
- Group Id (group_id) — int — 외래 키 → Group.Group Id — NOT NULL
Element (구성요소)
- Text Id (text_id) — int — 기본 키 — NOT NULL
- Element Type (element_type) — enum — NOT NULL
- X Position (x_position) — varchar(100) — NOT NULL
- Y Position (y_position) — varchar(100) — NOT NULL
- Content (content) — text — NOT NULL
- Page Id (page_id) — int — 외래 키 → Page.Page Id — NOT NULL
Group (그룹)
- Group Id (group_id) — int — 기본 키 — NOT NULL
- Name (name) — varchar(100) — NOT NULL
- Color (color) — varchar(100) — NOT NULL
- User Id (user_id) — int — 외래 키 → User.User Id — NOT NULL
Page (페이지)
- Page Id (page_id) — int — 기본 키 — NOT NULL
- Page Number (page_number) — int — NOT NULL
- Book Id (book_id) — int — 외래 키 → Book.Book Id — NOT NULL
User (user)
- User Id (user_id) — int — 기본 키 — NOT NULL
- Kakao Id (kakao_id) — varchar(50) — NOT NULL
- Name (name) — varchar(100) — NOT NULL
- Email (email) — varchar(100) — NOT NULL
- Profile Img Url (profile_img_url) — varchar(255) — NOT NULL