kh_final_pro

Tables (12)

Admin (관리자)

  • a_id (관리자아이디) — Primary key — NOT NULL
  • a_pw (관리자비밀번호)

Doctor (의사)

  • hos_id (병원아이디) — Foreign key → Hospital.hos_id — NOT NULL
  • hos_doctor (의사)
  • hos_type (진료과)
  • hos_time (진료가능시간)

Event (이벤트)

  • eno (이벤트번호) — Primary key — NOT NULL
  • e_subject (이벤트제목)
  • e_content (이벤트내용)
  • hos_id (병원아이디) — Foreign key → Hospital.hos_id — NOT NULL

EventCate (이벤트종류)

  • eno (이벤트번호) — Foreign key → Event.eno — NOT NULL
  • e_price (이벤트가격)
  • e_type (이벤트종류)

Hospital (병원)

  • hos_id (병원아이디) — Primary key — NOT NULL
  • hos_name (병원이름)
  • hos_addres (병원주소)
  • hos_lat (위도)
  • hos_lon (경도)
  • hos_phone (전화번호)
  • hos_url (홈페이지)

Member (회원)

  • id (아이디) — Primary key — NOT NULL
  • pw (비밀번호)
  • name (이름)
  • address (주소)
  • phone (전화번호)
  • birth (생년월일)
  • kakao_id (카카오ID)

Notice (공지사항)

  • num (게시판번호) — Primary key — NOT NULL
  • writer (작성자)
  • subject (제목)
  • content (내용)
  • readcount (조회수)
  • upload (파일경로)
  • reg_date (등록일)
  • a_id (관리자아이디) — Foreign key → Admin.a_id — NOT NULL

Pharmacy (약국)

  • ph_id (약국아이디) — Primary key — NOT NULL
  • ph_name (약국이름)
  • ph_address (약국주소)
  • ph_lat (위도)
  • ph_lon (경도)
  • ph_phone (전화번호)
  • ph_url (홈페이지)

Reserve (예약)

  • rno (예약번호) — Primary key — NOT NULL
  • re_date (예약일)
  • re_time (예약시간)
  • category (진료항목)
  • message (남기는메시지)
  • re_state (예약상태)
  • id (아이디) — Foreign key → Member.id — NOT NULL
  • medicine (처방약)

Reserve_stat (예약현황)

  • hos_id (병원아이디) — Foreign key → Hospital.hos_id — NOT NULL
  • rno (예약번호) — Foreign key → Reserve.rno — NOT NULL

Review (후기)

  • vino (후기번호) — Primary key — NOT NULL
  • vi_image (이미지경로)
  • vi_subject (후기제목)
  • vi_content (후기내용)
  • hos_id (병원아이디) — Foreign key → Hospital.hos_id — NOT NULL

Review_com (댓글)

  • cno (댓글번호) — Primary key — NOT NULL
  • content (댓글내용)
  • vino (후기번호) — Foreign key → Review.vino — NOT NULL