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