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