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