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)
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)