Sobok_fix
Tables (13)
account
- account_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(50) — Primary key — NOT NULL
- category_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- target — VARCHAR(255) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- period — VARCHAR(50) — NOT NULL
- time — INT — NOT NULL
- duration — INT — NOT NULL
account_category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
ai_routine
- routine_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- repeat_day — JSON — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
ai_todo
- todo_id — BIGINT — Primary key — NOT NULL
- routine_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Primary key — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- link_app — VARCHAR(255)
like_option
- option_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
member
- id — VARCHAR(50) — Primary key — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- birth — VARCHAR(10) — NOT NULL
- point — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
oauth_account
- oauth_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — VARCHAR(50) — Primary key — NOT NULL
- oauth_provider — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
routine_log
- log_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(50) — Primary key — NOT NULL
- category_id — BIGINT — Primary key — NOT NULL
- routine_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
routine_test
- learning_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(50) — Primary key — NOT NULL
- job — INT — NOT NULL
- attrib_1 — BOOLEAN — NOT NULL
- attrib_2 — BOOLEAN — NOT NULL
- attrib_3 — BOOLEAN — NOT NULL
self_routine
- routine_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- repeat_day — JSON — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
self_todo
- todo_id — BIGINT — Primary key — NOT NULL
- routine_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Primary key — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- link_app — VARCHAR(255)
spare_time
- learning_id — BIGINT — Primary key — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- total_time — TIME — NOT NULL
todo_category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL