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