ADS
Tables (7)
license (License)
- license_id (LicenseId) — BigInteger — Primary key — NOT NULL
- store_id (StoreId) — BigInteger — Foreign key → store.store_id
- loc_id (Location) — String — Foreign key → store.loc_id — NOT NULL
- user_no (UserNo) — String — Foreign key → store.user_no — NOT NULL
- start_date (StartDate) — Date
- end_date (EndDate) — Date
- license_type (LicenseType) — Integer
- phone_no (PhoneNo) — String
- email (Email) — String
signage (Signage)
- signage_id (SignageId) — BigInteger — Primary key — NOT NULL
- store_id (StoreId2) — BigInteger — Foreign key → store.store_id
- loc_id (Location) — String — Foreign key → store.loc_id — NOT NULL
- user_no (UserNo) — String — Foreign key → store.user_no — NOT NULL
- signage_name (SignageName) — String
sinage_device_map (SignageDeviceMap)
- signage_id (SignageId) — BigInteger — Foreign key → signage.signage_id — NOT NULL
- device_id (DeviceId) — String — Foreign key → thinq_device.device_id — NOT NULL
store (Store)
- store_id (StoreId) — BigInteger — Primary key
- loc_id (Location) — String — Foreign key → weather.loc_id — NOT NULL
- user_no (UserNo) — String — Foreign key → thinq_account.user_no — NOT NULL
- industry_type (IndustryType) — String
- install_shop (InstallShop) — String
- start_date (StarteDate) — Date
thinq_account (ThinQAccount)
- user_no (UserNo) — String — Primary key — NOT NULL
- email (Email) — String
- pw (Password) — String
- access_token (AccessToken) — String
- refresh_token (RefreshToken) — String
- expire_time (ExpireTime) — Date
- Field
thinq_device (ThinQDevice)
- device_id (DeviceId) — String — Primary key — NOT NULL
- user_no (UserNo) — String — Foreign key → thinq_account.user_no — NOT NULL
- air_quality_indoor (AirQualityIndoor) — Json
- update_time (UpdateTime) — Date
- Field (DeviceName) — String
- Field (DeviceType) — String
- Field (ModelName) — String
weather (Weather)
- loc_id (Location) — String — Primary key — NOT NULL
- update_time (UpdateTime) — Date
- location_name (LocationName) — String
- air_quality_outdoor (AirQualityOutdoor) — Json