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)