GD HEALTH
Tables (25)
answer
- answer_no — int(11) — Primary key — NOT NULL
- question_no — int(11) — Foreign key → question.question_no — NOT NULL
- employee_no — int(11) — Foreign key → employee.employee_no — NOT NULL
- answer_content — varchar(50) — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
branch
- branch_no — int(11) — Primary key — 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 비활성화(폐점)
chat_message
- chat_message_no — int(11) — Primary key — NOT NULL
- chat_room_no — int(11) — Foreign key → chat_room.chat_room_no — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no
- employee_no — int(11) — Foreign key → employee.employee_no
- message_content — text
- createdate — datetime — NOT NULL
chat_room
- chat_room_no — int(11) — Primary key — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- createdate — datetime — NOT NULL
customer
- customer_no — int(11) — Primary key — 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) — Primary key — NOT NULL
- program_reservation_no — int(11) — Foreign key → program_reservation.program_reservation_no — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- branch_no — int(11) — Foreign key → branch.branch_no — NOT NULL
- customer_attendance_date — date — NOT NULL
- customer_attendance_enter_time — time — NOT NULL
- customer_attendance_exit_time — time
customer_detail
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- customer_name — varchar(50) — NOT NULL
- customer_gender — enum('남','여','비활성') — NOT NULL
- customer_height — double — NOT NULL
- customer_weight — double — NOT NULL
- customer_birth — date — NOT NULL
- customer_phone — varchar(50) — NOT NULL
- customer_address — varchar(50) — NOT NULL
- customer_email — varchar(50) — NOT NULL
- createdate — date — NOT NULL
- updatedate — date — NOT NULL
customer_img
- customer_img_no — int(11) — Primary key — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- customer_img_origin_name — varchar(200) — NOT NULL
- customer_img_file_name — varchar(200) — NOT NULL
- customer_img_size — int(11) — NOT NULL
- customer_img_type — varchar(50) — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
employee
- employee_no — int(11) — Primary key — NOT NULL
- branch_no — int(11) — Foreign key → branch.branch_no — NOT NULL
- employee_id — varchar(50) — NOT NULL
- employee_pw — varchar(50) — NOT NULL
- employee_active — enum('Y', 'N') — NOT NULL — Y 활성 N 비활성(퇴사)
- employee_position — enum('trainer', 'branch_manager', 'head_office_manager') — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
employee_detail
- employee_no — int(11) — Foreign key → 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('m','f') — NOT NULL
- createdate — date — NOT NULL
- updatedate — date — NOT NULL
employee_img
- employee_img_no — int(11) — Primary key — NOT NULL
- employee_no — int(11) — Foreign key → employee.employee_no — NOT NULL
- employee_img_origin_name — varchar(100) — NOT NULL
- employee_img_file_name — varchar(100) — NOT NULL
- employee_img_size — int(11) — NOT NULL
- employee_img_type — varchar(50) — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
membership
- membership_no — int(11) — Primary key — NOT NULL
- membership_name — varchar(50) — NOT NULL — 이용권 이름
- membership_month — varchar(50) — NOT NULL — 이용권 기간
- membership_price — varchar(50) — NOT NULL — 가격
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
- active — enum('Y', 'N') — NOT NULL
notice
- notice_no — int(11) — Primary key — NOT NULL
- employee_no — int(11) — Foreign key → employee.employee_no — 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) — Primary key — NOT NULL
- membership_no — int(11) — Foreign key → membership.membership_no — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- payment_date — date — NOT NULL
- createdate — date — NOT NULL
- updatedate — date — NOT NULL
- active — enum('Y','N') — NOT NULL
program
- program_no — int(11) — Primary key — NOT NULL
- writer_employee_no — int(11) — Foreign key → employee.employee_no — NOT NULL
- program_name — varchar(50) — NOT NULL
- program_detail — text
- program_max_customer — int(11) — NOT NULL — 최대수용인원
- program_active — enum('Y', 'N') — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
program_date
- program_date_no — int(11) — Primary key — NOT NULL
- program_no — int(11) — Foreign key → program.program_no — NOT NULL
- program_date — date — NOT NULL
- createdate — date — NOT NULL
- updatedate — date — NOT NULL
program_img
- program_img_no — int(11) — Primary key — NOT NULL
- program_no — int(11) — Foreign key → program.program_no — NOT NULL
- program_img_origin — varchar(50) — NOT NULL
- program_img_file — varchar(50) — NOT NULL
- program_img_size — int(11) — NOT NULL
- program_img_type — varchar(50) — NOT NULL
- createdate — date — NOT NULL
- updatedate — date — NOT NULL
program_manager
- program_manager_no — int(11) — Primary key — NOT NULL
- program_date_no — int(11) — Foreign key → program_date.program_date_no — NOT NULL
- program_no — int(11) — Foreign key → program.program_no — NOT NULL
- trainer_employee_no — int(11) — Foreign key → employee.employee_no — NOT NULL
program_reservation
- program_reservation_no — int(11) — Primary key — NOT NULL
- payment_no — int(11) — Foreign key → payment.payment_no — NOT NULL
- program_date_no — int(11) — Foreign key → program_date.program_date_no — NOT NULL
- branch_no — int(11) — Foreign key → branch.branch_no — NOT NULL
- program_reservation_date — datetime — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
question
- question_no — int(11) — Primary key — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- branch_no — int(11) — Foreign key → branch.branch_no — NOT NULL
- question_title — varchar(50) — NOT NULL
- question_content — text — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
- isSecret — enum('TRUE','FALSE')
review
- review_no — int(11) — Primary key — NOT NULL
- program_reservation_no — int(11) — Foreign key → program_reservation.program_reservation_no — NOT NULL
- customer_no — int(11) — Foreign key → customer.customer_no — NOT NULL
- review_title — varchar(50) — NOT NULL
- review_content — varchar(50) — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
review_img
- review_img_no — int(11) — Primary key — NOT NULL
- review_no — int(11) — Foreign key → review.review_no — NOT NULL
- review_img_origin — varchar(50)
- review_img_file — varchar(50)
- review_img_size — int(11)
- review_img_type — varchar(50)
- createdate — date
- updatedate — date
sports_equipment
- sports_equipment_no — int(11) — Primary key — NOT NULL
- writer_employee_no — int(11) — NOT NULL
- item_name — varchar(50) — NOT NULL
- item_price — int(11) — NOT NULL
- note — text — NOT NULL
- active — enum('Y','N') — NOT NULL
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
sports_equipment_img
- sports_equipment_img_no — int(11) — Primary key — NOT NULL
- sports_equipment_no — int(11) — Foreign key → 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) — Primary key — NOT NULL
- employee_orderer — int(11) — Foreign key → employee.employee_no — NOT NULL
- branch_no — int(11) — Foreign key → branch.branch_no — NOT NULL — 주문매장no, 1111
- sports_equipment_no — int(11) — Foreign key → sports_equipment.sports_equipment_no — NOT NULL — 물품번호,외래키
- quantity — int(11) — NOT NULL — 수량
- total_price — int(11) — NOT NULL — 총 가격
- createdate — datetime — NOT NULL
- updatedate — datetime — NOT NULL
- employee_approver — int(11) — Foreign key → employee.employee_no — NOT NULL
- order_status — enum('승인', '거부', '대기') — NOT NULL