todolist

Tables (13)

CATEGORY

  • id — long — Primary key — NOT NULL
  • categoryName — varchar(20)

EMOTION

  • id — long — Primary key — NOT NULL
  • name — varchar(20)

EMOTION_REPLY

  • id — long — Primary key — NOT NULL
  • reply_id — long — Foreign key → REPLY.id — NOT NULL
  • emotion_id — long — Foreign key → EMOTION.id — NOT NULL
  • user_id — long — Foreign key → USER.id — NOT NULL
  • list_id — long — Foreign key → TODOLIST.id — NOT NULL

EMOTION_USER

  • id — long — Primary key — NOT NULL
  • emotion_id (emotioni_id) — long — Foreign key → EMOTION.id — NOT NULL
  • user_id — long — Foreign key → USER.id — NOT NULL
  • list_id — long — Foreign key → TODOLIST.id — NOT NULL

LIKEUSER

  • user_id — long — Foreign key → USER.id — NOT NULL
  • list_id — long — Foreign key → TODOLIST.id — NOT NULL

LIKEUSER_REPLY

  • reply_id — long — Foreign key → REPLY.id — NOT NULL
  • user_id — long — Foreign key → USER.id — NOT NULL

PROJECT

  • id — long — Primary key — NOT NULL
  • projectName — varchar(100)

PROJECT_USER

  • id — long — Primary key — NOT NULL
  • isJoin — boolean
  • project_id — long — Foreign key → PROJECT.id — NOT NULL
  • user_id — long — Foreign key → USER.id — NOT NULL

REPLY

  • id — long — Primary key — NOT NULL
  • content — text
  • user_id — long — Foreign key → USER.id — NOT NULL
  • list_id — long — Foreign key → TODOLIST.id — NOT NULL

TODOLIST

  • id — long — Primary key — NOT NULL
  • listName — varchar(100)
  • listDesc — text
  • createDate — datetime
  • endDate — datetime
  • isCompleted — boolean
  • level — int
  • like — int
  • user_id — long — Foreign key → USER.id — NOT NULL
  • project_id — long — Foreign key → PROJECT.id — NOT NULL
  • category_id — long — Foreign key → CATEGORY.id — NOT NULL
  • id (parent_id) — long — Foreign key → TODOLIST.id — NOT NULL

USER

  • id — long — Primary key — NOT NULL
  • username — varchar(20)
  • password — varchar(20)
  • nickname — varchar(20)
  • email — varchar(30)
  • role — varchar(20)

USER_ROLES

  • id (user_id) — long — Foreign key → USER.id — NOT NULL
  • id (role_id) — long — Foreign key → role.id — NOT NULL

role

  • id — int — Primary key — NOT NULL
  • name — varchar(20)