OMEYE SMART PARKING

Tables (11)

camera (카메라)

  • idx — int(11) — Primary key — NOT NULL
  • name — varchar(1056 )
  • vms_id — varchar(1056)
  • vms_identifiers — varchar(1056 )
  • address — varchar(1056)
  • latitude — double
  • longitude — double
  • created_at — datetime

camera_parking_area (카메라_주차구역)

  • idx — int(11) — Primary key — NOT NULL
  • parking_area_idx — int(11) — Foreign key → parking_area.idx — NOT NULL
  • camera_idx — int(11) — Foreign key → camera.idx — NOT NULL
  • created_at — datetime

default_policy (기본 정책)

  • idx — int(11) — Primary key — NOT NULL
  • event_period_time — int(11)
  • schedule_start_time — varchar(256 )
  • schedule_end_time — varchar(256)
  • app_push_cycle — int(11)
  • max_of_app_push — int(11)
  • created_at — datetime

event_log (이벤트 이력)

  • idx — int(11) — Primary key — NOT NULL
  • parking_area_idx — int(11) — Foreign key → parking_area.idx — NOT NULL
  • status — varchar(2 56)
  • num_of_app_push — int(11)
  • start_date_time — datetime
  • end_date_time — dateime
  • Field

parking_area (주차구역)

  • idx — int(11) — Primary key — NOT NULL
  • user_idx — UUID — Foreign key → user.idx — NOT NULL
  • parking_compartment_num — varchar(256)
  • parking_compartment_name — varchar(256 )
  • parking_compartment_points — varchar(256)
  • license_plate — varchar(256 )
  • parking_compartment_image_url — varchar(1056)
  • created_at — datetime

site (사이트)

  • idx — int(11) — Primary key — NOT NULL
  • name — varchar(1056)
  • type — varchar(32)
  • created_at — datetime

site_camera (사이트_카메라)

  • idx — int(11) — Primary key — NOT NULL
  • site_idx — int(11) — Foreign key → site.idx — NOT NULL
  • camera_idx — int(11) — Foreign key → camera.idx — NOT NULL

user (사용자)

  • idx — UUID — Primary key — NOT NULL
  • user_level_idx — Int(11) — Foreign key → user_level.idx — NOT NULL
  • email — varchar(256 )
  • name (naem) — varchar(256)
  • password — varchar(256 )
  • app_push_token — varchar(256)
  • created_at (created_At) — datetime

user_level (사용자 권한)

  • idx — Int(11) — Primary key — NOT NULL
  • description — varchar(256 )
  • created_at — datetime

user_parking_area (사용자_담당주차구역)

  • idx — Primary key — NOT NULL
  • parking_area_idx — int(11) — Foreign key → parking_area.idx — NOT NULL
  • user_idx — UUID — Foreign key → user.idx — NOT NULL
  • created_at — datetime

vms_config (vms 설정정보)

  • idx — int(11) — Primary key — NOT NULL
  • vms_id — varchar(50)
  • vms_pw — varchar(256 )
  • vms_lic — varchar(256)
  • max_stored_day — int(11)
  • vms_group — varchar(256)
  • vms_server_ip — varchar(256 )
  • vms_auth_token — varchar(1056 )
  • vms_user_serial — int(11)
  • vms_api_serial — int(11)