라라

테이블 (5)

plc_related_regulations

  • id — int
  • bca_id — int — NOT NULL
  • regulations_name — varchar(100)
  • print_yn — enum
  • user_name — varchar(100) — NOT NULL
  • clauses_name1 — varchar(100)
  • clauses_content1 — mediumtext
  • clauses_name2 — varchar(100)
  • clauses_content2 — mediumtext
  • indt — timestamp
  • last_update — timestamp
  • last_update_by — int

plc_report_history

  • id — int
  • receipt_number — varchar(100) — 접수 번호
  • sortation_bca_id — varchar(100) — 신고 구분
  • user_name — varchar(500)
  • phone_number — varchar(500)
  • email — varchar(500)
  • report_target_id_fk — varchar(100) — 신고인 외래키
  • report_class_bca_id — varchar(100) — 신고대상인 (신고구분)
  • report_class_input — varchar(100) — 신고대상인 (신고구분을 기타로 지정시 input 추가
  • target_class_bca_id — varchar(100) — 대상구분 ( 신고 대상인 )
  • target_name — varchar(500) — 신고대상자 이름
  • target_phone_number — varchar(500) — 신고 대상자 폰번호
  • target_email — varchar(100)
  • report_title — varchar(100) — 신고제목
  • date_occurrence — varchar(100) — 발생일자
  • place_occurrence — varchar(100) — 발생장소
  • details_report — varchar(200) — 신고내용
  • current_situation — varchar(100) — 현황
  • contents — mediumtext
  • representative — varchar(100) — NOT NULL — 담당자
  • representative_number — varchar(100) — 담당자 연락처
  • regulation — mediumtext — 관련 규정
  • indt — timestamp — 신고 접수일
  • report_ip — varchar(100)
  • last_update — timestamp
  • last_update_by — varchar(100)
  • dupinfo — varchar(100) — 인증 정보값

plc_report_history_file

  • history_file_id — int
  • history_id_fk — int — NOT NULL
  • file_originname — varchar(300)
  • pif_filename — varchar(700)
  • full_path — varchar(400)
  • file_path — varchar(400)
  • file_size — int
  • file_type — varchar(100)
  • insert_date — timestamp

plc_report_history_pass

  • pass_id — int
  • date — date
  • last_date_update — timestamp
  • content — mediumtext
  • report_id_fk — int

plc_report_target_list

  • report_target_id — int
  • bca_id — int — NOT NULL
  • report_name — varchar(100)
  • print_yn — enum
  • orders — int
  • indt — timestamp