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