ThinkHub

Tables (7)

Calendar_Event

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → User.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • created_at — TIMESTAMP

Goal

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → User.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM('pending', 'in_progress', 'completed')
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP

Memo

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → User.id
  • goal_id — BIGINT — Foreign key → Goal.id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Milestone

  • id — BIGINT — Primary key
  • goal_id — BIGINT — Foreign key → Goal.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM('not_started', 'in_progress', 'completed')
  • due_date — DATE
  • created_at — TIMESTAMP

Notion_Integration

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → User.id
  • notion_page_id — VARCHAR(255) — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • status — ENUM('pending', 'synced', 'failed')
  • synced_at — TIMESTAMP

ToDo

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → User.id
  • goal_id — BIGINT — Foreign key → Goal.id
  • title — VARCHAR(255) — NOT NULL
  • status — ENUM('pending', 'completed')
  • due_date — DATE
  • created_at — TIMESTAMP

User

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • created_at — TIMESTAMP