poksin

Tables (7)

CategoryEntity (Untitled5)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • name (Field) — STRING

ChatMessageEntity (Untitled7)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • type (Field) — STRING
  • room_id (Field2) — STRING
  • sender (Field3) — STRING
  • message (Field4) — STRING
  • timestamp (Field5) — DATEIME
  • file_url (Field6) — STRING
  • file_name (Field7) — STRING

ChatRoomEntity (Untitled6)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • room_id (Field) — STRING
  • name (Field2) — STRING
  • last_message (Field3) — STRING
  • last_updated (Field4) — DATETIME
  • is_blocked (Field5) — BOOLEAN
  • is_consultation_active (Field6) — BOOLEAN
  • admin (Field7) — STRING

CounselorEntity (Untitled2)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • username (Field2) — STRING
  • password (Field3) — STRING
  • role (Field4) — STRING
  • speicalty (Field) — STRING
  • career (Field5) — STRING
  • count (Field6) — INTEGER
  • start (Field7) — DATETIME
  • created)at (Field8) — DATETIME
  • modified_at (Field9) — DAETTIME

EvidenceEntity (Untitled3)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • title (Field) — STRING
  • description (Field2) — STRING
  • file_urls (Field3) — STRING
  • done (Field4) — BOOLEAN
  • evidenced_createdAt (Field5) — DATETIME
  • user_id (Key2) — INTEGER — Foreign key → UserEnttiy.id — NOT NULL
  • category_id (Key3) — INTEGER — Foreign key → CategoryEntity.id — NOT NULL
  • created_at (Field6) — DATETIME
  • modified_at (Field7) — DATETIME

UserEnttiy (Untitled)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • username (Field) — STRING
  • password (Field2) — STRING
  • role (Field3) — STRING
  • phone_num (Field4) — STRING
  • emergency_num (Field5) — STRING
  • address (Field6) — STRING
  • phone_open (Field7) — BOOLEAN
  • emergency_open (Field8) — BOOLEAN
  • address (Field9) — BOOLEAN
  • created_at (Field10) — DATETIME
  • modified_at (Field11) — DATETIME

ViolenceSegmentEntity (Untitled4)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • duration (Field) — FLOAT
  • s3_url (Field2) — STRING
  • evidence_id (Key2) — INTEGER — Foreign key → EvidenceEntity.id — NOT NULL