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)