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)