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