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