twingccle
Tables (5)
archives (Untitled3)
- id (Key) — Primary key — NOT NULL
- goal_id (Key2) — BIGINT — Foreign key → goals.id — NOT NULL
- user_id (Key22) — BIGINT — Foreign key → goals.user_id — NOT NULL
- title (Field)
- link (Field2)
- status (Field5)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
goals (CopyOfUntitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
- title (Field)
- deadline (Field2)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
tasks (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- goal_id (Key2) — BIGINT — Foreign key → goals.id — NOT NULL
- user_id (Key22) — BIGINT — Foreign key → goals.user_id — NOT NULL
- content (Field)
- expected_minutes (Field2)
- status (Field3)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
try_logs (CopyOfUntitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- task_id (Key2) — BIGINT — Foreign key → tasks.id — NOT NULL
- goal_id (Key22) — BIGINT — Foreign key → tasks.goal_id — NOT NULL
- user_id (Key222) — BIGINT — Foreign key → tasks.user_id — NOT NULL
- content (Field)
- image_url (Field2)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
users (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field)
- password (Field2)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME