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