expert

Tables (5)

comments (Untitled)

  • Key (id) — bigInt — Primary key — NOT NULL
  • Key (todo_id) — bigInt — Foreign key → todos.Key — NOT NULL
  • Key (user_id) — bigInt — Foreign key → users.Key — NOT NULL
  • 내용 (contents) — varChar(50)

logs (Untitled2)

  • Key (id) — bigInt — Primary key — NOT NULL
  • 요청타입 (action) — varChar(50)
  • 유저 고유 식별 (userId) — bigInt
  • 일정 고유 식별 (todoId) — bigInt
  • 생성일자 (createdAt) — LocalDateTime

managers (Untitled3)

  • Key (Id) — bigInt — Primary key — NOT NULL
  • Key (todo_id) — bigInt — Foreign key → todos.Key — NOT NULL
  • Key (user_id) — bigInt — Foreign key → users.Key — NOT NULL

todos (Untitled4)

  • Key (id) — bigInt — Primary key — NOT NULL
  • 제목 (title) — varChar(50)
  • 내용 (contents) — varChar(50)
  • 날씨 (weather) — varChar(50)
  • 댓글리스트 (comments) — List
  • 매니저리스트 (managers) — List
  • Key (user_id) — bigInt — Foreign key → users.Key — NOT NULL

users (Untitled5)

  • Key (id) — bigInt — Primary key — NOT NULL
  • 닉네임 (nickName) — varChar(50)
  • 이메일 (email) — varChar(50)
  • 비밀번호 (password) — varChar(50)
  • 유저권한등급 (userRole) — UserRole(enum)