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