carelog

Tables (12)

APPOINTMENT

  • id — BIGSERIAL
  • patient_id — BIGINT — NOT NULL
  • doctor_id — BIGINT — NOT NULL
  • appointment_time — TIMESTAMP — NOT NULL
  • memo — VARCHAR(255)
  • status — VARCHAR(50) — NOT NULL
  • created_at — created_at
  • updated_at — updated_at
  • deleted_at — deleted_at

CLIENT

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone_number — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • created_at — created_at
  • updated_at — updated_at
  • deleted_at — deleted_at

CLIENT_TAG

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — created_at

CLIENT_TAG_MAP

  • id — BIGSERIAL
  • client_id — BIGINT — NOT NULL
  • tag_id — BIGINT — NOT NULL
  • created_at — created_at

COMMENT

  • id — BIGSERIAL
  • diary_entry_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — created_at
  • updated_at — updated_at
  • deleted_at — deleted_at

DAILY_STATS

  • id — BIGSERIAL
  • date — DATE — NOT NULL
  • total_appointments — INTEGER — NOT NULL
  • total_diary_entries — INTEGER — NOT NULL
  • total_patients — INTEGER — NOT NULL
  • updated_at — updated_at

DIARY_ENTRY

  • id — BIGSERIAL
  • patient_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — created_at
  • updated_at — updated_at
  • deleted_at — deleted_at

FILE_ATTACHMENT

  • id — BIGSERIAL
  • diary_entry_id — BIGINT
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(512) — NOT NULL
  • file_type — VARCHAR(100)
  • uploaded_by — BIGINT
  • created_at — created_at

LOGIN_HISTORY

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • ip_address — VARCHAR(100) — NOT NULL
  • user_agent — VARCHAR(255)
  • login_time — TIMESTAMP — NOT NULL
  • logout_time — TIMESTAMP

NOTIFICATION_LOG

  • id — BIGSERIAL
  • patient_id — BIGINT — NOT NULL
  • appointment_id — BIGINT
  • message — TEXT — NOT NULL
  • sent_at — TIMESTAMP — NOT NULL
  • method — VARCHAR(50) — NOT NULL
  • success — BOOLEAN — NOT NULL
  • error_message — VARCHAR(255)

REMINDER_SETTING

  • id — BIGSERIAL
  • appointment_id — BIGINT — NOT NULL
  • reminder_time — TIMESTAMP — NOT NULL
  • sent — BOOLEAN — NOT NULL
  • sent_at — TIMESTAMP
  • method — VARCHAR(50) — NOT NULL

USER

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • created_at — created_at
  • updated_at — updated_at
  • deleted_at — deleted_at