PREPLAN

Tables (33)

audit_logs

  • log_id — bigserial
  • member_id — bigint
  • session_id — varchar(100)
  • request_id — varchar(100)
  • action_type — varchar(50) — NOT NULL
  • UPDATE::character — varying
  • DELETE::character — varying
  • LOGIN::character — varying
  • LOGOUT::character — varying
  • VIEW::character — varying
  • EXPORT::character — varying)::text))
  • action_category — varchar(30) — NOT NULL
  • DATA::character — varying
  • SYSTEM::character — varying
  • SECURITY::character — varying)::text))
  • risk_level — varchar(20) — NOT NULL
  • MEDIUM::character — varying
  • HIGH::character — varying
  • CRITICAL::character — varying)::text))
  • table_name — varchar(50)
  • record_id — bigint
  • affected_fields — json
  • old_values — json
  • new_values — json
  • business_action — varchar(100)
  • description — varchar(500)
  • ip_address — varchar(45)
  • user_agent — varchar(500)
  • referer — varchar(500)
  • method — varchar(10)
  • endpoint — varchar(200)
  • status — varchar(20) — NOT NULL
  • FAILED::character — varying
  • PARTIAL::character — varying)::text))
  • error_code — varchar(50)
  • error_message — varchar(500)
  • organization_id — bigint — NOT NULL
  • source_system — varchar(50)
  • created_at — timestamp — NOT NULL

categories

  • category_id — bigserial
  • category_name — varchar(200) — NOT NULL
  • category_key — varchar(20) — NOT NULL
  • organization_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

departments

  • department_id — bigserial
  • department_name — varchar(100) — NOT NULL
  • department_key — varchar(20) — NOT NULL
  • organization_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

event_contents

  • content_id — bigserial
  • event_id — bigint — NOT NULL
  • content_type — varchar(20) — NOT NULL
  • IMAGE::character — varying
  • VIDEO::character — varying)::text))
  • content_value — text — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

event_managers

  • event_id — bigint — Primary key — NOT NULL
  • manager_id — bigint — Primary key — NOT NULL
  • manager_role — varchar(20) — NOT NULL
  • SUB_MANAGER::character — varying)::text))
  • created_at — timestamp — NOT NULL

event_professors

  • event_id — bigint — Primary key — NOT NULL
  • professor_id — bigint — Primary key — NOT NULL

event_sessions

  • session_id — bigserial
  • event_id — bigint — NOT NULL
  • session_name — varchar(200) — NOT NULL
  • session_description — varchar(500)
  • session_date — date — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL
  • location — varchar(100)
  • max_capacity — integer — NOT NULL
  • current_reservations — integer — NOT NULL
  • instructor_name — varchar(100)
  • company_name — varchar(100)
  • instructor_info — text
  • session_materials — text
  • session_image_url — varchar(500)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

event_target_groups

  • event_id — bigint — Primary key — NOT NULL
  • group_id — bigint — Primary key — NOT NULL
  • is_excluded — boolean — NOT NULL

event_target_members

  • event_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Primary key — NOT NULL
  • is_excluded — boolean — NOT NULL

event_templates

  • template_id — bigserial
  • template_name — varchar(200) — NOT NULL
  • template_config — json — NOT NULL
  • organization_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

event_timeslots

  • timeslot_id — bigserial
  • event_id — bigint — NOT NULL
  • professor_id — bigint — NOT NULL
  • timeslot_date — date — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL
  • topic — varchar(200) — NOT NULL
  • max_reservations — integer — NOT NULL
  • current_reservations — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

events

  • event_id — bigserial
  • event_name — varchar(200) — NOT NULL
  • event_key — varchar(20) — NOT NULL
  • event_description — varchar(500) — NOT NULL
  • event_state — varchar(20) — NOT NULL
  • PUBLISHED::character — varying
  • ONGOING::character — varying
  • COMPLETED::character — varying
  • CANCELLED::character — varying)::text))
  • event_type — varchar(20) — NOT NULL
  • SESSION::character — varying
  • FREE_FORM::character — varying)::text))
  • event_location — varchar(100) — NOT NULL
  • event_start_at — timestamp — NOT NULL
  • event_end_at — timestamp — NOT NULL
  • reservation_start_at — timestamp — NOT NULL
  • reservation_end_at — timestamp — NOT NULL
  • max_reservations_per_person — integer — NOT NULL
  • allow_cancellation — boolean — NOT NULL
  • cancellation_deadline — timestamp
  • intro_content — text
  • custom_url — varchar(100)
  • qr_code_url — varchar(500)
  • is_public — boolean — NOT NULL
  • approval_required — boolean — NOT NULL
  • category_id — bigint — NOT NULL
  • project_id — bigint
  • department_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

flyway_schema_history

  • installed_rank — integer — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — integer
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — integer — NOT NULL
  • success — boolean — NOT NULL

free_form_fields

  • field_id — bigserial
  • event_id — bigint — NOT NULL
  • field_name — varchar(100) — NOT NULL
  • field_type — varchar(20) — NOT NULL
  • LONG_TEXT::character — varying
  • SINGLE_CHOICE::character — varying
  • MULTIPLE_CHOICE::character — varying
  • NUMBER::character — varying
  • EMAIL::character — varying
  • PHONE::character — varying
  • DATE::character — varying
  • TIME::character — varying)::text))
  • field_description — varchar(500)
  • is_required — boolean — NOT NULL
  • field_order — integer — NOT NULL
  • options_json — json
  • validation_rules — json
  • default_value — varchar(500)
  • conditional_logic — json
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

group_members

  • group_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Primary key — NOT NULL
  • joined_at — timestamp — NOT NULL

groups

  • group_id — bigserial
  • group_name — varchar(50) — NOT NULL
  • group_key — varchar(20) — NOT NULL
  • group_type — varchar(20) — NOT NULL
  • MAJOR::character — varying
  • DEPARTMENT::character — varying
  • LAB::character — varying
  • CUSTOM::character — varying)::text))
  • parent_group_id — bigint
  • depth_level — integer — NOT NULL
  • organization_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

member_credentials

  • credential_id — varchar(1000) — NOT NULL
  • member_id — bigint — NOT NULL
  • public_key — bytea — NOT NULL
  • signature_count — bigint — NOT NULL
  • authenticator_transports — varchar(1000)
  • public_key_credential_type — varchar(100) — NOT NULL
  • attestation_object — bytea
  • attestation_client_data_json — bytea
  • label — varchar(50) — NOT NULL
  • created_at — timestamp — NOT NULL
  • last_used_at — timestamp

members

  • member_id — bigserial
  • name — varchar(40) — NOT NULL
  • member_key — varchar(20) — NOT NULL
  • email_address — varchar(100) — NOT NULL
  • member_role — varchar(20) — NOT NULL
  • ROOT_ADMIN::character — varying
  • SUB_ADMIN::character — varying
  • PROFESSOR::character — varying
  • STAFF::character — varying
  • STUDENT::character — varying)::text))
  • member_state — varchar(10) — NOT NULL
  • DEACTIVE::character — varying
  • SUSPENDED::character — varying)::text))
  • organization_id — bigint — NOT NULL
  • department_id — bigint
  • student_id — varchar(20)
  • employee_id — varchar(20)
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

no_show_records

  • record_id — bigserial
  • member_id — bigint — NOT NULL
  • reservation_id — bigint — NOT NULL
  • event_id — bigint — NOT NULL
  • penalty_until — timestamp
  • created_at — timestamp — NOT NULL

notification_settings

  • setting_id — bigserial
  • member_id — bigint — NOT NULL
  • notification_type — varchar(50) — NOT NULL
  • RESERVATION_CANCELLED::character — varying
  • EVENT_UPDATED::character — varying
  • EVENT_REMINDER::character — varying
  • SURVEY_OPENED::character — varying
  • SURVEY_REMINDER::character — varying
  • SURVEY_CLOSED::character — varying
  • SCHEDULE_CHANGED::character — varying
  • WAITING_LIST_PROMOTED::character — varying
  • NO_SHOW_WARNING::character — varying
  • SYSTEM_NOTICE::character — varying)::text))
  • email_enabled — boolean — NOT NULL
  • push_enabled — boolean — NOT NULL
  • sms_enabled — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

notifications

  • notification_id — bigserial
  • member_id — bigint — NOT NULL
  • notification_type — varchar(50) — NOT NULL
  • RESERVATION_CANCELLED::character — varying
  • EVENT_UPDATED::character — varying
  • EVENT_REMINDER::character — varying
  • SURVEY_OPENED::character — varying
  • SURVEY_REMINDER::character — varying
  • SURVEY_CLOSED::character — varying
  • SCHEDULE_CHANGED::character — varying
  • WAITING_LIST_PROMOTED::character — varying
  • NO_SHOW_WARNING::character — varying
  • SYSTEM_NOTICE::character — varying)::text))
  • title — varchar(200) — NOT NULL
  • content — varchar(500) — NOT NULL
  • event_id — bigint
  • survey_id — bigint
  • reservation_id — bigint
  • is_read — boolean — NOT NULL
  • sent_at — timestamp
  • created_at — timestamp — NOT NULL

organizations

  • organization_id — bigserial
  • organization_name — varchar(100) — NOT NULL
  • organization_key — varchar(20) — NOT NULL
  • organization_status — varchar(20) — NOT NULL
  • INACTIVE::character — varying
  • SUSPENDED::character — varying)::text))
  • organization_domain — varchar(100) — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

projects

  • project_id — bigserial
  • project_name — varchar(200) — NOT NULL
  • project_key — varchar(20) — NOT NULL
  • project_description — varchar(500)
  • organization_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

reservation_policies

  • policy_id — bigserial
  • event_id — bigint — NOT NULL
  • policy_type — varchar(20) — NOT NULL
  • LOTTERY::character — varying
  • APPROVAL::character — varying)::text))
  • approval_required — boolean — NOT NULL
  • waiting_list_enabled — boolean — NOT NULL
  • no_show_penalty_days — integer
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

reservations

  • reservation_id — bigserial
  • event_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • timeslot_id — bigint
  • session_id — bigint
  • form_data_json — json
  • reservation_state — varchar(20) — NOT NULL
  • WAITING::character — varying
  • CANCELLED::character — varying
  • NO_SHOW::character — varying
  • PENDING_APPROVAL::character — varying)::text))
  • reservation_note — varchar(500)
  • approved_by — bigint
  • approved_at — timestamp
  • rejection_reason — varchar(500)
  • reserved_at — timestamp — NOT NULL
  • cancelled_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

schedule_change_requests

  • request_id — bigserial
  • reservation_id — bigint — NOT NULL
  • requested_by — bigint — NOT NULL
  • current_timeslot_id — bigint — NOT NULL
  • requested_timeslot_id — bigint — NOT NULL
  • request_reason — varchar(500)
  • request_status — varchar(20) — NOT NULL
  • APPROVED::character — varying
  • REJECTED::character — varying)::text))
  • processed_by — bigint
  • processed_at — timestamp
  • created_at — timestamp — NOT NULL

short_urls

  • short_code — varchar(10) — NOT NULL
  • original_url — varchar(1000) — NOT NULL
  • event_id — bigint
  • survey_id — bigint
  • click_count — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • expires_at — timestamp

survey_answers

  • answer_id — bigserial
  • response_id — bigint — NOT NULL
  • question_id — bigint — NOT NULL
  • answer_value — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

survey_pages

  • page_id — bigserial
  • survey_id — bigint — NOT NULL
  • page_name — varchar(100) — NOT NULL
  • page_order — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

survey_questions

  • question_id — bigserial
  • page_id — bigint — NOT NULL
  • question_type — varchar(20) — NOT NULL
  • LONG_TEXT::character — varying
  • SINGLE_CHOICE::character — varying
  • MULTIPLE_CHOICE::character — varying
  • SCALE::character — varying
  • IMAGE_INFO::character — varying)::text))
  • question_text — varchar(1000) — NOT NULL
  • question_order — integer — NOT NULL
  • is_required — boolean — NOT NULL
  • options — json
  • image_url — varchar(500)
  • scale_min — integer
  • scale_max — integer
  • scale_labels — json
  • conditional_logic — json
  • dependent_question_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

survey_responses

  • response_id — bigserial
  • survey_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • submitted_at — timestamp
  • completion_percentage — integer — NOT NULL
  • current_page_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

surveys

  • survey_id — bigserial
  • survey_name — varchar(200) — NOT NULL
  • survey_key — varchar(50) — NOT NULL
  • survey_description — varchar(500)
  • survey_type — varchar(20) — NOT NULL
  • POST_EVENT::character — varying)::text))
  • survey_state — varchar(20) — NOT NULL
  • PUBLISHED::character — varying
  • CLOSED::character — varying)::text))
  • allow_modification — boolean — NOT NULL
  • start_at — timestamp
  • end_at — timestamp
  • event_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — timestamp — NOT NULL
  • updated_by — bigint — NOT NULL

waiting_list

  • waiting_id — bigserial
  • event_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • waiting_order — integer — NOT NULL
  • created_at — timestamp — NOT NULL