hs

Tables (25)

auth

  • id — bigint(20) — Primary key — NOT NULL
  • access_token — text — NOT NULL
  • refresh_token — text — NOT NULL
  • token_type — varchar(255) — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id

batch_job_execution

  • JOB_EXECUTION_ID — bigint(20) — Primary key — NOT NULL
  • VERSION — bigint(20)
  • JOB_INSTANCE_ID — bigint(20) — 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)

batch_job_execution_context

  • JOB_EXECUTION_ID — bigint(20) — 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(20) — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
  • PARAMETER_NAME — varchar(100) — NOT NULL
  • PARAMETER_TYPE — varchar(100) — NOT NULL
  • PARAMETER_VALUE — varchar(2500)
  • IDENTIFYING — char(1) — NOT NULL

batch_job_execution_seq

  • ID — bigint(20) — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

batch_job_instance

  • JOB_INSTANCE_ID — bigint(20) — Primary key — NOT NULL
  • VERSION — bigint(20)
  • JOB_NAME — varchar(100) — NOT NULL
  • JOB_KEY — varchar(32) — NOT NULL

batch_job_seq

  • ID — bigint(20) — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

batch_step_execution

  • STEP_EXECUTION_ID — bigint(20) — Primary key — NOT NULL
  • VERSION — bigint(20) — NOT NULL
  • STEP_NAME — varchar(100) — NOT NULL
  • JOB_EXECUTION_ID — bigint(20) — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • COMMIT_COUNT — bigint(20)
  • READ_COUNT — bigint(20)
  • FILTER_COUNT — bigint(20)
  • WRITE_COUNT — bigint(20)
  • READ_SKIP_COUNT — bigint(20)
  • WRITE_SKIP_COUNT — bigint(20)
  • PROCESS_SKIP_COUNT — bigint(20)
  • ROLLBACK_COUNT — bigint(20)
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

batch_step_execution_context

  • STEP_EXECUTION_ID — bigint(20) — 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(20) — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

categories

  • id — bigint(20) — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • category_key — varchar(50) — NOT NULL
  • description — varchar(200)
  • display_name — varchar(50) — NOT NULL
  • emoji — varchar(10)
  • sort_order — int(11) — NOT NULL

chat_message

  • id — bigint(20) — Primary key — NOT NULL
  • content — varchar(1000) — NOT NULL
  • created_at — datetime(6)
  • room_id — varchar(255) — NOT NULL
  • sender_id — varchar(255) — NOT NULL
  • is_read — bit(1) — NOT NULL

chat_room

  • room_id — varchar(255) — Primary key — NOT NULL
  • buyer_id — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • item_id — bigint(20)
  • room_type — enum('ADMIN','TRADE') — NOT NULL
  • seller_id — varchar(255) — NOT NULL

inquiry

  • ID — bigint(20) — Primary key — NOT NULL — 글 번호
  • CATEGORY — varchar(10) — NOT NULL — 카테고리 (all, pay, user, product)
  • QUESTION — text — NOT NULL — 질문 내용
  • ANSWER — text — NOT NULL — 답변 내용
  • CREATED_AT — timestamp — 등록날짜

notice

  • id — bigint(20) — Primary key — NOT NULL — 글번호
  • title — varchar(255) — NOT NULL — 글제목
  • content — text — 내용
  • pinned — int(11)
  • created_at — datetime — 작성일자

notification

  • id — bigint(20) — Primary key — NOT NULL
  • content — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • is_read — bit(1) — NOT NULL
  • receiver_id — varchar(255) — NOT NULL
  • related_item_id — bigint(20)
  • type — varchar(255) — NOT NULL
  • related_string_id — varchar(100)

pay_balance

  • user_id — varchar(255) — Primary key — NOT NULL
  • hwanseung_pay — int(11)

pay_history

  • history_no — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(255)
  • imp_uid — varchar(255)
  • merchant_uid — varchar(255)
  • amount — int(11) — NOT NULL
  • type — varchar(255)
  • created_at — datetime

product

  • product_id — int(11) — Primary key — NOT NULL — 상품PK
  • content — text — NOT NULL — 삼품 설명
  • price — int(11) — NOT NULL — 가격
  • seller_id — varchar(50) — NOT NULL — 판매자
  • title — varchar(100) — NOT NULL — 상품명
  • category — varchar(50) — NOT NULL — 카테고리
  • location — varchar(100) — NOT NULL — 지역
  • created_at — datetime(6) — NOT NULL — 생성일
  • deleted_at — datetime(6) — 삭제일
  • updated_at — datetime(6) — 수정일
  • seller_nickname — varchar(50) — NOT NULL — 판매자닉네임
  • sale_status — varchar(20) — NOT NULL — 판매상태 SALE / SOLD_OUT / RESERVED
  • lat — double — 위도
  • lng — double — 경도
  • report_count — int(11) — NOT NULL — 신고횟수
  • view_count — int(11) — NOT NULL — 조회수
  • hide_reason — varchar(500)

product_image

  • product_image_id — int(11) — Primary key — NOT NULL
  • image_path — varchar(255) — NOT NULL
  • original_name — varchar(255) — NOT NULL
  • stored_name — varchar(255) — NOT NULL
  • product_id — int(11) — Foreign key → product.product_id — NOT NULL

product_like

  • product_like_id — int(11) — Primary key — NOT NULL
  • product_id — int(11) — Foreign key → product.product_id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

report_history

  • id — bigint(20) — Primary key — NOT NULL
  • action — varchar(20) — NOT NULL
  • admin_nickname — varchar(50)
  • created_at — datetime(6)
  • memo — text
  • report_id — bigint(20) — Foreign key → reports.id — NOT NULL

reports

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • reason — text
  • reason_category — varchar(30)
  • reported_email — varchar(100)
  • reported_nickname — varchar(50)
  • reported_user_id — bigint(20) — NOT NULL
  • reporter_email — varchar(100)
  • reporter_id — bigint(20) — NOT NULL
  • reporter_nickname — varchar(50)
  • status — varchar(20) — NOT NULL
  • target_product_id — bigint(20)
  • type — varchar(20) — NOT NULL

search_keywords

  • id — bigint(20) — Primary key — NOT NULL
  • count — bigint(20) — NOT NULL
  • keyword — varchar(100) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • username — varchar(255) — id
  • password — varchar(100) — NOT NULL
  • name — varchar(50) — NOT NULL
  • nickname — varchar(30) — NOT NULL
  • birthday — varchar(10)
  • contact — varchar(20)
  • email — varchar(50)
  • gender — varchar(10)
  • zip_code — varchar(10)
  • address — varchar(100)
  • detail_address — varchar(100)
  • role — enum('ROLE_ADMIN', 'ROLE_USER', 'ROLE_SUPER', 'ROLE_SUB')
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • report_count — int(11)
  • status — enum('ACTIVE', 'SUSPENDED', 'SECESSION', 'PENDING')
  • trust_score — int(11)
  • neighborhood — varchar(50) — 인증된 동네 이름 (예: 안양동)
  • is_neighborhood_authenticated — tinyint(1) — NOT NULL — 동네 인증 여부 (0: 미인증, 1: 인증됨)
  • profile_image_path — varchar(255)
  • profile_original_name — varchar(255)
  • suspend_until — datetime(6)
  • suspended_at — datetime(6)
  • provider — varchar(20)
  • provider_id — varchar(255)