miniproject

Tables (3)

daily_record (Untitled3)

  • record_id (Key) — Primary key — NOT NULL
  • notebook_id (Key2) — Foreign key → notebook.notebook_id — NOT NULL
  • user_id (Key22) — Foreign key → notebook.user_id — NOT NULL
  • content (Field3)
  • record_date (Field4)
  • created_at (Field5)
  • updated_at (Field6)

notebook (Untitled2)

  • notebook_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • title (Field3)
  • description (Field4)
  • created_at (Field5)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field2)
  • password (Field3)
  • nickname (Field4)
  • created_at (Field5)