방호
테이블 (14)
AlarmCode
- codeNo — float
- labels — nvarchar(255)
- captions — nvarchar(255)
- exportFlag — float
AlarmLog
- insname — nvarchar(255)
- testdate — nvarchar(255)
- codeNo — float
- carno — float
- trainno — float
- repeaterid — float
- repeatername — nvarchar(255)
- remark — nvarchar(255)
- writedate — datetime
- exportFlag — float
Login
- UserID — varchar(20) — NOT NULL
- Time — datetime — NOT NULL
OP_Base
- ID — int — 기본 키 — NOT NULL
- Name — varchar(20) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Repeater_Base
- ID — int — 기본 키 — NOT NULL
- OP_ID — int — NOT NULL
- TE_ID — int — NOT NULL
- Latitude — varchar(20) — NOT NULL
- Longitude — varchar(20) — NOT NULL
- Remarks — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Repeater_Diag
- Repeater_ID — int — NOT NULL
- Status — int — NOT NULL
- Temperature — int — NOT NULL
- Voltage — int — NOT NULL
- Time — bigint — NOT NULL
Station_Base
- Code — varchar(10) — NOT NULL
- Name — varchar(20) — NOT NULL
TE_Base
- ID — int — NOT NULL
- Station_Code — varchar(10) — NOT NULL
- Station_Name — varchar(20) — NOT NULL
- Latitude — varchar(20) — NOT NULL
- Longitude — varchar(20) — NOT NULL
- TE_Distance — int — NOT NULL
TE_Diag
- TE_ID — int — NOT NULL
- Status — int — NOT NULL
- Temperature — int — NOT NULL
- Voltage — int — NOT NULL
- Time — bigint — NOT NULL
TPE_Base
- ID — int — 기본 키 — NOT NULL
- OP_ID — int — NOT NULL
- Remarks — varchar(20) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TPE_Diag
- TPE_ID — int — NOT NULL
- STATION_CODE — int — NOT NULL
- CarNo — int — NOT NULL
- Distance — float — NOT NULL
- Latitude — varchar(50) — NOT NULL
- Longitude — varchar(50) — NOT NULL
- Status — int — NOT NULL
- Time — int
TPE_EventLog
- S_ID — int — NOT NULL
- R_ID — int
- Station_Code — int
- Latitude — varchar(50) — NOT NULL
- Longitude — varchar(50) — NOT NULL
- Distance — float — NOT NULL
- Time — bigint — NOT NULL
- Status — int — NOT NULL
- Event — int — NOT NULL
- Reserved — int
User_Base
- UserID — varchar(50) — 기본 키 — NOT NULL
- Password — varchar(50) — NOT NULL
- UserName — varchar(50)
- UserLevel — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Xrois_Base
- TRAIN_NO — int
- CAR_NO_1 — int
- CAR_NO_2 — int
- DATE — int
- STATION_CODE — int
- STATION_ORDER — int
- STARTTIME — bigint
- ENDTIME — bigint