dateanu

Tables (10)

chat (Untitled6)

  • id_pk (Key) — Primary key — NOT NULL
  • send_client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • recv_client_id (Key3) — Foreign key → client.id_pk — NOT NULL
  • send_at (Field3)
  • message (Field4)

chat_file (Untitled7)

  • id_pk (Key) — Primary key — NOT NULL
  • chat_id (Key2) — Foreign key → chat.id_pk — NOT NULL
  • chat_file_src (Field2)
  • upload_at (Field3)
  • delete_at (Field4)

client (Untitled)

  • id_pk (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • phone_num (Field3)
  • age (Field4)
  • dept (Field5)
  • student_id (Field6)
  • img (Field7)
  • is_exclude_acquaintance (Field8)

client_group (Untitled4)

  • id_pk (Key) — Primary key — NOT NULL
  • client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • group_id (Key3) — Foreign key → group.id_pk — NOT NULL

client_img (Untitled3)

  • id_pk (Key) — Primary key — NOT NULL
  • client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • img_src_path (Field2)
  • upload_at (Field3)
  • delete_at (Field4)

connection (Untitled5)

  • id_pk (Key) — Primary key — NOT NULL
  • male_client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • female_client_id (Key3) — Foreign key → client.id_pk — NOT NULL
  • connection_type (Field3)

exclusion (Untitled2)

  • id_pk (Key) — Primary key — NOT NULL
  • initiator_client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • target_client_id (Key3) — Foreign key → client.id_pk — NOT NULL
  • exclude_at (Field3)

group (Untitled10)

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

report (Untitled9)

  • id_pk (Key) — Primary key — NOT NULL
  • initiator_client_id (Key2) — Foreign key → client.id_pk — NOT NULL
  • target_client_id (Key3) — Foreign key → client.id_pk — NOT NULL
  • category (Field3)
  • detail (Field4)
  • report_at (Field5)
  • is_solved (Field6)

topic (Untitled8)

  • id_pk (Key) — Primary key — NOT NULL
  • topic (Field)