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