MOIDA

Tables (13)

Untitled (Account)

  • Key2 (id) — LONG — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — String
  • Field (username) — String
  • Field (nickname) — String
  • Field (phone) — String
  • Field (profile_Img) — String
  • Field (roles)

Untitled (roles)

  • Key (id) — Primary key — NOT NULL
  • Key2 (user_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL

Untitled (Diary)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (description) — String
  • Field (deleteDate) — String
  • Field (availability)
  • Field (mood) — int
  • Field (diary_Img) — String
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (group_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Group)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — String

Untitled (AccountGroup)

  • Key (id) — Primary key — NOT NULL
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (group_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (follow)

  • Key (id) — Primary key — NOT NULL
  • Key2 (follower_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key2 (follwing_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL

Untitled (Etrash)

  • Key (id) — Primary key — NOT NULL
  • Field (description)
  • Field (mood)
  • Field (music_url)
  • Key (music_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (DiaryEmoji)

  • Key (id) — Primary key — NOT NULL
  • Field (emoji_url)
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (diary_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (music)

  • Key (id) — Primary key — NOT NULL
  • Field (mood)
  • Field (music_url)
  • Field (description)
  • Field (like)
  • Key2 (Account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL

Untitled (GoalPlanner)

  • Key (id) — Long — Primary key — NOT NULL
  • Key2 (host_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Field (subject)
  • Field (limit)
  • Field (password)
  • Field (startDate)
  • Field (endDate)

Untitled (AccountGoalPlanner)

  • Key (id) — Primary key — NOT NULL
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (goalPlanner_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Progress)

  • Key (id) — Primary key — NOT NULL
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (GoalPlanner_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (CheerMessage)

  • Key (id) — Primary key — NOT NULL
  • Field (message)
  • Key2 (account_id) — LONG — Foreign key → Untitled.Key2 — NOT NULL
  • Key (GoalPlanner) — Long — Foreign key → Untitled.Key — NOT NULL