cheerdo

Tables (7)

Calender (Untitled5)

  • long (calender_id) — Primary key — NOT NULL
  • string (member_id) — Foreign key → Member.string — NOT NULL
  • date (calender_date)
  • double (success_percent)

Friend Relation (Untitled2)

  • Long (id) — Primary key — NOT NULL
  • string (member_id) — Foreign key → Member.string — NOT NULL
  • string (friend_id)
  • tynyint(1) (is_accept)
  • tynyint(1) (post_request)

Habit (Untitled6)

  • long (habit_id) — Primary key — NOT NULL
  • string (member_id) — Foreign key → Member.string — NOT NULL
  • string (content)
  • date (created_date)

Member (Untitled)

  • string (member_id) — Primary key — NOT NULL
  • string (password)
  • string (name)
  • string (bio)
  • Long (coin_count)
  • int (habit_percent)

Post (Untitled3)

  • Long (id) — Primary key — NOT NULL
  • Long (relation_id) — Foreign key → Friend Relation.Long — NOT NULL
  • long (todo_id) — Foreign key → Todo.long — NOT NULL
  • tynyint(1) (is_open)
  • string (title)
  • string(Lob) (content)
  • datetime (send_date)

Post Request (Untitled7)

  • Long (id) — Primary key — NOT NULL
  • Long (relation_id) — Foreign key → Friend Relation.Long — NOT NULL
  • datetime (send_date_time)

Todo (Untitled4)

  • long (todo_id) — Primary key — NOT NULL
  • long (calender_id) — Foreign key → Calender.long — NOT NULL
  • long (habit_id) — Foreign key → Habit.long — NOT NULL
  • string (content)
  • tinyint(1) (is_success)
  • datetime (dead_line_datetime)
  • enum (type)