hanium

Tables (5)

auth_user (Untitled)

  • id (PRI) — int(11) — Primary key — NOT NULL
  • username (Field) — varchar(150)
  • password (Field2) — varchar(128)
  • is_superuser (Field3) — tinyint(1)
  • email (Field4) — varchar(240)
  • last_login (Field5) — datetime(6)
  • is_staff (Field6) — tinyint(1)
  • is_active (Field7) — tinyint(1)

smartfarm_ctl_values_1f (Untitled3)

  • id (Key) — int(11) — Primary key — NOT NULL
  • id (PRI) — int(11) — Foreign key → auth_user.id — NOT NULL
  • name (Field) — varchar(20)
  • fan_ctl (Field2) — tinyint(1)
  • water_ctl (Field3) — tinyint(1)
  • light_ctl (Field4) — tinyint(1)
  • slide (Field5) — tinyint(1)

smartfarm_ctl_values_2f (CopyOfUntitled3)

  • id (Key) — int(11) — Primary key — NOT NULL
  • id (PRI) — int(11) — Foreign key → auth_user.id — NOT NULL
  • name (Field) — varchar(20)
  • fan_ctl (Field2) — tinyint(1)
  • water_ctl (Field3) — tinyint(1)
  • light_ctl (Field4) — tinyint(1)
  • slide (Field5) — tinyint(1)

smartfarm_data_values_1f (Untitled4)

  • id (PRI) — int(11) — Primary key — NOT NULL
  • id (PRI2) — int(11) — Foreign key → auth_user.id — NOT NULL
  • name (Field) — varchar(20)
  • tem_data (Field2) — double
  • hum_data (Field3) — double
  • light_data (Field4) — double
  • sm_data (Field5) — double
  • co2 (Field6) — double
  • created_at (Field7) — datetime(6)

smartfarm_data_values_2f (CopyOfUntitled4)

  • id (PRI) — int(11) — Primary key — NOT NULL
  • id (PRI2) — int(11) — Foreign key → auth_user.id — NOT NULL
  • name (Field) — varchar(20)
  • tem_data (Field2) — double
  • hum_data (Field3) — double
  • light_data (Field4) — double
  • sm_data (Field5) — double
  • co2 (Field6) — double
  • created_at (Field7) — datetime(6)