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