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