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