Yogi

Tables (5)

GroupInfo (Untitled2)

  • GroupID (PrimaryKey) — INT — Primary key — NOT NULL
  • UserID (ForeignKey) — INT — Foreign key → UserInfo.UserID — NOT NULL
  • scheduleTable (Field2) — varchar

ImageTable (Untitled3)

  • ImageId (PrimaryKey) — INT — Primary key — NOT NULL
  • scheduleID (Key2) — INT — Foreign key → scheduleTable.scheduleID — NOT NULL
  • GroupID (PrimaryKey2) — INT — Foreign key → scheduleTable.GroupID — NOT NULL
  • longitude (Field3) — Float
  • latitude (Field4) — Float
  • time (Field5) — date_time
  • width (Field6) — INT
  • height (Field7) — INT

UserInfo (aa)

  • UserID (PrimaryKey) — INT — Primary key — NOT NULL
  • email (Field) — varchar
  • username (Field2) — varchar
  • password (Field3) — varchar

scheduleTable (Untitled)

  • scheduleID (Key) — INT — Primary key — NOT NULL
  • GroupID (PrimaryKey) — INT — Foreign key → GroupInfo.GroupID — NOT NULL
  • UserID (PrimaryKey2) — INT — Foreign key → GroupInfo.UserID — NOT NULL
  • latitude (Field) — Float
  • longitude (Field2) — Float
  • StartTime (Field3) — date_time
  • EndTime (Field4) — date_time

userlist (Untitled4)

  • GroupID (Field) — INT
  • UserID (Field2) — INT