final

Tables (36)

alert

  • alert_no — bigint — Primary key — NOT NULL
  • alert_type_id — bigint
  • del_yn — character
  • message — character
  • scheduled_at — timestamp(6)
  • send_at — timestamp(6)
  • send_to_user_no — bigint
  • title — character

alert_state

  • alert_state_no — bigint — Primary key — NOT NULL
  • check_status — character
  • del_yn — character
  • user_no — bigint
  • alert_no — bigint
  • send_at — timestamp(6)

alert_type

  • alert_type_no — bigint — Primary key — NOT NULL
  • alert_type_name — character

attendance

  • attendance_id — bigint — Primary key — NOT NULL
  • leave_yn — character
  • meeting_count — integer
  • meeting_total_min — integer
  • work_in_at — timestamp(6) — NOT NULL
  • work_out_at — timestamp(6) — NOT NULL
  • user_no — bigint

company

  • com_no — bigint — Primary key — NOT NULL
  • approval_status — character
  • biz_reg_no — character
  • com_name — character
  • com_token — character
  • created_at — timestamp(6)
  • del_yn — character
  • rep_name — character
  • updated_at — timestamp(6)
  • user_email — character
  • biz_reg_file_url — character

department

  • department_no — bigint — Primary key — NOT NULL
  • department_name — character — NOT NULL

member

  • user_no — bigint — Primary key — NOT NULL
  • com_token — character — NOT NULL
  • created_at — timestamp(6)
  • del_yn — character — NOT NULL
  • updated_at — timestamp(6)
  • user_email — character
  • user_id — character — NOT NULL
  • user_nick — character — NOT NULL
  • user_phone — character
  • user_pwd — character — NOT NULL
  • com_no — bigint — NOT NULL
  • department_no — bigint — NOT NULL
  • role_no — bigint — NOT NULL
  • user_avatar — character

member_health

  • health_id — bigint — Primary key — NOT NULL
  • blood_pressure — double
  • blood_sugar — double
  • bmi — double
  • cholesterol_level — double
  • liver_function — double
  • user_no — bigint — NOT NULL

role

  • role_no — bigint — Primary key — NOT NULL
  • role_name — character — NOT NULL

survey_assignment

  • assignment_id — bigint — Primary key — NOT NULL
  • occurrence_date — date — NOT NULL
  • presented_at — timestamp(6) — NOT NULL
  • submitted_at — timestamp(6)
  • survey_status_code — bigint — NOT NULL
  • template_id — bigint — NOT NULL
  • user_no — bigint — NOT NULL

survey_response

  • assignment_id — bigint — Primary key — NOT NULL
  • answer1 — integer
  • answer2 — integer
  • answer3 — integer
  • answer4 — integer
  • answer5 — integer

survey_status

  • survey_status_code — bigint — Primary key — NOT NULL
  • modifiable — character
  • survey_status_name — character — NOT NULL

survey_template

  • template_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • description — character
  • is_active — character — NOT NULL
  • title — character — NOT NULL
  • update_at — timestamp(6)

tbl_board

  • board_id — bigint — Primary key — NOT NULL
  • board_comment_cnt — bigint
  • board_content — character
  • board_content_fix — character
  • board_hit — bigint
  • board_like_cnt — bigint
  • board_reports_cnt — bigint
  • board_title — character
  • board_writer — character
  • created_at — timestamp(6)
  • del_yn — character
  • updated_at — timestamp(6)
  • category_id — bigint
  • user_no — bigint
  • com_no — bigint

tbl_board_file

  • file_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • del_yn — character
  • file_origin_name — character — NOT NULL
  • file_server_name — character — NOT NULL
  • file_url — character — NOT NULL
  • board_id — bigint

tbl_category

  • category_id — bigint — Primary key — NOT NULL
  • category_name — character

tbl_cert

  • cert_id — bigint — Primary key — NOT NULL
  • cert_board_id — bigint
  • cert_part_id — bigint

tbl_challenge

  • chal_id — bigint — Primary key — NOT NULL
  • chal_end_at — timestamp(6) — NOT NULL
  • chal_name — character — NOT NULL
  • chal_start_at — timestamp(6) — NOT NULL
  • created_at — timestamp(6)
  • del_yn — character — NOT NULL
  • updated_at — timestamp(6)

tbl_comment

  • comment_id — bigint — Primary key — NOT NULL
  • comment — character — haracter varying(255) COLLATE pg_catalog."default
  • created_at — timestamp(6)
  • del_yn — character
  • updated_at — timestamp(6)
  • board_id — bigint
  • user_no — bigint
  • comment_complaint_cnt — bigint
  • comment_like_cnt — integer — NOT NULL
  • comment_writer — character

tbl_complaint

  • complaint_id — bigint — Primary key — NOT NULL
  • complaint_reason — character
  • created_at — timestamp(6)
  • del_yn — character
  • board_id — bigint
  • comment_id — bigint
  • user_no — bigint
  • complaint_type — character

tbl_faq

  • faq_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • faq_answer — character
  • faq_content — character — NOT NULL
  • faq_title — character — NOT NULL
  • category_id — bigint — NOT NULL
  • faq_status_id — bigint — NOT NULL
  • user_no — bigint
  • answer_user_no — bigint

tbl_faq_category

  • category_id — bigint — Primary key — NOT NULL
  • category_name — character — NOT NULL

tbl_faq_status

  • faq_status_id — bigint — Primary key — NOT NULL
  • faq_status_name — character — NOT NULL

tbl_item

  • item_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • del_yn — character
  • item_content — character — NOT NULL
  • item_name — character — NOT NULL
  • item_price — bigint — NOT NULL
  • updated_at — timestamp(6)
  • item_com_no — bigint

tbl_like

  • like_id — bigint — Primary key — NOT NULL
  • del_yn — character
  • like_type — character
  • board_id — bigint
  • comment_id — bigint
  • userno — bigint

tbl_participation

  • part_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • part_status — character — NOT NULL
  • part_chal_id — bigint
  • part_user_no — bigint

tbl_payment_history

  • payment_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • payment_delivery_status — character
  • payment_item_cnt — bigint
  • payment_item_id — bigint
  • payment_user_no — bigint

tbl_point_history

  • point_id — bigint — Primary key — NOT NULL
  • after_point — bigint
  • before_point — bigint
  • change_point — bigint
  • change_type — character — NOT NULL
  • created_at — timestamp(6)
  • reason — character
  • user_no — bigint

tbl_recommendation_file

  • file_id — bigint — Primary key — NOT NULL
  • file_origin_name — character
  • file_server_name — character
  • file_url — character
  • step_id — bigint

tbl_recommendation_program

  • program_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • duration_min — integer
  • recommended_program_text — character
  • updated_at — timestamp(6)
  • program_type_id — bigint — NOT NULL
  • user_no — bigint — NOT NULL

tbl_recommendation_program_step

  • step_id — bigint — Primary key — NOT NULL
  • description — character
  • step_name — character
  • program_id — bigint — NOT NULL
  • file_id — bigint

tbl_recommendation_program_type

  • program_type_id — bigint — Primary key — NOT NULL
  • program_type_name — character

tbl_store_file

  • file_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • del_yn — character
  • file_origin_name — character — NOT NULL
  • file_server_name — character — NOT NULL
  • file_url — character — NOT NULL
  • item_id — bigint

verify_email

  • mail_no — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • expire_at — timestamp(6)
  • expired — character — NOT NULL
  • random_code — character
  • user_email — character
  • verified — character — NOT NULL

weekly_summary

  • summary_id — bigint — Primary key — NOT NULL
  • achievement_rate — double
  • average_bed_time — double
  • average_sleep_hours — double
  • average_wake_hours — double
  • challenge_count — integer
  • daily_work_average — double
  • leave_stress_score — double
  • status — character
  • total_score — double
  • total_work_hours — integer
  • total_work_minutes — integer
  • week_start — date — NOT NULL
  • work_hours_score_avg — double
  • user_no — bigint — NOT NULL

work

  • work_id — bigint — Primary key — NOT NULL
  • active_projects_count — integer
  • approval_requests_count — integer
  • completed_tasks_count — integer
  • new_assigned_tasks_count — integer
  • pending_tasks_count — integer
  • reports_written_count — integer
  • work_date — date
  • user_no — bigint