atm

Tables (15)

booking (booking_deleted)

  • Key (booking_id) — BIGINT — Primary key — NOT NULL
  • booking_date — DATE — NOT NULL — 예약 날짜
  • booking_time — TIME — NOT NULL — 예약 시간
  • qr_token — VARCHAR(255) — NOT NULL — QR 검증용 토큰
  • status — VARCHAR(50) — NOT NULL — PENDING, USED, EXPIRED, CANCELLED
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL
  • Field (device.device_id) — BIGINT — NOT NULL
  • Field2 (member.member_id) — BIGINT — NOT NULL

company

  • company_id — bigint — Primary key — NOT NULL
  • is_deleted — bit — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • created_by — bigint — NOT NULL
  • updated_by — bigint
  • company_name — varchar(200) — NOT NULL
  • currency — varchar(10) — NOT NULL
  • timezone — varchar(50) — NOT NULL
  • country — varchar(10) — NOT NULL

customer

  • customer_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • customer_type — varchar(32) — NOT NULL — HOUSEHOLD | RESTAURANT | OTHERS
  • address — varchar(500)
  • postal_code — varchar(10)
  • latitude — decimal(10, 7)
  • longitude — decimal(11, 7)
  • bank_name — varchar(64)
  • bank_account — varchar(32)
  • bank_account_holder — varchar(100)
  • business_name — varchar(200)
  • business_type — varchar(64) — 사업 유형
  • business_number — varchar(20)
  • business_license_file_key — varchar(512)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_by — bigint
  • updated_by — bigint
  • is_deleted — tinyint(1) — NOT NULL

device

  • device_id — bigint — Primary key — NOT NULL
  • serial_number — varchar(64) — NOT NULL — 기기 일련번호
  • bluetooth_name — varchar(64)
  • status — varchar(20) — NOT NULL — AVAILABLE | IN_USE | FULL | ERROR
  • current_weight — decimal(12, 3) — NOT NULL — 탱크 현재 적재 무게(kg)
  • max_weight — decimal(12, 3) — NOT NULL — 탱크 최대 수용 무게(kg, 최대 9999999.999)
  • latitude — decimal(11, 8) — 설치 위치 위도 (WGS84, -90 ~ 90)
  • longitude — decimal(11, 8) — 설치 위치 경도 (WGS84, -180 ~ 180)
  • address — varchar(500) — 설치 주소
  • company_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • created_by — bigint
  • updated_by — bigint
  • is_deleted — tinyint(1) — NOT NULL

device_session

  • device_session_id — bigint — Primary key — NOT NULL
  • device_id — bigint — Foreign key → device.device_id — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • status — varchar(20) — NOT NULL — ACTIVE | COMPLETED | EXPIRED
  • completed_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

device_session_result

  • device_session_result_id — bigint — Primary key — NOT NULL
  • device_session_id — bigint — Foreign key → device_session.device_session_id — NOT NULL
  • price_id — bigint — Foreign key → uco_price_history.price_id — NOT NULL
  • final_weight — decimal(12, 3) — NOT NULL
  • unit_price — decimal(12, 2) — NOT NULL
  • total_amount — decimal(12, 2) — NOT NULL
  • reward_point — int — NOT NULL
  • sd_file_key — varchar(512)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

maintenance_history

  • Key3 (maintenance_history_id) — BIGINT — Primary key — NOT NULL
  • maintenance_task_id — BIGINT — Foreign key — NOT NULL
  • note — VARCHAR(255) — 조치 특이사항 및 의견
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL

maintenance_history_media

  • Key4 (maintenance_history_media_id) — BIGINT — Primary key — NOT NULL
  • maintenance_history_id — BIGINT — Foreign key — NOT NULL
  • media_file_key — VARCHAR(255) — NOT NULL — 증빙 사진
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL

maintenance_task

  • Key2 (maintenance_task_id) — BIGINT — Primary key — NOT NULL
  • device_id — bigint — Foreign key → device.device_id — NOT NULL
  • assignee_member_id — BIGINT
  • task_type — VARCHAR(50) — NOT NULL — COLLECT_TANK, REPLACE_BATTERY, REPAIR_DEVICE, CLEANING, EMERGENCY
  • status — VARCHAR(50) — NOT NULL — CREATED, ASSIGNED, IN_PROGRESS, COMPLETED
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → company.company_id — NOT NULL
  • is_deleted — bit — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • created_by — bigint — NOT NULL
  • updated_by — bigint
  • last_login — datetime(6)
  • username — varchar(255)
  • country_code — char(2) — NOT NULL — 국가 코드 (전화번호 로그인 시 사용)
  • phone_number — varchar(20) — 전화번호 (국가 번호 X)
  • password — varchar(255) — NOT NULL
  • status — varchar(10) — NOT NULL — ACTIVE | INACTIVE
  • email — varchar(255)
  • profile_image_file_key — varchar(512) — 프로필 이미지

member_role

  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • role — varchar(30) — NOT NULL — ROLE_ADMIN | ROLE_MANAGER | ROLE_FIELD_STAFF | ROLE_CUSTOMER

redemption

  • Key (redemption_id) — BIGINT — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • requested_points — DECIMAL(12, 2) — NOT NULL — 환전 차감 포인트
  • redemption_amount — DECIMAL(12, 2) — NOT NULL — 환전 금액
  • status — VARCHAR(50) — NOT NULL — 환전 처리 상태
  • bank_reference_number — VARCHAR(100) — 은행 송금 참조 번호
  • rejection_reason — VARCHAR(255) — 반려 사유
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL

uco_price_history

  • price_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → company.company_id — NOT NULL
  • unit_price — decimal(12, 2) — NOT NULL — kg당 단가
  • created_at — timestamp — NOT NULL
  • created_by — bigint

wallet

  • Key2 (wallet_id) — BIGINT — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL — ROLE_CUSTOMER만 보유
  • balance_points — DECIMAL(12, 2) — NOT NULL — 현재 포인트 잔액
  • accumulated_points — DECIMAL(12, 2) — NOT NULL — 누적 적립 포인트
  • used_points — DECIMAL(12, 2) — NOT NULL — 누적 사용 포인트
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • is_deleted — BOOLEAN — NOT NULL

wallet_transaction

  • wallet_transaction_id — BIGINT — Primary key — NOT NULL
  • Key2 (wallet_id) — BIGINT — Foreign key → wallet.Key2 — NOT NULL
  • transaction_type — VARCHAR(50) — NOT NULL — EARN (적립), REDEEM (사용/환전), ADJUST (조정)
  • amount — DECIMAL(12, 2) — NOT NULL — 거래 포인트
  • balance_after_transaction — DECIMAL(12, 2) — NOT NULL — 거래 후 잔액
  • reference_type — VARCHAR(50) — DEVICE_SESSION, REDEMPTION
  • reference_id — BIGINT — 참조 ID (세션ID 또는 환급ID)
  • description — VARCHAR(255) — 거래 상세 내역
  • created_at — TIMESTAMP — NOT NULL