pm

Tables (8)

Untitled

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Untitled2.Key — NOT NULL
  • Field
  • Field2

Untitled2

  • Key — Primary key — NOT NULL
  • Field

category

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • name — varchar(30)
  • completed — int
  • yet — int
  • minute — int
  • percent (percnet) — int
  • status — enum
  • updated_at — datetime(6)
  • created_at — datetime(6)

focus

  • id — bigint — Primary key — NOT NULL
  • cateogry_id (category_id) — bigint — Foreign key → category.id — NOT NULL
  • foucs_time — int
  • rest_time — int
  • repeat — int
  • updated_at — datetime(6)
  • created_at — datetime(6)

me_story

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • percent — int
  • date — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)

mestory_focus (CopyOffocus)

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → category.id — NOT NULL
  • foucs_time — int
  • save_date — date
  • updated_at — datetime(6)
  • created_at — datetime(6)

plan (planner)

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → category.id — NOT NULL
  • title — varchar(30)
  • date — datetime(6)
  • repeat — enum
  • alarm — datetime(6)
  • status — varchar(10)
  • updated_at — datetime(6)
  • created_at — datetime(6)

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar(5)
  • image_url — varchar(100)
  • inactive_date — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)