lifesemantics

Tables (3)

thospital (Untitled)

  • PK (hospital_idx) — INT(11) — Primary key — NOT NULL
  • 병원 이름 (hospital_name) — VARCHAR(50)
  • 병원 주소 (hospital_addr) — VARCHAR(200)
  • 전화 번호 (hospital_tel) — VARCHAR(50)
  • 요양기관번호 (hospital_ykiho) — VARCHAR(200)

treservation (Untitled3)

  • PK (reservationd_idx) — INT(11) — Primary key — NOT NULL
  • 병원PK (hospital_idx) — INT(11) — Foreign key → thospital.PK — NOT NULL
  • 유저PK (user_idx) — INT(11) — Foreign key → tuser.PK — NOT NULL
  • 증상 (symptom) — TEXT
  • 예약일시 (reservation_date) — DATETIME
  • 이미지 (image) — VARCHAR
  • 전화번호 (cellphone) — VARCHAR

tuser (Untitled2)

  • PK (user_idx) — INT(11) — Primary key — NOT NULL
  • 유저ID (user_id) — VARCHAR(200)
  • 유저PWD (user_pwd) — VARCHAR(200)
  • 유저이름 (user_name) — VARCHAR(100)