가맹점 계약 및 모집공고
테이블 (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