imlops

Tables (9)

auths (Untitled4)

  • aid (Key) — Primary key — NOT NULL
  • name (Field)

clients (Untitled)

  • cid — Primary key — NOT NULL
  • name
  • apiToken
  • createdDate (Field3)

groupAuths (Untitled7)

  • gaid (Key2) — Primary key — NOT NULL
  • cid — Foreign key → groups.cid — NOT NULL
  • gid (Key) — Foreign key → groups.gid — NOT NULL
  • aid (Key3) — Foreign key → auths.aid — NOT NULL

groupUsers (Untitled8)

  • guid (Key) — Primary key — NOT NULL
  • cid — Foreign key → users.cid — NOT NULL
  • uid — Foreign key → users.uid — NOT NULL
  • gid (Key2) — Foreign key → groups.gid — NOT NULL

groups (Untitled6)

  • gid (Key) — Primary key — NOT NULL
  • cid — Foreign key → clients.cid — NOT NULL
  • name (Field)
  • createdDate (Field2)

handledReports (Untitled9)

  • hrid (Key2) — Primary key — NOT NULL
  • cid — Foreign key → reports.cid — NOT NULL
  • rid (Key) — Foreign key → reports.rid — NOT NULL
  • uid — Foreign key → users.uid — NOT NULL
  • data (Field)
  • handler (Field2)
  • createdDate (Field3)

reports (Untitled3)

  • rid (Key) — Primary key — NOT NULL
  • cid — Foreign key → clients.cid — NOT NULL
  • system(VURIX, GAIA ... ) (Field9)
  • channel (Field8)
  • reporter (Field)
  • description (Field2)
  • thumbnailURL (Field4)
  • resourceURL (Field5)
  • metaData (Field7)
  • status (Field6)
  • createdDate (Field3)

userAuths (Untitled5)

  • uaid (Key) — Primary key — NOT NULL
  • cid — Foreign key → users.cid — NOT NULL
  • uid — Foreign key → users.uid — NOT NULL
  • aid (Key2) — Foreign key → auths.aid — NOT NULL

users (Untitled2)

  • uid — Primary key — NOT NULL
  • cid — Foreign key → clients.cid — NOT NULL
  • loginID (Field)
  • password (Field2)
  • name (Field3)
  • phoneNumber (Field4)
  • email (Field5)
  • createdDate (Field6)