BaGulBaGul_ver3
Tables (42)
admin_manage_event_host_user
- admin_manage_event_host_user_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__ADMIN_MANAGE_EVENT_HOST_USER__USER_ID`
admin_manage_password_login_user
- admin_manage_password_login_user_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — Foreign key → password_login_user.login_id — NOT NULL
- INDEX — 'FK__ADMIN_MANAGE_PASSWORD_LOGIN_USER__LOGIN_ID'
alarm
- alarm_id — BIGINT — Primary key — NOT NULL
- checked — BIT(1)
- message — VARCHAR(255)
- subject — VARCHAR(255)
- time — DATETIME
- title — VARCHAR(255)
- type — VARCHAR(255)
- user_id — BIGINT — Foreign key → user.user_id
- version — INT — NOT NULL
- INDEX — `FK__ALARM__USER_ID`
batch_job_execution
- JOB_EXECUTION_ID — BIGINT — Primary key — NOT NULL
- VERSION — BIGINT
- JOB_INSTANCE_ID — BIGINT — Foreign key → batch_job_instance.JOB_INSTANCE_ID — NOT NULL
- CREATE_TIME — DATETIME(6) — NOT NULL
- START_TIME — DATETIME(6)
- END_TIME — DATETIME(6)
- STATUS — VARCHAR(10)
- EXIT_CODE — VARCHAR(2500)
- EXIT_MESSAGE — VARCHAR(2500)
- LAST_UPDATED — DATETIME(6)
- JOB_CONFIGURATION_LOCATION — VARCHAR(2500)
- INDEX — `JOB_INST_EXEC_FK`
batch_job_execution_context
- JOB_EXECUTION_ID — BIGINT — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
batch_job_execution_params
- JOB_EXECUTION_ID — BIGINT — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- TYPE_CD — VARCHAR(6) — NOT NULL
- KEY_NAME — VARCHAR(100) — NOT NULL
- STRING_VAL — VARCHAR(250)
- DATE_VAL — DATETIME(6)
- LONG_VAL — BIGINT
- DOUBLE_VAL — DOUBLE
- IDENTIFYING — CHAR(1) — NOT NULL
- INDEX — `JOB_EXEC_PARAMS_FK`
batch_job_execution_seq
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
batch_job_instance
- JOB_INSTANCE_ID — BIGINT — Primary key — NOT NULL
- VERSION — BIGINT
- JOB_NAME — VARCHAR(100) — NOT NULL
- JOB_KEY — VARCHAR(32) — NOT NULL
batch_job_seq
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
batch_step_execution
- STEP_EXECUTION_ID — BIGINT — Primary key — NOT NULL
- VERSION — BIGINT — NOT NULL
- STEP_NAME — VARCHAR(100) — NOT NULL
- JOB_EXECUTION_ID — BIGINT — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- START_TIME — DATETIME(6) — NOT NULL
- END_TIME — DATETIME(6)
- STATUS — VARCHAR(10)
- COMMIT_COUNT — BIGINT
- READ_COUNT — BIGINT
- FILTER_COUNT — BIGINT
- WRITE_COUNT — BIGINT
- READ_SKIP_COUNT — BIGINT
- WRITE_SKIP_COUNT — BIGINT
- PROCESS_SKIP_COUNT — BIGINT
- ROLLBACK_COUNT — BIGINT
- EXIT_CODE — VARCHAR(2500)
- EXIT_MESSAGE — VARCHAR(2500)
- LAST_UPDATED — DATETIME(6)
- INDEX — `JOB_EXEC_STEP_FK`
batch_step_execution_context
- STEP_EXECUTION_ID — BIGINT — Foreign key → batch_step_execution.STEP_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
batch_step_execution_seq
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
event
- event_id — BIGINT — Primary key — NOT NULL
- deleted — BIT(1) — NOT NULL
- location_abstract — VARCHAR(255)
- headcount_current — INT
- enddate — DATETIME
- location_full — VARCHAR(255)
- location_latitude — FLOAT
- location_longitude — FLOAT
- startdate — DATETIME
- headcount_total — INT
- type — VARCHAR(255)
- post_id — BIGINT — Foreign key → post.post_id
- age_limit — BIT(1) — NOT NULL
- event_host_user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__EVENT__POST_ID`
- INDEX — `FK__USER__EVENT_HOST_USER_ID`
event_banner
- event_banner_id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → event.event_id
- event_banner_image_resource_id — BIGINT — Foreign key → resource.resource_id
- INDEX — `FK__EVENT_BANNER__EVENT_ID`
- INDEX — `FK__EVENT_BANNER__EVENT_BANNER_IMAGE_RESOURCE_ID`
event_calendar
- event_id — BIGINT — Foreign key → event.event_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- INDEX — `FK__EVENT_CALENDAR__USER_ID`
event_category
- category_id — BIGINT — Foreign key → category.category_id — NOT NULL
- event_id — BIGINT — Foreign key → event.event_id — NOT NULL
- INDEX — `FK__EVENT_CATEGORY__EVENT_ID`
flyway_schema_history
- installed_rank — INT — Primary key — NOT NULL
- version — VARCHAR(50)
- description — VARCHAR(200) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- script — VARCHAR(1000) — NOT NULL
- checksum — INT
- installed_by — VARCHAR(100) — NOT NULL
- installed_on — TIMESTAMP — NOT NULL
- execution_time — INT — NOT NULL
- success — TINYINT(1) — NOT NULL
- INDEX — `flyway_schema_history_s_idx`
password_login_user
- login_id — VARCHAR(50) — Primary key — NOT NULL
- encoded_login_password — VARCHAR(200) — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- INDEX — `FK__PASSWORD_LOGIN_USER__USER_ID`
permission
- permission_name — VARCHAR(50) — Primary key — NOT NULL
post
- post_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- comment_count — INT
- content — VARCHAR(255)
- image_url — VARCHAR(255)
- like_count — INT
- tags — VARCHAR(255)
- title — VARCHAR(255)
- views — INT
- user_id — BIGINT — Foreign key → user.user_id
- dtype — VARCHAR(31)
- INDEX — `FK__POST__USER_ID`
post_comment
- post_comment_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- comment_child_count — INT
- contnet — VARCHAR(255)
- like_count — INT
- post_id — BIGINT — Foreign key → post.post_id
- user_id — BIGINT — Foreign key → user.user_id
- deleted_at — DATETIME
- INDEX — `FK__POST_COMMENT__POST_ID`
- INDEX — `FK__POST_COMMENT__USER_ID`
post_comment_child
- post_comment_child_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- content — VARCHAR(255)
- like_count — INT
- post_comment_id — BIGINT — Foreign key → post_comment.post_comment_id
- reply_target_user_id — BIGINT — Foreign key → user.user_id
- user_id — BIGINT — Foreign key → user.user_id
- deleted_at — DATETIME
- INDEX — `FK__POST_COMMENT_CHILD__POST_COMMENT_ID`
- INDEX — `FK__POST_COMMENT_CHILD__REPLY_TARGET_USER_ID`
- INDEX — `FK__POST_COMMENT_CHILD__USER_ID`
post_comment_child_like
- post_comment_child_like_id — BIGINT — Primary key — NOT NULL
- post_comment_child_id — BIGINT — Foreign key → post_comment_child.post_comment_child_id
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__POST_COMMENT_CHILD_LIKE__USER_ID`
post_comment_like
- post_comment_like_id — BIGINT — Primary key — NOT NULL
- post_comment_id — BIGINT — Foreign key → post_comment.post_comment_id
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__POST_COMMENT_LIKE__USER_ID`
post_image
- resource_id — BIGINT — Foreign key → resource.resource_id — NOT NULL
- image_order — INT
- post_id — BIGINT — Foreign key → post.post_id
- INDEX — `FK__POST_IMAGE__POST_ID`
post_like
- post_like_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__POST_LIKE__USER_ID`
recruitment
- recruitment_id — BIGINT — Primary key — NOT NULL
- deleted — BIT(1) — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- headcount_current — INT
- enddate — DATETIME
- startdate — DATETIME
- state — INT
- headcount_total — INT
- event_id — BIGINT — Foreign key → event.event_id
- post_id — BIGINT — Foreign key → post.post_id
- INDEX — `FK__RECRUITMENT__EVENT_ID`
- INDEX — `FK__RECRUITMENT__POST_ID`
recruitment_calendar
- recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- INDEX — `FK__RECRUITMENT_CALENDAR__RECRUITMENT_ID`
report
- report_id — BIGINT — Primary key — NOT NULL
- dtype — VARCHAR(15) — NOT NULL
- solved — BIT(1) — NOT NULL
- event_id — BIGINT — Foreign key → event.event_id
- recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id
- post_comment_id — BIGINT — Foreign key → post_comment.post_comment_id
- post_comment_child_id — BIGINT — Foreign key → post_comment_child.post_comment_child_id
- report_type — VARCHAR(50) — NOT NULL
- message — VARCHAR(1000)
- reported_user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- reporting_user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- report_status_id — BIGINT — Foreign key → report_status.report_status_id
- INDEX — `SOLVED__CREATED_AT`
- INDEX — `event_id`
- INDEX — `recruitment_id`
- INDEX — `post_comment_id`
- INDEX — `post_comment_child_id`
- INDEX — `reported_user_id`
- INDEX — `FK__report__report_status_id`
report_status
- report_status_id — BIGINT — Primary key — NOT NULL
- dtype — VARCHAR(200) — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- total_report_count — INT
- not_relevant_report_count — INT
- offensive_content_report_count — INT
- defamatory_report_count — INT
- ect_report_count — INT
- state — VARCHAR(200)
- is_reported_content_deleted — TINYINT(1) — NOT NULL
- is_reported_content_writer_suspended — TINYINT(1) — NOT NULL
- event_id — BIGINT — Foreign key → event.event_id
- recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id
- post_comment_id — BIGINT — Foreign key → post_comment.post_comment_id
- post_comment_child_id — BIGINT — Foreign key → post_comment_child.post_comment_child_id
- active_event_id — BIGINT
- active_recruitment_id — BIGINT
- active_post_comment_id — BIGINT
- active_post_comment_child_id — BIGINT
- INDEX — `FK__REPORT_STATUS__EVENT_ID`
- INDEX — `FK__REPORT_STATUS__RECRUITMENT_ID`
- INDEX — `FK__REPORT_STATUS__POST_COMMENT_ID`
- INDEX — `FK__REPORT_STATUS__POST_COMMENT_CHILD_ID`
resource
- resource_id — BIGINT — Primary key — NOT NULL
- resource_key — VARCHAR(255)
- storage_vendor — VARCHAR(255)
- upload_time — DATETIME
role
- role_name — VARCHAR(50) — Primary key — NOT NULL
role_permission
- permission_name — VARCHAR(50) — Foreign key → permission.permission_name — NOT NULL
- role_name — VARCHAR(50) — Foreign key → role.role_name — NOT NULL
- INDEX — `FK__ROLE_PERMISSION__PERMISSION_NAME`
s3temp_resource
- resource_id — BIGINT — Foreign key → resource.resource_id — NOT NULL
- upload_time — DATETIME
social_login_user
- social_login_user_id — VARCHAR(255) — Primary key — NOT NULL
- provider — VARCHAR(255)
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__SOCIAL_LOGIN_USER__USER_ID`
user
- user_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- email — VARCHAR(255)
- image_uri — VARCHAR(255)
- nickname — VARCHAR(255)
- profile_message — VARCHAR(255)
- is_suspended — TINYINT(1) — NOT NULL
user_alarm_status
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- total_alarm_count — BIGINT — NOT NULL
- unchecked_alarm_count — BIGINT — NOT NULL
user_image
- resource_id — BIGINT — Foreign key → resource.resource_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id
- INDEX — `FK__USER_IMAGE__USER_ID`
user_role
- role_name — VARCHAR(50) — Foreign key → role.role_name — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- INDEX — `FK__ROLE__ROLE_NAME`
user_suspension_log
- user_suspension_log_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- last_modified_at — DATETIME
- user_id — BIGINT — Foreign key → user.user_id
- reason — VARCHAR(255)
- start_date — DATETIME
- end_date — DATETIME
- admin_id — BIGINT — Foreign key → user.user_id
- action_type — VARCHAR(255)
- INDEX — `FK__USER_SUSPENSION_LOG__USER_ID`
- INDEX — `FK__USER_SUSPENSION_LOG__ADMIN_ID`
user_suspension_status
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- end_date — DATETIME
- reason — VARCHAR(255)