meditag

Tables (11)

alarm

  • id — BIGINT — Primary key — NOT NULL
  • calendar_id — BIGINT — Foreign key → calendar.id — NOT NULL
  • dosage_time — VARCHAR(50)
  • alarm_time — DATETIME
  • taking — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

calendar

  • id — BIGINT — Primary key — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicine.id — NOT NULL
  • calendar_date — DATE

chat_session

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME

faq

  • id — BIGINT — Primary key — NOT NULL
  • question — VARCHAR(1000)
  • answer — VARCHAR(2000)
  • action_type — VARCHAR(50)
  • action_target — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

favorite

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicine.id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

guardian

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • phone_number — VARCHAR(50)
  • relationship — VARCHAR(50)

medicine

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • name — VARCHAR(255)
  • characteristic — VARCHAR(255)
  • start_date — DATE
  • duration — INT
  • frequency — INT
  • image_url — VARCHAR(500)
  • prescribed — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

member

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(100)
  • name — VARCHAR(100)
  • phone — VARCHAR(50)
  • password — VARCHAR(255)
  • role — VARCHAR(50)
  • firebasetoken — VARCHAR(255)
  • last_login_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

message

  • message_id — BIGINT — Primary key — NOT NULL
  • chat_session_id — BIGINT — Foreign key → chat_session.id — NOT NULL
  • sender — VARCHAR(20)
  • content — VARCHAR(1000)
  • created_at — DATETIME
  • updated_at — DATETIME

recording

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(255)
  • recording_time — DATETIME
  • recording_file — VARCHAR(500)
  • created_at — DATETIME
  • updated_at — DATETIME

refresh_token

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(100)
  • refresh_token — VARCHAR(255)