MDCIM

Tables (32)

Add (add)

  • Add Id (add_id) — Primary key — NOT NULL

Authorization (authorization)

  • Authorization Id (authorization_id) — Primary key — NOT NULL
  • Manager Id (manager_id) — Foreign key → Manager.Manager Id — NOT NULL
  • Guest Id (guest_id) — Foreign key → Guest.Guest Id — NOT NULL

Confirm Password (confirm_password)

  • CPassword Id (cpassword_id) — Primary key — NOT NULL

DHCP (dhcp)

  • DHCP Id (dhcp_id) — Primary key — NOT NULL

DNS (dns)

  • DNS Id (dms_id) — Primary key — NOT NULL

Database (database)

  • Db Id (db_id) — Primary key — NOT NULL
  • Sort Id (sort_id) — Foreign key → Sort.Sort Id — NOT NULL
  • State Id (state_id) — Foreign key → State.State Id — NOT NULL

Definition (definition)

  • Def Id (def_id) — Primary key — NOT NULL
  • Nwsetting Id (nwsetting_id) — Foreign key — NOT NULL

Delete (delete)

  • Delete Id (delete_id) — Primary key — NOT NULL

Edit (edit)

  • Edit Id (edit_id) — Primary key — NOT NULL

Email Address (email_address)

  • Email Id (email_id) — Primary key — NOT NULL

Field (field)

  • Field Id (field_id) — Primary key — NOT NULL
  • Username Id (username_id) — Foreign key → User Name.Username Id — NOT NULL
  • Password Id (password_id) — Foreign key → Password.Password Id — NOT NULL
  • CPassword Id (cpassword_id) — Foreign key → Confirm Password.CPassword Id — NOT NULL
  • Number Id (number_id) — Foreign key → Telephone Number.Number Id — NOT NULL
  • Email Id (email_id) — Foreign key → Email Address.Email Id — NOT NULL

Func (Untitled3)

  • Func Id (func_id) — Primary key — NOT NULL
  • Field

Function (function)

  • Function Id (function_id) — Primary key — NOT NULL
  • Add Id (add_id) — Foreign key → Add.Add Id — NOT NULL
  • Edit Id (edit_id) — Foreign key → Edit.Edit Id — NOT NULL
  • Delete Id (delete_id) — Foreign key → Delete.Delete Id — NOT NULL

Guest (guest)

  • Guest Id (guest_id) — Primary key — NOT NULL

IP (ip)

  • IP Id (ip_id) — Primary key — NOT NULL

Manager (manager)

  • Manager Id (manager_id) — Primary key — NOT NULL

Mdcim (mdcim)

  • Mdcim Id (mdcim_id) — Primary key — NOT NULL
  • Setting Id (setting_id) — Foreign key → SettingTable.Setting Id — NOT NULL
  • WT Id (wt_id) — Foreign key → Weather Time.WT Id — NOT NULL

NTP Server (Untitled)

  • NTP Id (ntp_id) — Primary key — NOT NULL

Network (network)

  • Network Id (network_id) — Primary key — NOT NULL
  • Def Id (def_id) — Foreign key → Definition.Def Id — NOT NULL
  • Nwfield Id (nwfield_id) — Foreign key — NOT NULL

Password (password)

  • Password Id (password_id) — Primary key — NOT NULL

Policy (Untitled2)

  • Policy Id (policy_id) — Primary key — NOT NULL

SettingTable (setting_table)

  • Setting Id (setting_id) — Primary key — NOT NULL
  • UserManager Id (usermanager_id) — Foreign key → UserManager.UserManager Id — NOT NULL
  • Network Id (network_id) — Foreign key → Network.Network Id — NOT NULL
  • Db Id (db_id) — Foreign key → Database.Db Id — NOT NULL

Sort (sort)

  • Sort Id (sort_id) — Primary key — NOT NULL
  • Temp (temp)
  • Humidity (humidity)
  • Leak (leak)
  • Fume (fume)
  • Fire (fire)
  • Gas (gas)
  • Motion (motion)
  • Volt (volt)
  • Door (door)

State (state)

  • State Id (state_id) — Primary key — NOT NULL
  • Open (Field)
  • Closed (Field2)
  • BelowLowCritical (Field3)
  • BelowLowerWarning (Field4)
  • Normal (Field5)
  • On (Field6)
  • Off (Field7)
  • Ok (Field8)
  • Fail (Field9)

Static (static)

  • Static Id (static_id) — Primary key — NOT NULL
  • IP Id (ip_id) — Foreign key → IP.IP Id — NOT NULL
  • SM Id (sm_id) — Foreign key → Subnet Mask.SM Id — NOT NULL
  • DNS Id (dms_id) — Foreign key → DNS.DNS Id — NOT NULL

Subnet Mask (subnet_mask)

  • SM Id (sm_id) — Primary key — NOT NULL

Telephone Number (telephone_number)

  • Number Id (number_id) — Primary key — NOT NULL

Untitled4

    Untitled5

      User Name (user_name)

      • Username Id (username_id) — Primary key — NOT NULL

      UserManager (user_manager)

      • UserManager Id (usermanager_id) — Primary key — NOT NULL
      • Authorization Id (authorization_id) — Foreign key → Authorization.Authorization Id — NOT NULL
      • Function Id (function_id) — Foreign key → Function.Function Id — NOT NULL
      • Field Id (field_id) — Foreign key → Field.Field Id — NOT NULL

      Weather Time (weather_time)

      • WT Id (wt_id) — Primary key — NOT NULL
      • NTP Id (ntp_id) — Foreign key → NTP Server.NTP Id — NOT NULL