brc-chatbot

Tables (7)

animal (Untitled)

  • animal_id — Primary key — NOT NULL
  • user_id — Foreign key → user.user_id — NOT NULL
  • name
  • gender
  • age
  • species
  • breed

candidate (Untitled6)

  • id — uuid — Primary key — NOT NULL
  • candidate_name — string
  • position
  • email
  • client
  • phone_number
  • current_location
  • total_experience

dialogue (Untitled2)

  • dialogue_id — Primary key — NOT NULL
  • user_id — Foreign key → user.user_id — NOT NULL
  • category
  • is_open
  • dialogue_stage
  • animal_id — Foreign key → animal.animal_id — NOT NULL

hospital (Untitled5)

  • hospital_id — Primary key — NOT NULL
  • location_preview_image
  • place_url
  • region_1depth_name
  • region_2depth_name
  • region_3depth_name
  • main_building_no
  • sub_building_no
  • road_address_name
  • hospital_name

job_application (Untitled7)

  • id — uuid — Primary key — NOT NULL
  • interview — string
  • job_desc_match — boolean
  • interview_match — boolean

qna (Untitled4)

  • qna_id — Primary key — NOT NULL
  • dialogue_id — Foreign key → dialogue.dialogue_id — NOT NULL
  • userMessage
  • replyMessage

user (Untitled3)

  • user_id — Primary key — NOT NULL