yoursky_erd

Tables (10)

DoctorPatientMap (HospitalPatientMap)

  • Key (patient_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
  • Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
  • Field (regist_dt) — DATETIME

Hospital

  • Key (hospital_id) — INT — Primary key — NOT NULL
  • Field (hospital_name) — VARCHAR(100)
  • Field (phone) — VARCHAR(100)
  • Field2 (adress) — VARCHAR(400)
  • Field (intro) — VARCHAR(1000)
  • Field (etc) — VARCHAR(1000)
  • Field (regist_dt) — DATETIME

Questionnaire

  • Key (quest_id) — INT — Primary key — NOT NULL
  • Field (category) — VARCHAR(50)
  • Field (quest_name) — VARCHAR(1000)
  • Field (quest_scoremax) — INT
  • Field (quest_mark) — BOOLEAN
  • Field (optional) — BOOLEAN
  • Field (regist_dt) — DATETIME

Untitled (HospitalDoctorMap)

  • Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
  • Key (doctor_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
  • Field (regist_dt) — DATETIME

Untitled (HospitalSurvey)

  • Key (survey_id) — INT — Primary key — NOT NULL
  • Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
  • Field (survey_name) — VARCHAR(100)
  • Field (survey_week) — INT
  • Field (survey_sort) — VARCHAR(10)
  • Field (regidt_dt) — DATETIME

Untitled (HospitalEnroll)

  • Key (enroll_id) — INT — Primary key — NOT NULL
  • Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
  • Key (user_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
  • Field (enroll_state) — VARCHAR(50)
  • Field (enroll_dt) — DATETIME
  • Field (regist_dt) — DATETIME

Untitled (SurveyQuestMap)

  • Key (survey_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (quest_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
  • Field (regist_dt) — DATETIME

Untitled (login_pool)

  • Key (token) — VARCHAR(10) — Primary key — NOT NULL
  • Field (user_id) — VARCHAR(200)
  • Field (regist_dt) — DATETIME

User

  • Key (user_id) — VARCHAR(200) — Primary key — NOT NULL
  • (user_type) — VARCHAR(100)
  • Field (user_name) — VARCHAR(100)
  • Field2 (user_birth_yyyy) — INT
  • Field3 (user_birth_mm) — INT
  • Field (user_birth_dd) — INT
  • Field (user_gender) — VARCHAR(10)
  • Field (regist_dt) — DATETIME

UserAnswer (UserScore)

  • Key (user_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
  • Key (quest_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
  • Field (quest_score) — INT
  • Field2 (regist_dt) — DATETIME