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