AirControl

Tables (6)

Category (category)

  • _id — NotNull — Primary key — NOT NULL
  • Categoryname (categoryname) — NotNull
  • IconImage (iconimage) — NotNull
  • MakerImage (makerimage) — NotNull

Device (device)

  • _id — NotNull — Primary key — NOT NULL
  • DeviceNumber (devicenumber) — NotNull — Primary key — NOT NULL

DeviceData (devicedata)

  • _id — NotNull — Primary key — NOT NULL
  • DeviceNumber (devicenumber) — NotNull
  • Data (data) — NotNull

Store (store)

  • _id — NotNull — Primary key — NOT NULL
  • placename — NotNull
  • Location (location) — NotNull
  • Contact (contact)
  • Openhours (openhours)
  • Closehours (closehours)
  • Others (others)
  • Photo (photo) — NotNull
  • DeviceNumber (devicenumber) — NotNull
  • Categoryid (categoryid) — NotNull — Foreign key → Category._id — NOT NULL
  • Address (address) — NotNull

Suggestion (suggestion)

  • _id — NotNull — Primary key — NOT NULL
  • placename — NotNull
  • Address (address) — NotNull
  • Contact (contact) — NotNull
  • Openhours (openhours) — NotNull
  • Closehours (closehours) — NotNull
  • Others (others)
  • Photo (photo) — NotNull
  • DeviceNumber (devicenumber)
  • Userid (userid) — NotNull — Foreign key → User._id — NOT NULL
  • Categoryid (categoryid) — NotNull — Foreign key → Category._id — NOT NULL

User (user)

  • _id — NotNull — Primary key — NOT NULL
  • username — NotNull
  • name — NotNull
  • password — NotNull
  • Role (role) — NotNull
  • Bookmark (bookmark)
  • Storeid (storeid) — Foreign key → Store._id — NOT NULL