[최종] 주차바로
테이블 (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