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