amj

Tables (4)

clinic_record

  • clinic_record_idx — int(11) — Primary key — NOT NULL
  • patient_idx — int(11) — Foreign key → patient.patient_idx
  • clinic_date_time — datetime
  • clinic_record_video — varchar(50)

log_data

  • log_data_idx — int(11) — Primary key — NOT NULL
  • log_type — tinyint(4) — 로그타입(좌우:0,상하:1)
  • log_value — double — 로그값
  • log_time_value — double — 로그시간 값
  • client_record_idx — int(11) — Foreign key → clinic_record.clinic_record_idx

patient

  • patient_idx — int(11) — Primary key — NOT NULL
  • patient_name — int(11)

user

  • user_idx — int(11) — Primary key — NOT NULL
  • user_id — varchar(50)
  • user_password — varchar(50)
  • user_group — varchar(50)