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