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