Meditem
Tables (12)
Admission (입원)
- ssn (Key) — Foreign key → Patient.ssn — NOT NULL
- Id (Key2) — Foreign key → Patient.Id — NOT NULL
- department_name (Key22) — Foreign key → Patient.department_name — NOT NULL
- business_id (Key222) — Foreign key → Patient.business_id — NOT NULL
Building (건물)
- building_id (Key2) — Primary key — NOT NULL
- business_id (Key) — Foreign key → Hospital.business_id — NOT NULL
City (도시)
- province (Key) — Primary key — NOT NULL
- borough (Key2) — Primary key — NOT NULL
Hospital (병원)
- business_id (Key) — Primary key — NOT NULL
- province (Key2) — Foreign key → City.province — NOT NULL
- borough (Key22) — Foreign key → City.borough — NOT NULL
- hospital_name (Field)
Medical Department (진료과)
- department_name (Key) — Primary key — NOT NULL
- business_id (Key2) — Foreign key → Hospital.business_id — NOT NULL
Medical Person (의료인)
- Id (Key) — Primary key — NOT NULL
- department_name (Key2) — Foreign key → Medical Department.department_name — NOT NULL
- business_id (Key22) — Foreign key → Medical Department.business_id — NOT NULL
- name (Field)
- job (Field2)
- salary (Field3)
Medical Record (진료기록)
- medical_id (Key) — Primary key — NOT NULL
- ssn (Key2) — Foreign key → Patient.ssn — NOT NULL
- Id (Key3) — Foreign key → Medical Person.Id — NOT NULL
- department_name (Key22) — Foreign key → Medical Person.department_name — NOT NULL
- business_id (Key222) — Foreign key → Medical Person.business_id — NOT NULL
- medical_name (Field)
- date (Field2)
- cost (Field3)
- department_name (Key23) — Foreign key → Medical Person.department_name — NOT NULL
- business_id (Key223) — Foreign key → Medical Person.business_id — NOT NULL
Medicine (약)
- medical_id (Key) — Foreign key → Prescription.medical_id — NOT NULL
- ssn (Key2) — Foreign key → Prescription.ssn — NOT NULL
- Id (Key3) — Foreign key → Prescription.Id — NOT NULL
- department_name (Key22) — Foreign key → Prescription.department_name — NOT NULL
- business_id (Key222) — Foreign key → Prescription.business_id — NOT NULL
- medicine_name (Field)
Patient (환자)
- ssn (Key) — Primary key — NOT NULL
- Id (Key2) — Foreign key → Medical Person.Id — NOT NULL
- department_name (Key22) — Foreign key → Medical Person.department_name — NOT NULL
- business_id (Key222) — Foreign key → Medical Person.business_id — NOT NULL
- name (Field)
- age (Field2)
- sex (Field3)
Prescription (처방전)
- medical_id (Key) — Foreign key → Medical Record.medical_id — NOT NULL
- ssn (Key2) — Foreign key → Medical Record.ssn — NOT NULL
- Id (Key3) — Foreign key → Medical Record.Id — NOT NULL
- department_name (Key22) — Foreign key — NOT NULL
- business_id (Key222) — Foreign key — NOT NULL
Room (방)
- room_number (Key) — Primary key — NOT NULL
- building_id (Key22) — Foreign key → Building.building_id — NOT NULL
- Id (Key23) — Foreign key → Admission.Id — NOT NULL
- department_name (Key222) — Foreign key → Admission.department_name — NOT NULL
- business_id (Key2222) — Foreign key → Admission.business_id — NOT NULL
Surgical Record (수술기록)
- surgical_Id (Key3) — Primary key — NOT NULL
- ssn (Key) — Foreign key → Patient.ssn — NOT NULL
- Id (Key2) — Foreign key → Medical Person.Id — NOT NULL
- department_name (Key22) — Foreign key → Medical Person.department_name — NOT NULL
- business_id (Key222) — Foreign key → Medical Person.business_id — NOT NULL
- room_number (Key4) — Foreign key → Room.room_number — NOT NULL
- building_id (Key223) — Foreign key → Room.building_id — NOT NULL
- Id (Key232) — Foreign key → Room.Id — NOT NULL
- department_name (Key2222) — Foreign key → Room.department_name — NOT NULL
- business_id (Key22222) — Foreign key → Room.business_id — NOT NULL