Mind Cookie

Tables (6)

Event

  • Key (Pk) — Long — Primary key — NOT NULL
  • Field (날짜) — LocalDateTime
  • Field (참가자들) — List<String
  • Field (무슨일을 했는지) — String
  • Field (감정) — String
  • Field (감정 지표) — byte(0~100)
  • Key — Long — Foreign key → Member.Key — NOT NULL

Hobbit (세부목표)

  • Key — Long — Primary key — NOT NULL
  • Field (날짜) — LocalDateTime
  • Field (완료여부) — boolean
  • Key (PK) — Long — Foreign key → HobbitList.Key — NOT NULL

HobbitList (f)

  • Key (PK) — Long — Primary key — NOT NULL
  • Field (목표) — String
  • Field (상위목표) — String
  • Key — Long — Foreign key → Member.Key — NOT NULL

Member

  • Key — Long — Primary key — NOT NULL
  • Field (사건 참가자) — List<String>
  • Field (사건 활동) — List<String
  • Field (사건 감정) — List<String
  • Field (스탑워치목표) — List<String>

State (Untitled)

  • Key — Primary key — NOT NULL
  • Field (날짜) — LocalDateTime
  • Field (긍정감각) — byte(0~100)
  • Field (부정감각) — byte(0~100)
  • Field (삶의 만족도) — byte(0~100)
  • Field (몸상태) — byte(0~100)
  • Key (Key2) — Long — Foreign key → Member.Key — NOT NULL

Stopwatch

  • Key (PK) — Long — Primary key — NOT NULL
  • Field (날짜) — LocalDateTime
  • Field (지속시간) — LocalDateTime
  • Field (목표) — String
  • Key (FK) — Long — Foreign key → Member.Key — NOT NULL