hoho_lock_snuh
Tables (23)
dbo.JobTypeArea (Untitled15)
- SiteCode (Key) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
- DeptGroupCode (Key2) — int — Foreign key → dbo.tblDeptGroupInfo.DeptGroupCode — NOT NULL
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- JobTypeCode (Field) — varchar(30)
- JobTypeName (Field2) — varchar(30)
- GenderType (Field6) — varchar(10)
dbo.tblAreaConfig (Untitled2)
- AreaCode (Key3) — varchar(30) — Primary key — NOT NULL
- AreaName (Field2) — varchar(100)
- GroupName (Field3) — varchar(50)
- PLC_IP (Field4) — varchar(30) — NOT NULL
- PLC_Port (Field5) — int — NOT NULL
- BoxSet (Field6) — int — NOT NULL
- BoxRow (Field7) — tinyint — NOT NULL
- BoxCol (Field8) — tinyint — NOT NULL
- MasterBoxCol (Field9) — tinyint — 안쓰는듯
- BigBoxTopNum (Field10) — varchar(50) — 안쓰는듯
- FourBoxTopNum (Field11) — varchar(50) — 안쓰는듯
- CreateDate (Field12) — datetime — NOT NULL
- FreeTime (Field13) — tinyint
- Fee (Field14) — int
- MaxFee (Field15) — int
- PLC2_IP (Field16) — varchar(30)
- PLC2_Start (Field17) — int
- Beacon_UUID (Field18) — varchar(50)
- Beacon_Major (Field19) — int
- Beacon_Minor (Field20) — int
- GroupCode (Key2) — varchar(30) — Foreign key → dbo.tblGroupInfo.GroupCode
- SiteCode (Key) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
- AreaPW (Field23) — varchar(30) — 안쓰는듯
- AreaLoc (Field24) — varchar(max) — 안쓰는듯
- OverTimeUnitHour (Field25) — int
- OverTimeUnitFee (Field26) — int
- OverTimeMinFee (Field27) — int
- OverTimeMaxFee (Field28) — int
- UseAgent (Field29) — tinyint
- TimeUseBoxStart (Field30) — int — 안쓰는듯
- TimeUseBoxEnd (Field31) — int — 안쓰는듯
- UseCouple (Field32) — tinyint — 안쓰는듯
- FeeInfoCode (Field33) — varchar(10)
- SiteName (Field34) — varchar(50)
- UpdateDate (Field35) — datetime
- UseLocalDB (Field36) — tinyint
- MasterBoxUpNo (Field37) — int
- MasterBoxHeight (Field38) — int
- AndPackage (Field39) — varchar(50)
- iOSPackage (Field40) — varchar(50)
- PayMethod (Field41) — varchar(max)
- UsePromotion (Field42) — tinyint
- PromotionDue (Field43) — datetime
- PromotionType (Field44) — varchar(10)
- PromotionVal (Field45) — int
- PushPackage (Field46) — varchar(50)
- MaxLocker (Field47) — tinyint
- DBName (Field48) — varchar(50)
- SiteType (Field49) — nchar(10)
- ExtendTimeBox (Field50) — tinyint
- ReUseTimeBox (Field51) — tinyint
- MasterBoxDownStartNo (Field52) — int — 안쓰는듯
- MasterBoxDownEndNo (Field53) — int — 안쓰는듯
- LastCntOnMasterBoxCol (Field54) — int
- SupportFunc (Field55) — varchar(max)
- DeliverStartNo (Field56) — int — 안쓰는듯
- DeliverEndNo (Field57) — int — 안쓰는듯
- MinFee (Field58) — int
- FeeUnitHour (Field59) — int
- MinFeeHour (Field60) — int
- … +38
dbo.tblBoxHistory (Untitled4)
- Key — Primary key — NOT NULL
- eventType (Field) — tinyint
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- boxNo (Field3) — int — NOT NULL
- serviceType (Field4) — tinyint
- boxSizeType (Field5) — tinyint
- useState (Field6) — tinyint
- userCode (Field7) — varchar(50)
- userName (Field8) — varchar(20)
- userPhone (Field9) — varchar(25)
- dong (Field10) — varchar(30)
- addressNum (Field11) — varchar(30)
- transCode (Field12) — varchar(50)
- transPhone (Field13) — varchar(25)
- barcode (Field14) — varchar(max)
- deliveryType (Field15) — tinyint
- boxPassword (Field16) — varchar(128)
- payCode (Field17) — varchar(40)
- payAmount (Field18) — int
- useTimeType (Field19) — tinyint
- startTime (Field20) — datetime
- endTime (Field21) — datetime
- createDate (Field22) — datetime
- Sequence (Field23) — varchar(50) — 안쓰는듯
- gatewaySN (Field24) — int
- UserCardNo (Field25) — varchar(30)
- updateTime (Field26) — datetime
- syncTime (Field27) — datetime
- lockStatus (Field28) — tinyint — 안쓰는듯
- adminCardNo (Field29) — varchar(30)
- adminPasswd (Field30) — varchar(128)
- NfcID (Field31) — varchar(30)
- Key (Key2) — Foreign key → dbo.tblBoxMaster.Key — NOT NULL
dbo.tblBoxMaster (Untitled5)
- Key — Primary key — NOT NULL
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- boxNo (Field2) — int — NOT NULL
- serviceType (Field3) — tinyint
- boxSizeType (Field4) — tinyint
- useState (Field5) — tinyint
- userCode (Field6) — varchar(50)
- userName (Field7) — varchar(20)
- userPhone (Field8) — varchar(25)
- payType (Field9) — tinyint
- dong (Field10) — varchar(30)
- addressNum (Field11) — varchar(30)
- transCode (Field12) — varchar(50)
- barcode (Field13) — varchar(60)
- deliveryType (Field14) — tinyint
- boxPassword (Field15) — varchar(128)
- payCode (Field16) — varchar(40)
- payAmount (Field17) — int
- useTimeType (Field18) — tinyint
- startTime (Field19) — datetime
- endTime (Field20) — datetime
- pwd_type (Field21) — tinyint — 안쓰는듯
- useType (Field22) — tinyint — 안쓰는듯
- NfcID (Field23) — varchar(30)
- hasAdURL (Field24) — tinyint — 안쓰는듯
- AdURL (Field25) — varchar(max) — 안쓰는듯
- TagCnt (Field26) — int — 안쓰는듯
- TagAdCnt (Field27) — int — 안쓰는듯
- isConsole (Field28) — tinyint — 안쓰는듯
- BoxHeight (Field29) — int
- Width_cm (Field30) — int — 안쓰는듯
- Height_cm (Field31) — int — 안쓰는듯
- Depth_cm (Field32) — int — 안쓰는듯
- Sequence (Field33) — varchar(50) — 안쓰는듯
- gatewaySN (Field34) — int
- UserCardNo (Field35) — varchar(30)
- updateTime (Field36) — datetime
- syncTime (Field37) — datetime — 안쓰는듯
- lockStatus (Field38) — tinyint — 안쓰는듯
- adminCardNo (Field39) — varchar(30)
- adminPasswd (Field40) — varchar(128)
- overTimeType (Field41) — varchar(10) — 안쓰는듯
- showBoxNo (Field42) — int
- genderType (Field43) — varchar(10)
- DeptGroupCode (Field44) — int
- MapPointX (Field45) — int
- MapPointY (Field46) — int
dbo.tblBoxUserInfo (Untitled6)
- areaCode (Field) — varchar(30) — NOT NULL
- boxNo (Field2) — int — NOT NULL
- serviceType (Field3) — tinyint
- boxSizeType (Field4) — tinyint
- useState (Field5) — tinyint
- userCode (Field6) — varchar(50)
- userName (Field7) — varchar(20)
- userPhone (Field8) — varchar(25)
- payType (Field9) — tinyint
- dong (Field10) — varchar(30)
- addressNum (Field11) — varchar(30)
- transCode (Field12) — varchar(50)
- transPhone (Field13) — varchar(25)
- barcode (Field14) — varchar(max)
- deliveryType (Field15) — tinyint
- boxPassword (Field16) — varchar(25)
- payCode (Field17) — varchar(40)
- payAmount (Field18) — int
- useTimeType (Field19) — tinyint
- startTime (Field20) — datetime
- endTime (Field21) — datetime
dbo.tblDeptAssignGroup (Untitled8)
- Key — Primary key — NOT NULL
- DeptCode (Field) — varchar(30)
- DeptName (Field2) — varchar(30)
- DeptGroupCode (Key2) — int — Foreign key → dbo.tblDeptGroupInfo.DeptGroupCode — NOT NULL
- SiteCode (Key3) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
dbo.tblDeptGroupInfo (Untitled9)
- DeptGroupCode (Key) — int — Primary key — NOT NULL
- DeptGroupName (Field2) — varchar(30)
- IsSelectable (Field4) — tinyint
- SiteCode (Key2) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
dbo.tblDeptLockerInfo (Untitled10)
- Key — Primary key — NOT NULL
- DeptLockerMaxCnt (Field2) — int
- AreaCode (Field3) — varchar(30)
- DeptGroupCode (Key2) — int — Foreign key → dbo.tblDeptGroupInfo.DeptGroupCode — NOT NULL
- SiteCode (Key3) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
dbo.tblEventTypeDesc (Untitled11)
- eventType (Field) — tinyint — NOT NULL
- eventDesc (Field2) — varchar(150) — NOT NULL
- SourceCodeName (Field3) — varchar(100) — NOT NULL
dbo.tblGatewayInfo (Untitled12)
- Key — Primary key — NOT NULL
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- gatewaySN (Field2) — int — NOT NULL
- PanId (Field3) — varchar(30) — NOT NULL
- channel (Field4) — int — NOT NULL
- gatewayName (Field5) — varchar(50) — NOT NULL
- gatewayIP (Field6) — varchar(30) — NOT NULL
- serverIP (Field7) — varchar(30) — NOT NULL
- serverPort (Field8) — int — NOT NULL
- heartbeatPacket (Field9) — varchar(50) — NOT NULL
- registerPacket (Field10) — varchar(50) — NOT NULL
- gatewayModel (Field11) — varchar(100)
- location (Field12) — varchar(100)
- updateTime (Field13) — datetime — NOT NULL
- createTime (Field14) — datetime — NOT NULL
- Key (Key2) — Foreign key → dbo.tblBoxMaster.Key — NOT NULL
dbo.tblGroupInfo (Untitled13)
- GroupCode (Key) — varchar(30) — Primary key
- GroupName (Field2) — varchar(50)
- Show (Field4) — tinyint
- SiteCode (Key2) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
dbo.tblHolidays (Untitled14)
- Holiday (Field) — varchar(50) — NOT NULL
dbo.tblLockerMaster (Untitled)
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- boxSN (Field2) — int — NOT NULL
- boxNo (Field3) — int — NOT NULL
- boxAddr (Field4) — varchar(4)
- userPhone (Field5) — varchar(25)
- boxCardNo (Field6) — varchar(256)
- boxPassword (Field7) — varchar(128)
- useState (Field8) — tinyint — 안쓰는듯
- startTime (Field9) — datetime
- updateTime (Field10) — datetime
- syncTime (Field11) — datetime
dbo.tblLockerTerm (Untitled3)
- LockerType (Key2) — tinyint — Primary key
- SiteCode (Key) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
- TermType (Field3) — varchar(30)
- Term (Field4) — int
dbo.tblMgrAccnt (Untitled7)
- MgrId (Key) — varchar(30) — Primary key
- MgrPwd (Field2) — varchar(30)
- EnableAccnt (Field3) — tinyint
- ParentMgrId (Field4) — varchar(30)
- UpdateTime (Field5) — datetime
dbo.tblMgrIP (Untitled16)
- MgrIP (Field) — varchar(50)
dbo.tblMgrRegion (Untitled17)
- Key — Primary key — NOT NULL
- AreaCode (Field4) — varchar(30)
- GroupCode (Key3) — varchar(30) — Foreign key → dbo.tblGroupInfo.GroupCode
- MgrId (Key2) — varchar(30) — Foreign key → dbo.tblMgrAccnt.MgrId
- SiteCode (Key4) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
dbo.tblNotice (Untitled18)
- SiteCode (Key) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
- GroupCode (Key2) — varchar(30) — Foreign key → dbo.tblGroupInfo.GroupCode
- Tag (Field) — varchar(50)
- Notice (Field2) — varchar(max)
- StartDate (Field4) — datetime
- DueDate (Field5) — datetime
- id (Field6) — int — NOT NULL
- Target (Field8) — varchar(10)
dbo.tblPushReq (Untitled19)
- id (Field) — int — NOT NULL
- UserPhone (Field2) — varchar(30)
- UserId (Field3) — varchar(30)
- Title (Field4) — varchar(30)
- Message (Field5) — varchar(max)
- areaCode (Field6) — varchar(30)
- boxNo (Field7) — int
- CreateTime (Field8) — datetime
- RetryCnt (Field9) — int
- Package (Field10) — varchar(50)
dbo.tblPushResult (Untitled20)
- UserPhone (Key) — varchar(30) — Primary key
- UserId (Key2) — varchar(30) — Primary key
- Title (Field3) — varchar(50)
- Message (Field4) — varchar(max)
- AreaCode (Key3) — varchar(30) — Foreign key → dbo.tblAreaConfig.AreaCode — NOT NULL
- areaName (Field6) — varchar(50)
- boxNo (Field7) — int
- ResultCode (Field8) — varchar(10)
- ResultMsg (Field9) — varchar(max)
- CreateTime (Field10) — datetime
- Package (Field11) — varchar(50)
- Token (Field12) — varchar(max)
- OS (Field13) — varchar(10)
dbo.tblPushUser (Untitled21)
- UserPhone (Key) — varchar(30) — Foreign key → dbo.tblPushResult.UserPhone
- UserId (Key2) — varchar(30) — Foreign key → dbo.tblPushResult.UserId
- Token (Field3) — varchar(max)
- Enable (Field4) — tinyint
- OS (Field5) — varchar(10)
- UpdateTime (Field6) — datetime
- Package (Field7) — varchar(50)
dbo.tblReturnPolicy (Untitled22)
- SiteCode (Key) — varchar(30) — Foreign key → dbo.tblSiteInfo.SiteCode
- LockerType (Key2) — tinyint — Foreign key → dbo.tblLockerTerm.LockerType
- AutoReturn (Field3) — tinyint
dbo.tblSiteInfo (Untitled23)
- SiteCode (Key) — varchar(30) — Primary key
- SiteName (Field2) — varchar(50)
- SiteType (Field3) — tinyint
- UseId (Field4) — tinyint
- UseDeliver (Field5) — tinyint