출장보고서
테이블 (4)
btr_image
- file_id (FILE_ID) — NOT NULL — 기본 키 — NOT NULL
- file_name (FILE_NAME) — NOT NULL
- created_date (CREATED_DATE) — NULL — 촬영 날짜
- created_location (CREATED_LOCATION) — NULL — 촬영 주소
- image_file (IMAGE_FILE) — NOT NULL — NOT NULL — 바이너리 이미지
- memberUniqId (MEMBER_UNIQ_ID) — NOT NULL — 외래 키 → user.memberUniqId — NOT NULL
btr_report
- report_id (REPORT_ID) — NOT NULL — 기본 키 — NOT NULL
- report_content (REPORT_CONTENT) — NOT NULL — 보고 내용
- approver_num (APPROVER_NUM) — NOT NULL — 결재자수
- memberUniqId (MEMBER_UNIQ_ID) — NOT NULL — 외래 키 → user.memberUniqId — NOT NULL
- author_name (AUTHOR_NAME)
- report_date (REPORT_DATE) — NOT NULL
- report_location (REPORT_LOCATION) — NOT NULL
btr_report_image
- file_id (FILE_ID) — NOT NULL — 외래 키 → btr_image.file_id — NOT NULL
- report_id (REPORT_ID) — NOT NULL — 외래 키 → btr_report.report_id — NOT NULL
user
- memberUniqId (Key) — NOT NULL — 기본 키 — NOT NULL