성모원안과_예약서비스_서버

테이블 (5)

Untitled (hospital_timetable)

  • Key (id) — INTEGER — 기본 키 — NOT NULL
  • Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (monday) — VARCHAR(4)
  • Field (tuesday) — VARCHAR(4)
  • Field (wednesday) — VARCHAR(4)
  • Field (thursday) — VARCHAR(4)
  • Field (friday) — VARCHAR(4)
  • Field (saturday) — VARCHAR(4)
  • Field (sunday) — VARCHAR(4)
  • Field (holiday) — VARCHAR(4)

Untitled (doctor_info)

  • Key (id) — INTEGER — 기본 키 — NOT NULL
  • Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (doctor_id) — VARCHAR(10)
  • Field2 (doctor_name) — VARCHAR(10)
  • Field3 (doctor_field) — VARCHAR(50)
  • Field (created_date) — DATE
  • Field (updated_date) — DATE

Untitled (reservation_info)

  • Key (id) — INTEGER — 기본 키 — NOT NULL
  • Key (user_id) — VARCHAR(10) — 외래 키 → users.Key — NOT NULL
  • Key (doctor_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (reservation_id) — VARCHAR(30)
  • Field (reservation_date) — DATE
  • Field (reservation_time) — TIMESTAMP
  • (created_date) — DATE
  • Field (updated_date) — DATE

Untitled (hospital_info)

  • Key (id) — INTEGER — 기본 키 — NOT NULL
  • Field (hospital_id) — VARCHAR(10)
  • Field (hospital_name) — VARCHAR(50)
  • Field (hospital_call) — VARCHAR(50)
  • Field (hospital_address) — TEXT
  • Field (created_date) — DATE
  • Field (updated_date) — DATE

users

  • Key (id) — INTEGER — 기본 키 — NOT NULL
  • Field (user_id) — VARCHAR(10)
  • Field2 (user_name) — VARCHAR(50)
  • Field3 (user_email) — VARCHAR(100)
  • Field4 (product) — VARCHAR(50)
  • Field5 (token) — TEXT
  • Field6 (created_date) — TIMESTAMP
  • Field (updated_date) — TIMESTAMP