1234

Tables (12)

Building (건물)

  • Building_ID (Key) — Primary key — NOT NULL
  • 건물명 (Field)
  • 준공일자 (Field2)
  • 층수 (Field3)
  • 위험등급 (Field4)

Building Equipment (건물장비)

  • BE_ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Building.Building_ID — NOT NULL
  • ID (Key3) — Foreign key → Equipment.Equit_ID — NOT NULL

Equipment (장비)

  • Equit_ID (Key) — Primary key — NOT NULL
  • 장비명 (Field)
  • 개수 (Field2)
  • 장비유형 (Field3)

Individual Equipment (장비별데이터)

  • Equip_Idv_ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Equipment.Equit_ID — NOT NULL
  • 위치 (Field)
  • 장비상태 (Field2)
  • 점검일자 (Field3)
  • 설치일자 (Field4)
  • Field5

Org (조직)

  • Org_ID (Key) — Primary key — NOT NULL
  • 부서명 (Field)

Position (직급)

  • PositionID (Key) — Primary key — NOT NULL
  • 일반 (Field)
  • 매니저 (Field2)

Re_Inquiry (재점검지시)

  • ReIn_Id (Key) — Primary key — NOT NULL
  • SR_ID (Key2) — Foreign key → Schedule_Result.SR_ID — NOT NULL
  • Sche_ID (Key22) — Foreign key → Schedule_Result.Sche_ID — NOT NULL
  • TeamID (Key222) — Foreign key → Schedule_Result.TeamID — NOT NULL
  • ID (Key2222) — Foreign key → Schedule_Result.ID — NOT NULL
  • ID (Key3) — Foreign key → Schedule_Result.ID — NOT NULL
  • ID (Key23) — Foreign key → Schedule_Result.ID — NOT NULL
  • User_ID (Key4) — Foreign key → Schedule_Result.User_ID — NOT NULL
  • ID (Key24) — Foreign key → Schedule_Result.ID — NOT NULL
  • ID (Key32) — Foreign key → Schedule_Result.ID — NOT NULL
  • ID (Key223) — Foreign key → Schedule_Result.ID — NOT NULL
  • User_ID (Key5) — Foreign key → User.User_ID — NOT NULL
  • ID (Key25) — Foreign key → User.ID — NOT NULL
  • ID (Key33) — Foreign key → User.ID — NOT NULL
  • ID (Key224) — Foreign key → User.ID — NOT NULL
  • 부적합유형 (Field)
  • 부적합내용 (Field2)
  • 위험등급 (Field3)

Re_Inqury_Action (재점검조치내용)

  • RIA_ID (Key) — Primary key — NOT NULL
  • ReIn_Id (Key2) — Foreign key → Re_Inquiry.ReIn_Id — NOT NULL
  • SR_ID (Key22) — Foreign key → Re_Inquiry.SR_ID — NOT NULL
  • Sche_ID (Key222) — Foreign key → Re_Inquiry.Sche_ID — NOT NULL
  • TeamID (Key2222) — Foreign key → Re_Inquiry.TeamID — NOT NULL
  • ID (Key22222) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key3) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key23) — Foreign key → Re_Inquiry.ID — NOT NULL
  • User_ID (Key4) — Foreign key → Re_Inquiry.User_ID — NOT NULL
  • ID (Key24) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key32) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key223) — Foreign key → Re_Inquiry.ID — NOT NULL
  • User_ID (Key5) — Foreign key → Re_Inquiry.User_ID — NOT NULL
  • ID (Key25) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key33) — Foreign key → Re_Inquiry.ID — NOT NULL
  • ID (Key224) — Foreign key → Re_Inquiry.ID — NOT NULL
  • User_ID (Key6) — Foreign key → User.User_ID — NOT NULL
  • ID (Key26) — Foreign key → User.ID — NOT NULL
  • ID (Key34) — Foreign key → User.ID — NOT NULL
  • ID (Key225) — Foreign key → User.ID — NOT NULL
  • 조치일시 (Field)
  • 조치내용 (Field2)
  • 조치상태 (Field3)

Schedule (점검스케줄)

  • Sche_ID (Key) — Primary key — NOT NULL
  • TeamID (Key2) — Foreign key → Team.TeamID — NOT NULL
  • ID (Key22) — Foreign key → Team.ID — NOT NULL
  • ID (Key3) — Foreign key → Individual Equipment.Equip_Idv_ID — NOT NULL
  • ID (Key23) — Foreign key → Individual Equipment.ID — NOT NULL
  • 점검주기 (Field)
  • 대상 (Field2)
  • 담당팀 (Field3)
  • 점검사진 (Field4)

Schedule_Result (점검결과)

  • SR_ID (Key) — Primary key — NOT NULL
  • Sche_ID (Key2) — Foreign key → Schedule.Sche_ID — NOT NULL
  • TeamID (Key22) — Foreign key → Schedule.TeamID — NOT NULL
  • ID (Key222) — Foreign key → Schedule.ID — NOT NULL
  • ID (Key3) — Foreign key → Schedule.ID — NOT NULL
  • ID (Key23) — Foreign key → Schedule.ID — NOT NULL
  • User_ID (Key4) — Foreign key → User.User_ID — NOT NULL
  • ID (Key24) — Foreign key → User.ID — NOT NULL
  • ID (Key32) — Foreign key → User.ID — NOT NULL
  • ID (Key223) — Foreign key → User.ID — NOT NULL
  • 점검일시 (Field)
  • 점검상태 (Field2)
  • 종합의견 (Field3)
  • 점검회차 (Field4)

Team (팀)

  • TeamID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Org.Org_ID — NOT NULL
  • 팀명 (Field)

User (직원)

  • User_ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Team.TeamID — NOT NULL
  • ID (Key3) — Foreign key → Position.PositionID — NOT NULL
  • ID (Key22) — Foreign key → Team.ID — NOT NULL
  • 이름 (Field)
  • 비밀번호 (Field2)
  • 전화번호 (Field3)
  • 이메일 (Field4)
  • 입사일 (Field5)
  • 권한 (Field6)
  • 재직상태 (Field7)
  • 프로필사진 (Field8)