parking
Tables (12)
board_categories
- category_id — INT
- category_name — VARCHAR(50) — NOT NULL
- category_description — VARCHAR(200)
- display_order — INT
boards
- board_id — INT
- category_id — INT — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- like_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- is_notice — BOOLEAN
comments
- comment_id — INT
- board_id — INT — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- parent_comment_id — INT
favorite_parkings
- favorite_id — INT
- user_id — VARCHAR(50) — NOT NULL
- parking_id — INT — NOT NULL
- nickname — VARCHAR(100)
- created_at — DATETIME
parking_history
- history_id — INT
- parking_id — INT — NOT NULL
- available_spaces — INT — NOT NULL
- occupied_spaces — INT — NOT NULL
- recorded_at — DATETIME
- day_of_week — TINYINT
- hour_of_day — TINYINT
parking_lots
- parking_id — INT
- parking_name — VARCHAR(200) — NOT NULL
- address — VARCHAR(300) — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- total_spaces — INT — NOT NULL
- parking_type — VARCHAR(50)
- base_fee — INT
- additional_fee — INT
- operating_hours — VARCHAR(100)
- phone — VARCHAR(20)
- description — TEXT
- created_at — DATETIME
parking_reports
- report_id — INT
- user_id — VARCHAR(50) — NOT NULL
- location — VARCHAR(300) — NOT NULL
- latitude — DECIMAL(10, 8)
- longitude — DECIMAL(11, 8)
- description — TEXT — NOT NULL
- image_path — VARCHAR(500)
- report_status — VARCHAR(20)
- created_at — DATETIME
parking_reviews
- review_id — INT
- parking_id — INT — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- rating — DECIMAL(2, 1) — NOT NULL
- comment — TEXT — EX
- created_at — DATETIME
realtime_parking_status
- status_id — INT
- parking_id — INT — NOT NULL
- available_spaces — INT — NOT NULL
- occupied_spaces — INT — NOT NULL
- updated_at — DATETIME
user_parking_records
- record_id — INT
- user_id — VARCHAR(50) — NOT NULL
- parking_id — INT — NOT NULL
- vehicle_id — INT
- entry_time — DATETIME — NOT NULL
- exit_time — DATETIME
- parking_fee — INT
- memo — TEXT
users
- user_id — VARCHAR(50)
- user_name — VARCHAR(100) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- email — VARCHAR(200) — NOT NULL
- phone — VARCHAR(20)
- join_date — DATETIME
- is_active — BOOLEAN
- profile_image — VARCHAR(500)
vehicles
- vehicle_id — INT
- user_id — VARCHAR(50) — NOT NULL
- car_number — VARCHAR(20) — NOT NULL
- car_model — VARCHAR(100)
- car_color — VARCHAR(50)
- is_primary — BOOLEAN
- registered_date — DATETIME