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)