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