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