B.o

Tables (4)

Agents (Untitled)

  • Agents_id (Key) — int — Primary key — NOT NULL
  • Agents_password (Field2) — varchar — NOT NULL
  • Agents_name (Key3) — varchar — NOT NULL
  • Agents_phone (Key4) — int — NOT NULL
  • Agents_email (Field) — varchar
  • Agents_IP (Field3) — varchar

Client (CopyOfUntitled)

  • client_id (Pk) — int — Primary key — NOT NULL
  • client_password (Field2) — varchar — NOT NULL
  • client_name (Key3) — varchar — NOT NULL
  • client_phone (Key4) — int — NOT NULL
  • client_email (Field) — varchar
  • is_deleted (Field3) — BOOLEAN
  • Field4 — datetime — NOT NULL

Login (Untitled2)

  • ligin_id (pk) — int — Primary key — NOT NULL
  • client_id (fk) — int — Foreign key → Client.client_id — NOT NULL
  • Agents_id (Key2) — int — Foreign key → Agents.Agents_id — NOT NULL

notices (Untitled3)

  • notices_id (Key) — int — Primary key — NOT NULL
  • Field
  • Field2