expert scheduler
Tables (9)
tbl_calendar (Untitled2)
- id (Key1) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → tbl_user.id — NOT NULL
- activated (Field)
- color (Field2)
tbl_invitaion (Untitled6)
- id (Key) — Primary key — NOT NULL
- title (Field)
- desciption (Field2)
- duration (Field3)
- access_key (Field4)
tbl_invitation_expert (Untitled9)
- invitation_id (Key2) — Foreign key → tbl_invitaion.id — NOT NULL
- user_id (Key1) — Foreign key → tbl_user.id — NOT NULL
tbl_invitation_person (Untitled8)
- invitation_id (Key2) — Foreign key → tbl_invitaion.id — NOT NULL
- name (Field)
- mobile (Field2)
- email (Field3)
tbl_invitation_time (Untitled7)
- invitation_id (Key) — Foreign key → tbl_invitaion.id — NOT NULL
- start_time (Field)
- end_time (Field2)
tbl_schedule (Untitled4)
- id (Key2) — Primary key — NOT NULL
- calenar_id (Key) — Foreign key → tbl_calendar.id — NOT NULL
- user_id (Key3) — Foreign key → tbl_user.id — NOT NULL
- start_time (Field)
- end_time (Field2)
- alarm active (Field3)
- alarm type (Field4) — multiple
- color (Field5)
- status (Field6) — pending, confirm
tbl_user (Untitled)
- id (Key1) — Primary key — NOT NULL
- name (Field)
tbl_user_calendar (Untitled3)
- user_id (Key1) — Foreign key → tbl_user.id — NOT NULL
- calendar_id (Key2) — Foreign key → tbl_calendar.id — NOT NULL
- activated (Field)
tbl_user_schedule (Untitled5)
- user_i d (Key) — Foreign key → tbl_user.id — NOT NULL
- schedule_id (Key2) — Foreign key → tbl_schedule.id — NOT NULL