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 — =