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