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)