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)