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