5ho
Tables (5)
admin (관리자)
- a_id (Key) — varchar — Primary key — NOT NULL
- a_pw (Field) — int
doctor (의사)
- d_number (의사고유번호) — int — Primary key — NOT NULL
- d_id (아이디) — varchar
- d_pw (비밀번호) — int
- d_name (의사명) — varchar
- d_class (진료과) — varchar
- d_email (이메일) — varchar
- d_etc (기타) — varchar
- d_image (사진) — varchar
patient (환자)
- p_number (환자고유번호) — int — Primary key — NOT NULL
- p_id (아이디) — varchar
- p_pw (비밀번호) — int
- p_name (환자명) — varchar
- p_gen (환자성별) — varchar
- p_email (환자이메일) — varchar
- p_addr (환자주소) — varchar
- p_height (키) — int
- p_weight (몸무게) — int
- p_etc (기타) — varchar
td_board (의사 진단서 작성게시판)
- td_num (글번호) — int — Primary key — NOT NULL
- tp_num (환자글번호) — int — Foreign key → tp_board.tp_num — NOT NULL
- td_pn (환자고유번호2) — int — Foreign key → tp_board.td_pn — NOT NULL
- td_dn (의사고유번호2) — int — Foreign key → doctor.d_number — NOT NULL
- td_title (진단명) — varchar
- td_content (진단내용) — varchar
tp_board (환자 증상 작성게시판)
- tp_num (환자글번호) — int — Primary key — NOT NULL
- td_pn (환자고유번호2) — int — Foreign key → patient.p_number — NOT NULL
- tp_medicine (복용약) — varchar
- tp_tem (체온) — int
- tp_content (증상내용) — varchar
- tp_dn (의사고유번호) — int