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