d

Tables (11)

vpg_billboard

  • billboard_sn — int — NOT NULL
  • billboard_name — varchar(20) — NOT NULL
  • billboard_type_cd — char(6) — NOT NULL
  • billboard_ip — varchar(15) — NOT NULL
  • billboard_port — int — NOT NULL
  • direction_type_cd — char(6) — NOT NULL
  • display_img_type_cd — char(6) — NOT NULL
  • disable_imply_yn — char(1) — NOT NULL
  • led_module_cnt — int — NOT NULL
  • guide_msg — varchar(50)
  • floor_sn — int — NOT NULL
  • left_floor_sn — int
  • left_disabled_only — char(1) — NOT NULL
  • right_floor_sn — int
  • right_disabled_only — char(1) — NOT NULL
  • control_id — int
  • send_order — int — NOT NULL
  • control_state — char(1) — NOT NULL
  • map_x1 — int
  • map_y1 — int
  • map_x2 — int
  • map_y2 — int
  • map_width — int
  • map_height — int
  • map_angle — int — NOT NULL
  • memo — varchar(100)
  • reg_man — int
  • chg_dtm — datetime
  • crt_dtm — datetime

vpg_billboard_group

  • billboard_sn — int — Primary key — NOT NULL
  • parking_side_sn — int — Primary key — NOT NULL
  • direction_type — char(1) — Primary key — NOT NULL
  • reg_man — int
  • chg_dtm — datetime
  • crt_dtm — datetime
  • parking_side_sn — )*/

vpg_entrancebillboard

  • entrance_billboard_sn — int — NOT NULL
  • entrance_billboard_name — varchar(20) — NOT NULL
  • ip — varchar(15) — NOT NULL
  • port — int — NOT NULL
  • control_id — int — NOT NULL
  • led_module_cnt — int — NOT NULL
  • display_type — int — NOT NULL
  • disable_imply_yn — char(1) — NOT NULL
  • max_floor_count — int — NOT NULL
  • use_color — char(1) — NOT NULL
  • reg_man — int
  • chg_dtm — datetime
  • crt_dtm — datetime

vpg_entrancebillboard_group

  • entrance_billboard_sn — int — Primary key — NOT NULL
  • floor_sn — int — Primary key — NOT NULL
  • send_order — int
  • followed_disable — int — NOT NULL
  • reg_man — int
  • chg_dtm — datetime
  • crt_dtm — datetime
  • floor_sn — ASC

vpg_loc_cross

  • path_sn — int — NOT NULL
  • path_name — varchar(20)
  • map_x1 — int
  • map_y1 — int
  • map_x2 — int
  • map_y2 — int
  • map_width — int
  • map_height — int
  • floor_sn — int — NOT NULL

vpg_loc_floor_desc

  • floor_desc — int — NOT NULL
  • floor_sn — int — NOT NULL
  • floor_desc_img — image
  • floor_loc_image — image

vpg_loc_guideline

  • guideline_sn — int — NOT NULL
  • start_path_sn — int — NOT NULL
  • start_path_type — int — NOT NULL
  • end_path_sn — int — NOT NULL
  • end_path_type — int — NOT NULL

vpg_loc_locator

  • locator_sn — int — NOT NULL
  • locator_name — varchar(20)
  • map_x1 — int
  • map_y1 — int
  • map_x2 — int
  • map_y2 — int
  • map_width — int
  • map_height — int
  • floor_sn — int — NOT NULL
  • locatordevice_ip — char(15) — NOT NULL
  • locatordevice_port — int — NOT NULL
  • sync_yn — char(1) — NOT NULL
  • relation_list — varchar(100)

vpg_loc_path_detail

  • path_sn — int
  • parking_side_sn — int
  • locator_sn — int
  • floor_sn — int
  • stair_sn — int
  • location_list — varchar(512)
  • parking_side_sn — ASC

vpg_loc_stair

  • stair_sn — int — NOT NULL
  • star_name — varchar(20)
  • map_x1 — int
  • map_y1 — int
  • map_x2 — int
  • map_y2 — int
  • map_width — int
  • map_height — int

vpg_parking

  • parking_sn — int — NOT NULL
  • parking_side_sn — int
  • parking_side_name — varchar(20) — NOT NULL
  • floor_sn — int — NOT NULL
  • parking_type_cd — char(6)
  • parking_yn — char(1) — NOT NULL
  • car_no — char(12)
  • reservation_car_no — char(12)
  • reservation_dt — char(8)
  • last_enter_dtm — datetime
  • last_exit_dtm — datetime
  • image_file_name — varchar(260)
  • reg_man — int
  • chg_dtm — datetime
  • crt_dtm — datetime