2ewq

Tables (16)

department

  • department — bigint — Primary key — NOT NULL
  • department_name — varcher(20)
  • department_code — char(4)

hospital

  • hospital_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • application_id — BIGINT — NOT NULL
  • public_hospital_id — VARCHAR(100) — NOT NULL
  • hospital_name — VARCHAR(200) — NOT NULL
  • introduction — TEXT
  • reservation_interval — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • manager_name — VARCHAR(50)
  • manager_phone — VARCHAR(20)
  • business_reg_no — VARCHAR(20)
  • business_reg_file — VARCHAR(500)

hospital_application

  • application_id — BIGINT — Primary key — NOT NULL
  • hospital_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • reject_reason — TEXT
  • created_at — DATETIME — NOT NULL

hospital_closed_day

  • closed_day_id — BIGINT — Primary key — NOT NULL
  • hospital_id — BIGINT — NOT NULL
  • closed_date — DATE — NOT NULL

hospital_department

  • department_id — BIGINT — Primary key — NOT NULL
  • hospital_id — BIGINT — NOT NULL
  • department2 — bigint — NOT NULL
  • max_capacity — INT — NOT NULL
  • active — BOOLEAN — NOT NULL

hospital_favorite

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • hospital_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

hospital_hours

  • hour_id — BIGINT — Primary key — NOT NULL
  • hospital_id — BIGINT — NOT NULL
  • day_of_week — TINYINT — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • lunch_start — TIME
  • lunch_end — TIME
  • closed — BOOLEAN — NOT NULL

inquiry

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiry_answer

  • answer_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — NOT NULL
  • admin_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiry_attachment

  • attachment_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_pinned — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

notice_attachment

  • attachment_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL

reservation

  • reservation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • department_id — BIGINT — NOT NULL
  • reserved_date — DATE — NOT NULL
  • reserved_time — TIME — NOT NULL
  • patient_name — VARCHAR(50) — NOT NULL
  • patient_phone — VARCHAR(20) — NOT NULL
  • symptom_memo — TEXT
  • status — VARCHAR(20) — NOT NULL
  • reject_reason — TEXT
  • created_at — DATETIME — NOT NULL

review

  • review_id — BIGINT — Primary key — NOT NULL
  • hospital_id2 — BIGINT — NOT NULL
  • reservation_id2 — BIGINT — NOT NULL
  • rating — DECIMAL(2,1) — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • auth_url — varchar(500)
  • is_auth — boolean

review_attachment

  • attachment_id — BIGINT — Primary key — NOT NULL
  • review_id2 — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_Withdraw — boolean