팀

테이블 (24)

branch

  • branch_no — int(11) — 기본 키 — NOT NULL
  • branch_name — varchar(50) — NOT NULL
  • branch_tel — varchar(50) — NOT NULL
  • branch_address — varchar(50) — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL
  • branch_level — enum('1', '0') — NOT NULL — 1이 본점, 0은 분점
  • branch_active — enum('Y', 'N') — NOT NULL — Y 활성화, N 비활성화(폐점)

contact

  • contact_no — int(11) — 기본 키 — NOT NULL
  • branch_no — int(11) — 외래 키 → branch.branch_no — NOT NULL — 상담 선호 지점
  • customer_birth — date — NOT NULL
  • customer_contact_date — datetime — NOT NULL
  • customer_name — varchar(50) — NOT NULL
  • contact_content — text — NOT NULL
  • createdate — datetime — NOT NULL
  • customer_phone — varchar(50) — NOT NULL

customer

  • customer_no — int(11) — 기본 키 — NOT NULL
  • customer_id — varchar(50) — NOT NULL
  • customer_pw — varchar(50) — NOT NULL
  • customer_active — enum('Y', 'N') — NOT NULL — Y 활성화 N 비활성화(탈퇴)
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

customer_attendance

  • customer_attendance_no — int(11) — 기본 키 — NOT NULL
  • program_reservation_no — int(11) — 외래 키 → program_reservation.program_reservation_no — NOT NULL
  • customer_attendance_date — date — NOT NULL
  • customer_attendance_enter_time — time — NOT NULL
  • customer_attendance_exit_time — time — insert 실행 시점에선 퇴실시간을 모르기에 Null 기본값

customer_detail

  • customer_no — int(11) — 외래 키 → customer.customer_no — NOT NULL
  • customer_name — varchar(50) — NOT NULL
  • customer_gender — enum('남', '여') — NOT NULL
  • customer_height — int(11) — NOT NULL
  • customer_weight — int(11) — NOT NULL
  • customer_phone — varchar(50) — NOT NULL
  • customer_address — varchar(50) — NOT NULL
  • customer_email — varchar(50) — NOT NULL
  • customer_membership_end — date — NOT NULL — 멤버십 기간 종료일(결제 시 update)
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

customer_img

  • customer_img_no — int(11) — 기본 키 — NOT NULL
  • customer_no — int(11) — 외래 키 → customer.customer_no — NOT NULL
  • customer_img_origin_name — text — NOT NULL
  • customer_img_file_name — text — NOT NULL
  • customer_img_size — int(11) — NOT NULL
  • customer_img_type — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

employee

  • employee_no — int(11) — 기본 키 — NOT NULL
  • branch_no — int(11) — 외래 키 → branch.branch_no — NOT NULL
  • employee_id — varchar(50) — NOT NULL — 매니저(M) 트레이너(T)
  • employee_pw — varchar(50) — NOT NULL
  • employee_active — enum('Y', 'N') — NOT NULL — Y 활성 N 비활성(퇴사)
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

employee_detail

  • employee_no — int(11) — 외래 키 → employee.employee_no — NOT NULL
  • employee_name — varchar(50) — NOT NULL
  • employee_phone — varchar(50) — NOT NULL
  • employee_email — varchar(50) — NOT NULL
  • employee_gender — enum('남','여') — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

employee_img

  • employee_img_no — int(11) — 기본 키 — NOT NULL
  • employee_no — int(11) — 외래 키 → employee.employee_no — NOT NULL
  • employee_img_origin_name — text — NOT NULL
  • employee_img_file_name — text — NOT NULL
  • employee_img_size — int(11) — NOT NULL
  • employee_img_type — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

membership

  • membership_no — int(11) — 기본 키 — NOT NULL
  • membership_name — varchar(50) — NOT NULL — 이용권 이름
  • membership_month — int(11) — NOT NULL — 이용권 기간
  • membership_price — varchar(50) — NOT NULL — 가격
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

notice

  • notice_no — int(11) — 기본 키 — NOT NULL
  • employee_id — varchar(50) — 외래 키 → employee.employee_id — NOT NULL
  • notice_title — varchar(50) — NOT NULL
  • notice_content — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

payment

  • payment_no — int(11) — 기본 키 — NOT NULL
  • customer_id — varchar(50) — 외래 키 → customer.customer_id — NOT NULL
  • payment_membership_no — int(11) — 외래 키 → membership.membership_no — NOT NULL
  • payment_date — date — NOT NULL
  • payment_price — int(11) — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

program

  • program_no — int(11) — 기본 키 — NOT NULL
  • employee_id — varchar(50) — 외래 키 → employee.employee_id — NOT NULL
  • program_name — varchar(50) — NOT NULL
  • program_max_customer — int(11) — NOT NULL — 하루 최대수용인원
  • program_memo — text — NOT NULL — 프로그램 설명,운동효과
  • program_day — varchar(50) — NOT NULL — 강의 요일
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL
  • program_active — enum('Y', 'N') — 프로그램 활성,비활성

program_date

  • program_date_no — int(11) — 기본 키 — NOT NULL
  • program_no — int(11) — 외래 키 → program.program_no — NOT NULL
  • program_date — date — NOT NULL — 강의 날짜
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

program_img

  • program_img_no — int(11) — 기본 키 — NOT NULL
  • program_no — int(11) — 외래 키 → program.program_no — NOT NULL
  • program_img_origin_name — text — NOT NULL
  • program_img_file_name — text — NOT NULL
  • program_img_size — int(11) — NOT NULL
  • program_img_type — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

program_reservation

  • program_reservation_no — int(11) — 기본 키 — NOT NULL
  • payment_no — int(11) — 외래 키 → payment.payment_no — NOT NULL
  • program_date_no — int(11) — 외래 키 → program_date.program_date_no — NOT NULL
  • branch_no — int(11) — 외래 키 → branch.branch_no — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

question

  • question_no — int(11) — 기본 키 — NOT NULL
  • customer_id — varchar(50) — 외래 키 → customer.customer_id — NOT NULL
  • question_title — varchar(50) — NOT NULL
  • question_content — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

question_reply

  • question_reply_no — int(11) — 기본 키 — NOT NULL
  • question_no — int(11) — 외래 키 → question.question_no — NOT NULL
  • employee_id — varchar(50) — 외래 키 → employee.employee_id — NOT NULL
  • question_reply_content — varchar(50) — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

review

  • review_no — int(11) — 기본 키 — NOT NULL
  • program_reservation_no — int(11) — 외래 키 → program_reservation.program_reservation_no — NOT NULL
  • review_title — varchar(50) — NOT NULL
  • review_content — varchar(50) — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

review_reply

  • review_reply_no — int(11) — 기본 키 — NOT NULL
  • review_no — int(11) — 외래 키 → review.review_no — NOT NULL
  • employee_id — varchar(50) — 외래 키 → employee.employee_id — NOT NULL
  • review_reply_content — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

sports_equipment

  • sports_equipment_no — int(11) — 기본 키 — NOT NULL
  • item_name — varchar(50) — NOT NULL
  • item_price — int(11) — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

sports_equipment_expire

  • sports_equipment_expire_no — int(11) — 기본 키 — NOT NULL
  • sports_equipment_no — int(11) — 외래 키 → sports_equipment.sports_equipment_no — NOT NULL
  • branch_no — int(11) — 외래 키 → sports_equipment_order.branch_no — NOT NULL
  • quantity — int(11) — NOT NULL
  • expire_memo — text — NOT NULL
  • createdate — datetime — NOT NULL

sports_equipment_img

  • sports_equipment_img_no — int(11) — 기본 키 — NOT NULL
  • sports_equipment_no — int(11) — 외래 키 → sports_equipment.sports_equipment_no — NOT NULL
  • sports_equipment_img_origin_name — text — NOT NULL
  • sports_equipment_img_file_name — text — NOT NULL
  • sports_equipment_img_size — int(11) — NOT NULL
  • sports_equipment_img_type — text — NOT NULL
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL

sports_equipment_order

  • order_no — int(11) — 기본 키 — NOT NULL
  • branch_no — int(11) — 외래 키 → branch.branch_no — NOT NULL — 주문매장no, 1111
  • sports_equipment_no — int(11) — 외래 키 → sports_equipment.sports_equipment_no — NOT NULL — 물품번호,외래키
  • quantity — int(11) — NOT NULL — 수량
  • order_status — enum('승인', '거절', '대기')
  • createdate — datetime — NOT NULL
  • updatedate — datetime — NOT NULL