MD_DB
Tables (5)
Error (에러 리스트)
- ER_seq — int — Primary key — NOT NULL
- DeviceID (장비아이디)
- DeviceName (장비이름)
- ErrorCode (에러코드)
- ErrorOccurTime (에러발생시간)
Game_History (게임운용기록)
- GH_seq — int — Primary key — NOT NULL
- GameName (게임이름)
- DeviceID (장비아이디)
- TagID (NFC카드넘버)
- GameStrartTime (게임시작시간)
- GameStopTime (게임종료시간)
Machine_History (장비 운용 기록)
- MH_seq — int — Primary key — NOT NULL
- ML_seq — int — Foreign key → Machine_List.ML_seq — NOT NULL
- DeviceID (장비아이디)
- DeviceName (장비이름)
- DeviceStartTime (장비시작시간)
- DeviceStopTime (장비종료시간)
Machine_List (장비 리스트)
- ML_seq — int — Primary key — NOT NULL
- DeviceID (장비아이디) — varchar(20)
- DeviceName (장비이름) — varchar(20)
- Use_Count (장비이용횟수) — int
- MotionCardNumber (장비내PC식별카드넘버)
RFID (NFC_Reader)
- RF_seq — int — Primary key — NOT NULL
- ML_seq — int — Foreign key → Machine_List.ML_seq — NOT NULL
- RFID_ID (리더기 고유넘버)
- RFID_Port (리더기 포트)
- DeviceID (장비아이디)
- TagTime (마지막태그시간)