가맹점 계약 및 모집공고

테이블 (7)

branch_evaluation_questions

  • grading_criteria_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • question_code — VARCHAR(20)
  • member_id — VARCHAR(20)
  • list_of_branch_evaluation_questions — DATE

branch_evaluation_response_and_grade

  • grading_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • question_code — VARCHAR(20)
  • list_of_branch_evaluation_questions — VARCHAR(20)
  • applicant_response — VARCHAR(20)
  • score_after_grading — INTEGER(20)
  • grading_criteria_code (Key3) — VARCHAR(20) — 외래 키 → branch_evaluation_questions.grading_criteria_code — NOT NULL
  • branch_recruit_code (Key4) — VARCHAR(20) — 외래 키 → branch_recruit_announcement.branch_recruit_code — NOT NULL

branch_evaluation_scoring_criteria

  • grading_criteria_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • question_code — VARCHAR(20)
  • list_of_branch_evaluation_questions — VARCHAR(20)
  • standard — VARCHAR(20)
  • more — VARCHAR(20)
  • under — VARCHAR(20)
  • score_num — VARCHAR(20)
  • score — INTEGER(20)
  • evaluation_criteria_date — INTEGER(20)
  • cooupon_register_time — DATE
  • grading_criteria_code (Key2) — VARCHAR(20) — 외래 키 → branch_evaluation_questions.grading_criteria_code — NOT NULL

branch_final_decision_total_sum_evaluation

  • pass_or_not_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • evaluation_total_score — INTEGER(20)
  • pass_or_not — VARCHAR(20)
  • branch_recruit_code (Key3) — VARCHAR(20) — 외래 키 → branch_recruit_announcement.branch_recruit_code — NOT NULL

branch_recruit_announcement

  • branch_recruit_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • branch_recruit_religion — VARCHAR(20)
  • branch_recruit_year — INTEGER(20)
  • branch_recruitment_round — INTEGER(3)
  • branch_recruitment_period — DATE
  • recruitment_progress_status — VARCHAR(20)

final_branch_agreement

  • final_contract_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • pass_or_not_code — VARCHAR(20)
  • school_map — VARCHAR(20)
  • operation_start_date — DATE
  • operation_end_date — DATE
  • operation_education_period — VARCHAR(20)
  • deposit_dat — DATE
  • royalty_payment_criteria — VARCHAR(20)
  • contract_payment — VARCHAR(20)
  • assurance_payment — VARCHAR(20)
  • deposit_payment_status — VARCHAR(20)
  • contract_status — VARCHAR(20)
  • operation_approve_id — VARCHAR(20)
  • operation_approve_date — DATE
  • pass_or_not_code (Key3) — VARCHAR(20) — 외래 키 → branch_final_decision_total_sum_evaluation.pass_or_not_code — NOT NULL

total_branch_apply_evaluation

  • total_evaluation_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • school_map — VARCHAR(20)
  • total (item_total) — INTEGER(20)
  • registrant_id — VARCHAR(20)
  • apply_evaluation_total_register_time — VARCHAR(20)
  • branch_recruit_code (Key4) — VARCHAR(20) — 외래 키 → branch_recruit_announcement.branch_recruit_code — NOT NULL