cleaning system

Tables (6)

ci_sessions (세션)

  • id (Key) — Primary key — NOT NULL
  • ip_adress (Field2)
  • timestamp (Field)
  • data (Field3)

cleaning_history (청소이력)

  • r_id (호실) — Primary key — NOT NULL
  • idx (번호) — Foreign key → room.idx — NOT NULL
  • r_id (호실2) — Foreign key → room.r_id — NOT NULL
  • r_id (Key) — Foreign key → room.r_id — NOT NULL
  • r_id (호실22) — Foreign key → room.r_id — NOT NULL
  • start_datetime (시작일)
  • step1_name (1단계담당자)
  • step1_time (1단계완료시간)
  • step2_name (2단계담당자)
  • step2_time (2단계완료시간)
  • step3_name (3단계담당자)
  • step3_time (3단계완료시간)
  • file (완료사진)

maintenance_history (정비이력)

  • r_id (호실) — Primary key — NOT NULL
  • idx (번호) — Foreign key → room.idx — NOT NULL
  • r_id (호실2) — Foreign key → room.r_id — NOT NULL
  • r_id (Key) — Foreign key → room.r_id — NOT NULL
  • r_id (호실22) — Foreign key → room.r_id — NOT NULL
  • datetime (신고일)
  • name (신고자)
  • completeby (완료자)
  • contents (작업내용)
  • file_before (작업전사진)
  • file_after (작업후사진)

request_clening (청소요청현황)

  • r_id (호수) — Primary key — NOT NULL
  • req_datetime (요청시간)
  • req_name (요청자)
  • cl_startime (시작시간)
  • cl_endtime (종료시간)

request_maintenance (정비요청현황)

  • r_id (호실) — Primary key — NOT NULL
  • mat_datetime (요청시간)
  • mat_name (요청자)
  • contents (요청내용)

room (호실정보)

  • idx (번호) — Primary key — NOT NULL
  • r_id (호실) — Primary key — NOT NULL
  • r_id (Key) — Foreign key → request_clening.r_id — NOT NULL
  • r_id (호실2) — Foreign key → request_maintenance.r_id — NOT NULL
  • floor (층)
  • type (타입)
  • scale (크기)
  • status (상태)
  • cleaning_date (청소일)
  • etc (기타)