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 (마지막태그시간)