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)