DRS

Tables (6)

AmazonUser

  • AmazonUserId — String — Primary key — NOT NULL
  • RefreshToken — String — NOT NULL

Device

  • DeviceId — String — Primary key — NOT NULL
  • DeviceType — String
  • ModelName — String
  • ThinQCreateDate — Date
  • DRSCreateDate — Date

LGUser

  • LGUserId (EMPUserNo) — String — Primary key — NOT NULL
  • AmazonUserId — String — Foreign key → AmazonUser.AmazonUserId — NOT NULL
  • CountryCode — String

Order

  • OrderId — String — Primary key — NOT NULL
  • AmazonUserId — String — Foreign key → AmazonUser.AmazonUserId — NOT NULL
  • SlotId — String — Foreign key → Slot.SlotId — NOT NULL
  • DeviceId — String — Foreign key → Slot.DeviceId — NOT NULL
  • OrderStatus — String
  • EstimatedDeliveryDate — Date
  • OrderCreateDate — Date

Slot

  • SlotId — String — Primary key — NOT NULL
  • DeviceId — String — Foreign key → Device.DeviceId — NOT NULL
  • RemainAmount — Int
  • OrderThreshold — Int
  • Subscribed — Boolean
  • ASINId — String
  • ASINQuantity — Int
  • SlotCreateDate — Date

UserDevice

  • DeviceId — String — Foreign key → Device.DeviceId — NOT NULL
  • AmazonUserId — String — Foreign key → LGUser.AmazonUserId — NOT NULL