Parking

Tables (29)

AdditionalDevice

  • DeviceIndex — bigint — Primary key — NOT NULL
  • PDeviceCode — varchar(20) — Foreign key → DeviceList.DeviceCode — NOT NULL
  • AddDeviceCode — varchar(10) — NOT NULL
  • DeviceName — varchar(50)
  • DeviceAddress — varchar(20)
  • DevicePort — varchar(10)
  • DeviceBaudrate — varchar(10)
  • DeviceType — int
  • DeviceCompany — varchar(50)
  • ID — varchar(20)
  • Password — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CalculatedLog

  • SeqCalculated — bigint — Primary key — NOT NULL
  • EnterTime — datetime
  • ExitTime — datetime — NOT NULL
  • TotalFee — money
  • DiscountFee — money
  • ReceivedFee — money
  • SeqExitVehicle — bigint — Foreign key → ExitVehicleLogs.SeqExitVehicle — NOT NULL
  • TypeOfPayment — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CampaignExceptionGroup

  • SeqGroupCode — bigint — Foreign key → MemberGroup.SeqGroupCode — NOT NULL

CampaignExceptionGroupModifyLogs

  • SeqMemberGroupModify — bigint — Foreign key → MemberGroupModifyLogs.SeqMemberGroupModify — NOT NULL
  • SeqGroupCode — bigint

CampaignOfReduceVehicle

  • DeviceCode — varchar(20) — Foreign key → DeviceList.DeviceCode — NOT NULL
  • CampaignMode — int — NOT NULL
  • CampaignTarget — int — NOT NULL
  • CampaignStTime — time(0) — NOT NULL
  • CampaignEdTime — time(0) — NOT NULL

CreditCardRecords

  • SeqCreditCardRecord — bigint — Primary key — NOT NULL
  • SeqCalculated — bigint — Foreign key → CalculatedLog.SeqCalculated
  • ServiceCode — int — NOT NULL
  • Installment — int — NOT NULL
  • AcceptMoney — money — NOT NULL
  • AcceptNumber — varchar(20) — NOT NULL
  • AcceptDateTime — datetime — NOT NULL
  • CardNumber — varchar(20) — NOT NULL
  • Issuer — varchar(20)
  • Buyer — varchar(20)
  • AddDeviceCode — varchar(10) — Foreign key → AdditionalDevice.AddDeviceCode — NOT NULL
  • RejectCode — varchar(10) — NOT NULL
  • FailMsg1 — varchar(20)
  • FailMsg2 — varchar(20)
  • FranchiseeID — varchar(15) — NOT NULL
  • ProcessID — varchar(4) — NOT NULL
  • AcceptCatID — varchar(10) — NOT NULL
  • TaxPointNoficationMsg — varchar(72)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CurrentParkingVehicles

  • PassedIndex — bigint — NOT NULL
  • VehicleID — varchar(20) — NOT NULL

DeviceList

  • DeviceCode — varchar(20) — Primary key — NOT NULL
  • DeviceName — varchar(50)
  • IsEnterOrExit — char(1)
  • DeviceAddress — varchar(20)
  • TCPPort — int
  • LEDDisplayMessageUP — varchar(12)
  • LEDDisplayMessageDown — varchar(12)
  • IsCollection — bit
  • TypeOfDevice — int
  • GateControlMode — int
  • DataProcessProtocol — int
  • SeqParkingInfo — bigint — Foreign key → ParkingInfo.SeqParkingInfo — NOT NULL
  • UseLoopSignal — bit
  • LEDDisplayMessageMember — varchar(12)
  • LEDDisplayMessageNoMember — varchar(12)
  • DisplayMemberMode — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DiscountLogs

  • SeqDiscountLog — bigint — NOT NULL
  • SeqCalculated — bigint — Foreign key → CalculatedLog.SeqCalculated — NOT NULL
  • Discountindex — bigint — Foreign key → KindOfDiscount.DisCountIndex — NOT NULL

ExitVehicleLogs

  • SeqExitVehicle — bigint — Primary key — NOT NULL
  • ExitIndex — bigint — Foreign key → PassedVehicleLogs.PassedIndex — NOT NULL
  • EnterIndex — bigint — Foreign key → PassedVehicleLogs.PassedIndex
  • WorkerID — varchar(20) — Foreign key → WorkerList.WorkerID
  • CalculatedTime — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

GateCtrlModeSchedule

  • DeviceCode — varchar(20) — Foreign key → DeviceList.DeviceCode — NOT NULL
  • H0 — int — NOT NULL
  • H1 — int — NOT NULL
  • H2 — int — NOT NULL
  • H3 — int — NOT NULL
  • H4 — int — NOT NULL
  • H5 — int — NOT NULL
  • H6 — int — NOT NULL
  • H7 — int — NOT NULL
  • H8 — int — NOT NULL
  • H9 — int — NOT NULL
  • H10 — int — NOT NULL
  • H11 — int — NOT NULL
  • H12 — int — NOT NULL
  • H13 — int — NOT NULL
  • H14 — int — NOT NULL
  • H15 — int — NOT NULL
  • H16 — int — NOT NULL
  • H17 — int — NOT NULL
  • H18 — int — NOT NULL
  • H19 — int — NOT NULL
  • H20 — int — NOT NULL
  • H21 — int — NOT NULL
  • H22 — int — NOT NULL
  • H23 — int — NOT NULL

GatePermission

  • VehicleID — varchar(20) — Foreign key → RegistedVehicle.VehicleID — NOT NULL
  • DeviceCode — varchar(20) — Foreign key → DeviceList.DeviceCode — NOT NULL

KindOfDiscount

  • DisCountIndex — bigint — Primary key — NOT NULL
  • DisCountName — varchar(30) — NOT NULL
  • DisCountType — int — NOT NULL
  • DisCountValue — money — NOT NULL
  • ShortCutKeyName — varchar(10) — NOT NULL
  • isAlone — bit
  • iSequence — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

KindOfParkingFee

  • SeqParkingFee — bigint — NOT NULL
  • NameOfParkingFee — varchar(30) — NOT NULL
  • StartTime — time(7) — NOT NULL
  • EndTime — time(7) — NOT NULL
  • EachPrice — money — NOT NULL
  • EachDuration — int — NOT NULL
  • UntilWhen — int — NOT NULL
  • usingDay — varchar(7)

KindOfSeasonTicket

  • SeqKindOfSeasonTicket — bigint — Primary key — NOT NULL
  • NameOfSeasonTicket — varchar(30) — NOT NULL
  • Duration — int — NOT NULL
  • Fee — money — NOT NULL
  • StartTime — time(7)
  • EndTime — time(7)
  • UsingDay — varchar(7)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Member

  • SeqMember — bigint — Primary key — NOT NULL
  • SeqGroupCode — bigint — Foreign key → MemberGroup.SeqGroupCode — NOT NULL
  • CellPhoneNumber — varchar(100)
  • MemberName — varchar(100)
  • Department — varchar(100)
  • Memo — varchar(100)
  • EmployeeNumber — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MemberGroup

  • SeqGroupCode — bigint — Primary key — NOT NULL
  • GroupName — varchar(100) — NOT NULL
  • StartTime — time(0) — NOT NULL
  • EndTime — time(0) — NOT NULL
  • UsingDay — varchar(7) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MemberGroupModifyLogs

  • SeqMemberGroupModify — bigint — Primary key — NOT NULL
  • SeqGroupCode — bigint — NOT NULL
  • GroupName — varchar(100)
  • StartTime — time(7)
  • EndTime — time(7)
  • UsingDay — varchar(7)
  • WorkerID — varchar(20) — NOT NULL
  • ModifyTime — datetime — NOT NULL
  • ModifyType — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MemberModifyLogs

  • SeqMemberModify — bigint — Primary key — NOT NULL
  • VehicleID — varchar(20)
  • StartDate — date
  • EndDate — date
  • IsNotification — bit
  • GroupName — varchar(100)
  • CellPhoneNumber — varchar(100)
  • MemberName — varchar(100)
  • Department — varchar(100)
  • Memo — varchar(100)
  • WorkerID — varchar(20) — NOT NULL
  • ModifyTime — datetime — NOT NULL
  • ModifyType — int — NOT NULL
  • VehicleType — varchar(50)
  • EmployeeNumber — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MemberuseVehicle

  • SeqMember — bigint — Foreign key → Member.SeqMember — NOT NULL
  • VehicleID — varchar(20) — Foreign key → RegistedVehicle.VehicleID — NOT NULL

ParkingInfo

  • SeqParkingInfo — bigint — Primary key — NOT NULL
  • ParkingLocationName — varchar(50) — NOT NULL
  • Address — varchar(70) — NOT NULL
  • BusinessLicenseNumber — varchar(30) — NOT NULL
  • TelNumber — varchar(20) — NOT NULL
  • DailyMaxFee — money
  • DailyMaxFeeType — int
  • under100Value — int
  • bUseNoEmptySpace — bit
  • CalcTime — time(7)
  • totalParkingSpace — int
  • KindOfCurrency — varchar(10)
  • OperationType — int — NOT NULL
  • EnabledNotification — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

PassedVehicleLogs

  • PassedIndex — bigint — Primary key — NOT NULL
  • DeviceCode — varchar(20) — Foreign key → DeviceList.DeviceCode — NOT NULL
  • PassedTime — datetime — NOT NULL
  • VehicleID — varchar(40)
  • IsMember — bit
  • ImageFilePath — varchar(100)
  • InsertType — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

PassedVehicleMemberLogs

  • PassedIndex — bigint — Foreign key → PassedVehicleLogs.PassedIndex — NOT NULL
  • StartDate — date
  • EndDate — date
  • IsNotification — bit
  • CellPhoneNumber — varchar(100)
  • MemberName — varchar(100)
  • Department — varchar(100)
  • Memo — varchar(100)
  • GroupName — varchar(100)
  • StartTime — time(7)
  • EndTime — time(7)
  • UsingDay — varchar(7)
  • EmployeeNumber — nvarchar(50)
  • VehicleType — nvarchar(50)

PriorPayment

  • SeqPriorPayment — bigint — Primary key — NOT NULL
  • EnterIndex — bigint — Foreign key → PassedVehicleLogs.PassedIndex — NOT NULL
  • acquisitionAmount — money
  • ParkingTime — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

RegistedVehicle

  • VehicleID — varchar(20) — Primary key — NOT NULL
  • StartDate — date — NOT NULL
  • EndDate — date — NOT NULL
  • IsNotification — bit
  • VehicleType — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

SubPassedVehicleLogs

  • PassedIndex — bigint — Foreign key → PassedVehicleLogs.PassedIndex — NOT NULL
  • DeviceCode — varchar(10) — NOT NULL
  • PassedTime — datetime — NOT NULL
  • VehicleID — varchar(40)
  • IsMember — bit
  • ImageFilePath — varchar(100)
  • InsertType — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TableChangeTime

  • TableName — varchar(50) — NOT NULL
  • ChangedTime — datetime — NOT NULL

WorkerList

  • WorkerID — varchar(20) — Primary key — NOT NULL
  • WorkerPassword — varchar(30) — NOT NULL
  • WorkerName — varchar(20)
  • WorkerLevel — int
  • IsHidden — bit — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

WorkingLog

  • SeqWorkingLog — bigint — Primary key — NOT NULL
  • SeqParkingInfo — bigint — Foreign key → ParkingInfo.SeqParkingInfo — NOT NULL
  • WorkerID — varchar(20) — Foreign key → WorkerList.WorkerID — NOT NULL
  • WorkBegintime — datetime
  • WorkEndTime — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =