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
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