DTX EYE

Tables (3)

Equipment (Untitled2)

  • 장비번호 (id) — NOT NULL — Primary key — NOT NULL
  • 환자번호 (id2) — NOT NULL — Foreign key → Patient.환자번호 — NOT NULL
  • 착용시간 (wearingTime) — NOT NULL
  • (하루)착용해야하는 시간 (dayTimeToWear) — NOT NULL

Patient (Untitled)

  • 환자번호 (id) — NOT NULL — Primary key — NOT NULL
  • 환자이름 (patinetName) — NOT NULL
  • 생일 (birthday) — NOT NULL
  • 성별 (gender) — NOT NULL
  • 전화번호 (phoneNumber) — NOT NULL
  • 보호자 전화번호 (guardianPhoneNumber) — NULL

Time (Untitled1)

  • 환자번호 (id) — NOT NULL — Foreign key → Patient.환자번호 — NOT NULL
  • 교정시간 (correctionTime) — NOT NULL
  • 교정날짜 (correctionDay) — NOT NULL
  • 착용날짜 (wearingDay) — NOT NULL