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)