백엔드

테이블 (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