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