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