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