donation

Tables (21)

donation_appended

  • id — int
  • donation_id — int — NOT NULL
  • title — varchar(200) — NOT NULL — 수집 항목명
  • text — varchar(400) — NOT NULL — 입력값
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

donation_classification_detail_revisions

  • id — int
  • donation_id — int — NOT NULL
  • classification_detail_id — int — NOT NULL
  • item_type — int — NOT NULL
  • unit_price — int — 단가
  • is_unit_price_different — tinyint(1)
  • quantity — int — NOT NULL — 수량
  • note — text — 비고
  • created — json — NOT NULL
  • deleted_at — datetime

donation_classification_details

  • id — int
  • donation_id — int — NOT NULL
  • item_type — varchar(3) — NOT NULL
  • unit_price — int — 단가
  • is_unit_price_different — tinyint(1)
  • quantity — int — NOT NULL — 수량
  • note — text — 비고
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

donation_classification_revisions

  • id — int
  • donation_id — int — NOT NULL
  • note — text
  • created — json — NOT NULL
  • deleted_at — datetime

donation_classifications

  • donation_id — int — NOT NULL
  • note — text
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime
  • box_qty — int — NOT NULL — 박스 수량

donation_collect_revisions

  • id — int
  • collect_id — int — NOT NULL
  • collect_type — varchar(20) — NOT NULL — 수거 유형
  • donation_id — int — NOT NULL
  • basecamp_give_id — varchar(100) — NOT NULL — 베이스탬프 give_id
  • basecamp_area_id — varchar(100) — NOT NULL — 베이스캠프 area_id
  • basecamp_logistics_id — varchar(100) — NOT NULL — 베이스캠프 logistics_id
  • basecamp_api — tinyint(1) — NOT NULL — 베이스캠프 api
  • basecamp_api_name — varchar(50) — NOT NULL — 베이스캠프 api 이름
  • basecamp_call — tinyint(1) — NOT NULL — 베이스캠프 api 호출여부
  • basecamp_limit_call_over — tinyint(1) — NOT NULL
  • sender_mobile — varchar(50) — 보낸사람 휴대전화
  • sender_post_no — varchar(10) — NOT NULL — 보낸사람 우편번호
  • sender_address — varchar(200) — NOT NULL — 보낸사람 주소
  • sender_address_detail — varchar(300) — NOT NULL — 보낸사람 주소상세
  • sender_address_bcode — varchar(20) — NOT NULL — 권역 정보를 받기 위해 필요한 정보
  • sender_address_bname — varchar(20) — NOT NULL — 권역 정보를 받기 위해 필요한 정보
  • sender_note_type — text — NOT NULL — 요청사항 유형(100:공동현관비밀번호,200:자유출입,300:기타)
  • sender_note — text — NOT NULL — 공용 비밀번호 등 기부자가 쓴 요청 사항
  • sender_additional_note — text — NOT NULL
  • administrator_note — varchar(300) — NOT NULL — 수거시 관리자가 적은 특이사항 메모
  • collect_manager_note — text — NOT NULL
  • earliest_date — varchar(8)
  • plan_visit_date — varchar(8)
  • plan_box_quantity — int — NOT NULL — 박스 수량
  • system_note — text — NOT NULL — 수정된필드들
  • admin_account_member_id — int
  • admin_account_member_name — varchar(60) — NOT NULL — admin_account member_id 의 이름
  • created — json — NOT NULL
  • deleted_at — datetime

donation_collects

  • id — int
  • donation_id — int — NOT NULL
  • collect_type — varchar(20) — NOT NULL — 수거 유형
  • basecamp_give_id — varchar(100) — NOT NULL — 베이스탬프 give_id
  • basecamp_area_id — varchar(100) — NOT NULL — 베이스캠프 area_id
  • basecamp_logistics_id — varchar(100) — NOT NULL — 베이스캠프 logistics_id
  • basecamp_api — tinyint(1) — NOT NULL — 베이스캠프 api
  • basecamp_api_name — varchar(50) — NOT NULL — 베이스캠프 api 이름
  • basecamp_call — tinyint(1) — NOT NULL — 베이스캠프 api 호출여부
  • basecamp_limit_call_over — tinyint(1) — NOT NULL
  • sender_mobile — varchar(50) — 보낸사람 휴대전화
  • sender_post_no — varchar(10) — NOT NULL — 보낸사람 우편번호
  • sender_address — varchar(200) — NOT NULL — 보낸사람 주소
  • sender_address_detail — varchar(300) — NOT NULL — 보낸사람 주소상세
  • sender_address_bcode — varchar(20) — NOT NULL — 권역 정보를 받기 위해 필요한 정보(bcode)
  • sender_address_bname — varchar(20) — NOT NULL — 권역 정보를 받기 위해 필요한 정보(bname)
  • sender_note_type — varchar(20) — NOT NULL — 요청사항 유형(100:공동현관비밀번호,200:자유출입,300:기타)
  • sender_note — text — NOT NULL — 공용 비밀번호 등 기부자가 쓴 요청 사항
  • sender_additional_note — text — NOT NULL
  • administrator_note — text — NOT NULL — 수거시 관리자가 적은 특이사항 메모
  • collect_manager_note — text — NOT NULL
  • earliest_date — varchar(8)
  • plan_visit_date — varchar(8)
  • plan_box_quantity — int — NOT NULL — 박스 수량
  • system_note — text — NOT NULL — 수정된필드들
  • admin_account_member_id — int
  • admin_account_member_name — varchar(60) — NOT NULL — admin_account member_id 의 이름
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

donation_date_revisions

  • id — int
  • donation_id — int — NOT NULL
  • donation_date — varchar(8) — NOT NULL
  • note — varchar(2000) — NOT NULL
  • donation_classification_revision_id — int — NOT NULL
  • created — json — NOT NULL

donation_files

  • id — int
  • donation_id — int — NOT NULL
  • purpose — varchar(50) — NOT NULL
  • document_approval_info — json — 베이스캠프결재문서정보
  • file_info — json — NOT NULL — 파일 유형 및 파일 url
  • confirmed — json
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • del — tinyint(1) — NOT NULL

donation_member_classification_details

  • id — int
  • donation_id — int — NOT NULL
  • item_type — varchar(3) — NOT NULL
  • quantity — int — NOT NULL — 수량
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

donation_relations

  • id — bigint — 기본키' primary ke
  • donation_id — bigint — NOT NULL — 기부 ID
  • master_donation_id — bigint — NOT NULL — 마스터 기부 ID
  • campaign_type — varchar(50) — NOT NULL — 캠페인 타입 (TOGETHER, GENERAL 등)
  • is_master — tinyint(1) — NOT NULL — 마스터 기부 여부 (1: 마스터, 0: 참여)
  • created_at — datetime — NOT NULL — 생성일시
  • deleted — tinyint(1) — NOT NULL

donation_standbys

  • id — int
  • donation_id — int — NOT NULL
  • site_type — varchar(50) — NOT NULL — STORE
  • site_code — varchar(10) — site ID
  • standby_date — varchar(8) — 대기일자
  • standby_no — int — NOT NULL — 대기번호
  • member_id — int — NOT NULL — 멤버id
  • member_mobile — varchar(100) — NOT NULL — 휴대전화
  • member_nickname — varchar(100) — NOT NULL — nickname
  • item_registered — tinyint(1) — 아이템등록여부
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime
  • old_member_id — int

donation_status_revision_memos

  • id — int — NOT NULL — donation_status_revisions_id' primary ke
  • note — varchar(2000) — NOT NULL — note
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

donation_status_revisions

  • id — int
  • donation_id — int — NOT NULL
  • status — varchar(50) — NOT NULL
  • created — json — NOT NULL

donation_summary_logs

  • id — int
  • table_year — varchar(4) — NOT NULL — 집계테이블연도
  • log_date — varchar(8) — NOT NULL — 로그일자
  • table_name — varchar(50) — NOT NULL — 테이블명
  • created_at — datetime — NOT NULL — 생성일시

donations

  • id — int
  • member_id — int — NOT NULL — member ID
  • campaign_id — int — NOT NULL — campaign id
  • campaign_type — varchar(20) — NOT NULL
  • campaign_name — varchar(100) — NOT NULL — campaign 이름
  • status — varchar(50) — NOT NULL — 상태
  • name — varchar(100) — NOT NULL — 접수자
  • mobile — varchar(50) — NOT NULL — 접수자 휴대전화
  • mobile_last_4 — varchar(4)
  • site_type — varchar(50) — NOT NULL — STORE, CENTER
  • site_code — varchar(10) — site ID
  • site_name — varchar(100) — NOT NULL — 사이트 명
  • take_over_method_type — varchar(50) — POSTBOX, VISIT
  • collection_agreed — tinyint(1) — NOT NULL
  • consignment_agreed — tinyint(1) — NOT NULL — 마케팅 사용 동의
  • thirdparty_agreed — tinyint(1) — NOT NULL
  • sharing_type — varchar(3) — NOT NULL — 나눔방식타입
  • eval_type — varchar(10) — NOT NULL — 기부산정방식타입
  • donation_date — varchar(8) — 기부날짜
  • reg_date — varchar(8) — NOT NULL — 기부등록일자
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • confirmed — json
  • deleted_at — datetime
  • appended — tinyint(1) — 추가정보
  • old_member_id — int
  • created_at — datetime

eval_types

  • type — varchar(10) — NOT NULL
  • name — varchar(20) — NOT NULL
  • receipt_available — tinyint — NOT NULL
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

first_donations

  • member_id — int — NOT NULL — 회원번호ID' primary ke
  • donation_id — int — NOT NULL — 첫기부번호
  • created_at — datetime

item_eval_revisions

  • id — int
  • type — varchar(3) — NOT NULL
  • start_date — varchar(8) — NOT NULL — 시작날짜
  • end_date — varchar(8) — 종료날짜
  • unit_price — int — NOT NULL — 표준단가
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

item_types

  • type — varchar(3) — NOT NULL
  • name — varchar(10) — NOT NULL
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime

statuses

  • status — varchar(50) — NOT NULL
  • name — varchar(100) — 기부상태명
  • order_by — int — 정렬순서
  • receipt_available — tinyint(1) — NOT NULL — 기부영수증신청유무
  • created — json — NOT NULL
  • updated — json — NOT NULL
  • deleted_at — datetime