라라
테이블 (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