[최종] 주차바로

테이블 (16)

admin_action_logs

  • action_log_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • admin_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • event_id — BIGINT — 외래 키 → parking_events.event_id — NOT NULL
  • action_type — VARCHAR(40) — NOT NULL
  • before_status — ENUM('DETECTED','DISMISSED','NEED_ADMIN','REQUESTED','RESOLVED')
  • after_status — ENUM('DETECTED','DISMISSED','NEED_ADMIN','REQUESTED','RESOLVED')
  • memo — TEXT

device_tokens

  • device_token_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • platform — VARCHAR(20)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

entry_decision

  • entry_decision_id — BIGINT — 기본 키 — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • entry_attempt_id — VARCHAR(100) — NOT NULL
  • payload_hash — VARCHAR(64) — NOT NULL
  • access_decision — VARCHAR(10) — NOT NULL
  • decision_revision — INT — NOT NULL
  • vehicle_id — BIGINT
  • session_id — BIGINT
  • resolution — VARCHAR(20)
  • resolved_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

event_images

  • image_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • event_id — BIGINT — 외래 키 → parking_events.event_id — NOT NULL
  • image_url — VARCHAR(500)
  • image_type — ENUM('PARKING_STATE','PLATE','REPORT') — NOT NULL
  • captured_at — DATETIME(6)
  • evidence_id — VARCHAR(36)
  • publication_revision — INT
  • availability — ENUM('AVAILABLE','UNAVAILABLE')
  • unavailable_reason — VARCHAR(40)
  • checksum — VARCHAR(100)
  • byte_size — BIGINT

inbound_receipt

  • inbound_receipt_id — BIGINT — 기본 키 — NOT NULL
  • endpoint — VARCHAR(40) — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • payload_hash — VARCHAR(64) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

move_request_responses

  • response_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • request_id — BIGINT — 외래 키 → move_requests.request_id — NOT NULL
  • responder_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • response_type — ENUM('CANNOT_MOVE_NOW','WILL_MOVE') — NOT NULL
  • estimated_minutes — INT
  • responded_at — DATETIME(6) — NOT NULL

move_requests

  • request_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • event_id — BIGINT — 외래 키 → parking_events.event_id — NOT NULL
  • requester_user_id — BIGINT — 외래 키 → users.user_id
  • target_vehicle_id — BIGINT — 외래 키 → vehicles.vehicle_id — NOT NULL
  • request_type — ENUM('AUTO','MANUAL') — NOT NULL
  • request_status — ENUM('CANCELLED','COMPLETED','NEED_ADMIN','REMINDER_SENT','RESPONDED','SENT') — NOT NULL
  • message — TEXT
  • requested_at — DATETIME(6) — NOT NULL
  • due_at — DATETIME(6)
  • reminder_count — INT — NOT NULL
  • reminder_sent_at — DATETIME(6)
  • verification_attempt — INT — NOT NULL

notifications

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • event_id — BIGINT — 외래 키 → parking_events.event_id
  • request_id — BIGINT — 외래 키 → move_requests.request_id
  • notification_type — ENUM('MOVE_REQUEST','MOVE_RESPONSE','REMINDER','EV_OVERSTAY','EVENT_RESOLVED') — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • body — TEXT — NOT NULL
  • sent_at — DATETIME(6) — NOT NULL

outbox

  • outbox_id — BIGINT — 기본 키 — NOT NULL
  • command_type — VARCHAR(40) — NOT NULL
  • aggregate_id — VARCHAR(100) — NOT NULL
  • revision — INT — NOT NULL
  • idempotency_key — VARCHAR(200) — NOT NULL
  • endpoint_path — VARCHAR(100) — NOT NULL
  • payload — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempts — INT — NOT NULL
  • next_attempt_at — DATETIME(6) — NOT NULL
  • deadline_at — DATETIME(6)
  • application_result — VARCHAR(20)
  • last_error — TEXT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

parking_events

  • event_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • session_id — BIGINT — 외래 키 → parking_sessions.session_id — NOT NULL
  • vehicle_id — BIGINT — 외래 키 → vehicles.vehicle_id — NOT NULL
  • zone_id — BIGINT — 외래 키 → parking_zones.zone_id
  • event_type — ENUM('BAD_PARKING','DISABLED_ZONE_VIOLATION','DOUBLE_PARKING','EV_OVERSTAY','OUT_OF_ZONE','ETC') — NOT NULL
  • reason — TEXT
  • violation_ratio — INT
  • event_status — ENUM('DETECTED','DISMISSED','NEED_ADMIN','REQUESTED','RESOLVED') — NOT NULL
  • detected_at — DATETIME(6) — NOT NULL
  • resolved_at — DATETIME(6)
  • incident_id — VARCHAR(36)
  • publication_revision — INT
  • rule_code — VARCHAR(40)
  • physical_vehicle_id — VARCHAR(36)
  • entry_attempt_id — VARCHAR(100)

parking_sessions

  • session_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • vehicle_id — BIGINT — 외래 키 → vehicles.vehicle_id — NOT NULL
  • zone_id — BIGINT — 외래 키 → parking_zones.zone_id
  • recognized_plate_number — VARCHAR(20) — NOT NULL
  • entry_attempt_id — VARCHAR(100)
  • entry_time — DATETIME(6) — NOT NULL
  • parked_at — DATETIME(6)
  • exit_time — DATETIME(6)
  • idempotency_key — VARCHAR(100)
  • context_revision — INT — NOT NULL

parking_zones

  • zone_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • zone_number — VARCHAR(20) — NOT NULL
  • zone_type — ENUM('DISABLED','EV_CHARGING','GENERAL','AISLE','ENTRY_EXIT')
  • floor — VARCHAR(20)
  • geometry_data — TEXT
  • allowed_minutes — INT
  • status — ENUM('ACTIVE','INACTIVE')
  • hw_zone_id — INT
  • entry_exit_role — ENUM('ENTRY','EXIT')

user_consents

  • consent_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • consent_type — ENUM('PRIVACY_POLICY','TERMS_OF_SERVICE') — NOT NULL
  • consent_version — VARCHAR(20) — NOT NULL
  • agreed_at — DATETIME(6) — NOT NULL

user_notification_settings

  • setting_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • move_request_receive — BIT(1) — NOT NULL
  • response_reminder — BIT(1) — NOT NULL
  • ev_overstay — BIT(1) — NOT NULL
  • office_notice — BIT(1) — NOT NULL
  • quiet_hours_start — TIME — NOT NULL
  • quiet_hours_end — TIME — NOT NULL
  • channel — ENUM('PUSH','PUSH_SMS') — NOT NULL

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • building_number — VARCHAR(20) — NOT NULL
  • unit_number — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('ADMIN','RESIDENT') — NOT NULL
  • status — ENUM('ACTIVE','DELETED','PENDING','REJECTED','SUSPENDED') — NOT NULL

vehicles

  • vehicle_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • plate_number — VARCHAR(20) — NOT NULL
  • vehicle_model — VARCHAR(50)
  • is_disabled_vehicle — BIT(1) — NOT NULL
  • is_electric — BIT(1) — NOT NULL
  • owner_type — ENUM('RESIDENT','VISITOR') — NOT NULL
  • visit_date — DATE
  • status — ENUM('ACTIVE','DELETED','PENDING') — NOT NULL