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 (기타)