LiverGuard

Tables (5)

Drug (약)

  • drug_id — INT — Primary key — NOT NULL
  • drug_name — VARCHAR(255)
  • DISC — TEXT
  • drug_type — VARCHAR(255)

doctors (의사)

  • doctor_id — INT — Primary key — NOT NULL — 의사ID (PK)
  • doctor_name — VARCHAR(100) — NOT NULL — 이름
  • doctor_sex — ENUM('male', 'female') — 성별
  • doctor_phone — VARCHAR(11) — 전화번호(숫자만)
  • doctor_email — VARCHAR(100) — 이메일
  • doctor_status — ENUM('진료중', '진료대기', '휴무') — NOT NULL — 상태
  • profile_image — LONGBLOB — 프로필 이미지(blob)

medical_records (진료 기록)

  • record_id — INT — Primary key — NOT NULL — 진료기록ID (PK)
  • record_date — DATE — NOT NULL — 진료날짜
  • record — TEXT — NOT NULL — 진료내용
  • doctor_id — INT — Foreign key → doctors.doctor_id — NOT NULL — 의사ID (PK)
  • patient_id — INT — Foreign key → patients.patient_id — NOT NULL — 환자ID (PK)

patients (환자)

  • patient_id — INT — Primary key — NOT NULL — 환자ID (PK)
  • patient_name — VARCHAR(100) — NOT NULL — 이름
  • patient_sex — ENUM('male', 'female') — 성별
  • patient_phone — VARCHAR(11) — NOT NULL — 전화번호(숫자만)
  • patient_rrnum — VARCHAR(13) — NOT NULL — 주민등록번호(13자리)
  • patient_address — VARCHAR(100) — NOT NULL — 주소
  • doctor_id — INT — Foreign key → doctors.doctor_id — NOT NULL — 의사ID (PK)

prescriptions (처방전)

  • prescription_id — INT — Primary key — NOT NULL — 처방전ID (PK)
  • prescription — TEXT — NOT NULL — 처방전 내용
  • due_date — DATE — NOT NULL — 복용기한
  • record_id — INT — Foreign key → medical_records.record_id — NOT NULL — 진료기록ID (PK)
  • drug_id — INT — Foreign key → Drug.drug_id — NOT NULL