test

Tables (26)

app_banner

  • id — bigint — NOT NULL
  • title — text
  • body — text
  • link — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • image_link — text
  • link_type — text
  • display_sorting_id — smallint — NOT NULL

app_settings

  • id — bigint — NOT NULL
  • type — character — NOT NULL
  • value — character
  • created_at — timestamp
  • update_at — timestamp — NOT NULL
  • settings_data — json — NOT NULL
  • user_id — uuid

company_profile

  • id — serial — NOT NULL
  • name — character — NOT NULL
  • address — character — NOT NULL
  • logo — text
  • is_verified — boolean — NOT NULL
  • bin_number — text
  • company_profile — text
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — uuid
  • email — text
  • contact_phone — text
  • contact_name — text
  • website_link — text
  • contact_designation — text
  • contact_email — text
  • is_deleted — boolean — NOT NULL
  • industry — text
  • payment_method — public.payment_method — NOT NULL
  • overdue_date_after_invoice — smallint — NOT NULL

district

  • id — smallint — NOT NULL
  • district_en — text — NOT NULL
  • district — text — NOT NULL
  • division — smallint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_visible — boolean — NOT NULL
  • applicable_division_filters — json
  • applicable_district_filters — json
  • topic_name — text — NOT NULL

division

  • id — smallint — NOT NULL
  • division — text
  • division_en — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_visible — boolean — NOT NULL
  • position — smallint
  • applicable_division_filters — json
  • applicable_district_filters — json
  • topic_name — text — NOT NULL

education

  • id — smallint — NOT NULL
  • education — text
  • is_visible_user_profile — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • is_visible_in_filter — boolean — NOT NULL
  • is_university_required — boolean — NOT NULL
  • education_level — smallint
  • applicable_filters — json
  • education_en — text
  • topic_name — text — NOT NULL

firebase_token

  • id — bigint — NOT NULL
  • fcm_token — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — uuid
  • device_adid — text
  • app_version — text

job_list_extra_ques

  • id — serial — NOT NULL
  • questions — text — NOT NULL
  • options — json — NOT NULL
  • job_listing_id — integer
  • created_at — timestamp
  • updated_at — timestamp
  • type — public.extraquestype — NOT NULL

job_list_extra_ques_ans

  • id — bigint — NOT NULL
  • job_list_extra_ques_id — integer
  • answer — json
  • user_id — uuid
  • created_at — timestamp
  • updated_at — timestamp

job_listing

  • id — serial — NOT NULL
  • job_title — text
  • job_description — text
  • company_name — text
  • salary_start — integer
  • salary_end — integer
  • education — smallint
  • job_type — smallint
  • work_experience — smallint
  • application_deadline — date
  • company_logo — text
  • is_verified — boolean
  • total_recruits — integer
  • company_profile_id — integer
  • is_post_complete — boolean
  • job_locations — text — NOT NULL
  • salary_range — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — public.job_listing_status
  • division_id — json — NOT NULL
  • district_id — json — NOT NULL
  • education_filter — json
  • work_experience_filter — json
  • job_listing_display_serial — integer
  • is_cv_mandatory — boolean — NOT NULL
  • gender_specific_type — public.gender_specific_jobs — NOT NULL
  • reason_for_post_not_complete — text
  • job_live_at — timestamp
  • invoice_id — bigint
  • package_id — bigint
  • employer_subscription_package_id — bigint
  • is_rpo — boolean — NOT NULL
  • user_id — uuid
  • dynamic_link — text

job_statues

  • id — smallint — NOT NULL
  • status — public.job_statuses — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • stage — smallint
  • display_status — character
  • sms_template — text
  • required_docs_for_stage — json
  • parent_status_id — smallint — NOT NULL

job_type

  • id — smallint — NOT NULL
  • job_type — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_visible — boolean — NOT NULL
  • job_type_en — text
  • topic_name — text — NOT NULL
  • main_category — text
  • main_category_bn — text

saved_jobs

  • id — bigint — NOT NULL
  • job_listing — integer
  • created_at — timestamp
  • updated_at — timestamp
  • saved_job_status — public.saved_job_status — NOT NULL
  • user_id — uuid

skill_course_list

  • id — bigint — NOT NULL
  • skill_course_name — text — NOT NULL
  • type — text — NOT NULL
  • display_serial — smallint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • skill_course_bn — text

sms_config

  • id — bigint — NOT NULL
  • created_at — timestamp
  • name — character
  • is_primary — boolean

success_story

  • id — serial — NOT NULL
  • name — text
  • image — text
  • story_details — text
  • like_count — smallint
  • created_at — timestamp
  • updated_at — timestamp
  • user_job_id — bigint
  • title_display — character
  • is_visible — boolean

training_videos

  • id — bigint — NOT NULL
  • name — text
  • youtube_link — text
  • video_image — text
  • is_visible — boolean — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

university_list

  • id — smallint — NOT NULL
  • university_name_en — text
  • university_name_bn — text
  • created_at — timestamp
  • updated_at — timestamp
  • is_visible — boolean — NOT NULL

user_courses

  • id — bigint — NOT NULL
  • user_id — uuid
  • course_id — bigint
  • organization — text
  • cert_url — text
  • created_at — timestamp
  • updated_at — timestamp
  • is_ongoing — boolean
  • is_manual_upload — boolean — NOT NULL

user_education

  • id — bigint — NOT NULL
  • user_id — uuid
  • education_id — smallint
  • subject — text
  • university_id — smallint
  • certificate_url — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • end_date — date
  • school_name — text
  • is_ongoing — boolean — NOT NULL
  • is_manual_upload — boolean — NOT NULL

user_experience

  • id — bigint — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date
  • company_name — text — NOT NULL
  • job_type_id — smallint
  • job_type_text — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — uuid
  • is_ongoing — boolean — NOT NULL
  • job_role — text
  • job_responsibilities — text
  • is_manual_upload — boolean — NOT NULL

user_job

  • id — bigint — NOT NULL
  • job_listing — integer
  • users — bigint
  • status — smallint
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — uuid
  • lat — double
  • long — double
  • selected_cv_url — text
  • application_source — public.application_source — NOT NULL

user_job_application_log

  • id — bigint — NOT NULL
  • job_listing_id — integer
  • user_job_id — bigint
  • user_id — uuid
  • status — smallint
  • created_at — timestamp
  • updated_at — timestamp
  • is_sms_sent — boolean — NOT NULL
  • is_sms_required — boolean — NOT NULL
  • sms_text — text
  • interview_date_time — timestamp
  • interview_location — text
  • sms_size — smallint
  • sms_text_length — smallint
  • required_docs_for_interview — text
  • interview_contact_phone — text
  • remarks — text

user_profile

  • id — bigint — NOT NULL
  • username — text — NOT NULL
  • nid_number — text
  • is_completed — boolean
  • education — smallint
  • gender — text
  • job_type — smallint
  • work_experience — smallint
  • vehicle_type — text
  • education_certificate — text
  • division — smallint
  • district — smallint
  • thana — smallint
  • email — text
  • is_smartphone_available — text
  • profile_photo — text
  • date_of_birth — date
  • completion_level — smallint
  • user_id — uuid
  • full_name — text
  • CV — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • university_id — bigint
  • referral_code — text
  • referred_by — text
  • is_nid_verified — boolean — NOT NULL
  • current_address — text
  • cv_data — json
  • is_otp_verified — boolean — NOT NULL
  • job_type_list — ARRAY
  • father_name — text
  • mother_name — text
  • marital_status — text
  • profile_updated_at — timestamp — NOT NULL
  • is_manual_upload — boolean — NOT NULL

user_skills

  • id — bigint — NOT NULL
  • user_id — uuid
  • skill_id — bigint
  • created_at — timestamp
  • updated_at — timestamp
  • certificate_url — text
  • skill_name_text — text — NOT NULL
  • institution — text
  • is_manual_upload — boolean — NOT NULL

work_experience

  • id — smallint — NOT NULL
  • work_experience — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_visible_user_profile — boolean — NOT NULL
  • is_visible_in_filter — boolean — NOT NULL
  • experience_level — smallint
  • applicable_filters — json
  • work_experience_en — text
  • topic_name — text — NOT NULL
  • is_visible_in_job_creation — boolean — NOT NULL