PlanERD

Tables (5)

plan (Untitled2)

  • plan_id (Key) — Primary key — NOT NULL
  • plan_name (Field) — NOT NULL
  • plan_content (Field2)
  • start_date (Field3)
  • end_date (Field4)
  • start_time (Field5)
  • end_time (Field6)
  • location (Field7)
  • alarm_time (Field8)
  • create_at (Field9)
  • updated_at (Field10)
  • id (ID) — Foreign key → users.id — NOT NULL

recurringExecption (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • exception_date (Field)
  • is_canceld (Field2)
  • new__date (Field3)

recurringplan (Untitled4)

  • repeat_type (Field)
  • repeat_detail (Key2) — NOT NULL
  • repeat_interval (Field2)

singleplan (Untitled3)

    users (User)

    • id (ID) — Primary key — NOT NULL
    • user_id (UserId) — NOT NULL
    • password (Password) — NOT NULL
    • email (Email) — NOT NULL
    • phonenumber (PhoneNumber) — NOT NULL
    • name (Name)