JY-Planner
Tables (5)
CATEGORY (Untitled3)
- category_id (Category_Id) — Integer — Primary key — NOT NULL
- user_id (User_Id) — Integer — Foreign key → USER.user_id — NOT NULL
- setting_id (Setting_Id) — Integer — Foreign key → USER.setting_id — NOT NULL
- category_name (Category_Name) — varchar(255)
INSIDE_CATEGORY (Untitled4)
- inside_category_id (Inside_Category_Id) — Integer — Primary key — NOT NULL
- category_id (Category_Id2) — Integer — Foreign key → CATEGORY.category_id — NOT NULL
- user_id (User_Id) — Integer — Foreign key → CATEGORY.user_id — NOT NULL
- setting_id (Setting_Id) — Integer — Foreign key → CATEGORY.setting_id — NOT NULL
- inside_category_name (Inside_Category_Name) — varchar(255)
PROJECT (Untitled5)
- project_id (Project_Id) — Integer — Primary key — NOT NULL
- inside_category_id (Inside_Category_Id) — Integer — Foreign key → INSIDE_CATEGORY.inside_category_id — NOT NULL
- category_id (Category_Id2) — Integer — Foreign key → INSIDE_CATEGORY.category_id — NOT NULL
- user_id (User_Id) — Integer — Foreign key → INSIDE_CATEGORY.user_id — NOT NULL
- setting_id (Setting_Id) — Integer — Foreign key → INSIDE_CATEGORY.setting_id — NOT NULL
- project_name (Project_Name) — varchar(255)
- start_point (Start_Point) — DATETIME
- end_point (End_Point) — DATETIME
- is_habbit (Is_Habbit) — boolean
- priority (Priority) — varchar(255)
SETTING (Untitled2)
- setting_id (Setting_Id) — Integer — Primary key — NOT NULL
- quote (Quote) — varchar(255)
- goal (Goal) — varchar(255)
- change (Change) — varchar(255)
USER (Untitled)
- user_id (User_Id) — Integer — Primary key — NOT NULL
- setting_id (Setting_Id) — Integer — Foreign key → SETTING.setting_id — NOT NULL
- refreshToken (RefreshToken) — varchar(255)
- password (Password) — varchar(255)
- accessToken (AccessToken) — varchar(255)
- userName (UserName) — varchar(255) — NOT NULL
- userEmail (UserEmail) — varchar(255) — NOT NULL