출장보고서

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