gong

Tables (4)

portfolio (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • profile_img (Field)
  • about_me (Field3)
  • skills (Field4)
  • study_log (Field5)
  • created_at (Field6)
  • user_id (Key2) — Foreign key → user.id — NOT NULL

study_keywords (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • keyword (Field2)
  • time_spent (Field3)
  • study_log_id (Key2) — Foreign key → study_logs.id — NOT NULL

study_logs (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • date (Field2)
  • total_time (Field3)
  • user_id (Key2) — Foreign key → user.id — NOT NULL

user (Untitled)

  • id (Key) — String — Primary key — NOT NULL
  • email (Field4)
  • pw (Field)
  • username (Field2)
  • created_at (Field3)