ZeroJuice v1
Tables (7)
client
- id — BIGINT — Primary key — NOT NULL
- client_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- client_name — VARCHAR(50)
- created_at — DATETIME
parking_record
- id — BIGINT — Primary key — NOT NULL
- vehicle_id — BIGINT — Foreign key → vehicle.id — NOT NULL
- slot_id — BIGINT — Foreign key → parking_slot.id
- entry_time — DATETIME — NOT NULL
- exit_time — DATETIME
- status — ENUM('PARKING', 'PARKED', 'EXITING', 'COMPLETED') — NOT NULL
- created_at — DATETIME
parking_slot
- id — BIGINT — Primary key — NOT NULL
- slot_no — VARCHAR(10) — NOT NULL
- pos_x — DECIMAL(10,4) — NOT NULL
- pos_y — DECIMAL(10,4) — NOT NULL
- status — ENUM('EMPTY', 'OCCUPIED', 'PARKING') — NOT NULL
payment
- id — BIGINT — Primary key — NOT NULL
- record_id — BIGINT — Foreign key → parking_record.id — NOT NULL
- amount — INT — NOT NULL
- method — ENUM('RFID', 'KAKAO', 'CARD') — NOT NULL
- status — ENUM('PENDING', 'SUCCESS', 'FAILED') — NOT NULL
- rfid_tag — VARCHAR(50)
- paid_at — DATETIME
- created_at — DATETIME
setting
- id — BIGINT — Primary key — NOT NULL
- client_id — BIGINT — Foreign key → client.id — NOT NULL
- key_name — VARCHAR(50) — NOT NULL
- value — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- updated_at — DATETIME
user
- id — BIGINT — Primary key — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- fcm_token — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
vehicle
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- vehicle_no — VARCHAR(20) — NOT NULL
- rfid_tag — VARCHAR(50)
- created_at — DATETIME