Hangang Life ON
Tables (7)
bike_facilities (Untitled7)
- bike_facility_id (Field) — varchar(64) — Primary key
- facility_name (Field2) — varchar(200)
- addr_road (Field3) — varchar(200)
- lat (Field4) — decimal(9,6)
- lon (Field5) — decimal(9,6)
- open_hours (Field6) — varchar(200)
- capacity (Field7) — varchar(50)
- dist_m (Field9) — decimal(9,1)
- park_code (.) — varchar2(20BYTE) — Foreign key → parks.park_code — NOT NULL
facilities (Untitled3)
- facility_id (Field2) — bigint(20) — Primary key
- facility_name (Field3) — varchar(150)
- distri facility_lat ct_name (Field4) — decimal(10,6)
- facility_lon (Field5) — decimal(10,6)
- operating_period (Field6) — varchar(100)
- operating_hours (Field7) — varchar(100)
- is_24 (Field8) — char(1)
- fee (Field9) — varchar(100)
- category (Field10) — varchar(100)
- description (Field11) — varchar(500)
- park_code (.) — varchar2(20BYTE) — Foreign key → parks.park_code — NOT NULL
facility_visitors (Untitled4)
- facility_id (Field) — bigint(20) — Primary key
- stat_month (Field2) — date
- visitor_count (Field3) — int(10) unsigned
- facility_id (Field22) — bigint(20) — Foreign key → facilities.facility_id
locations (Untitled5)
- convenient_id (Field) — int(11) — Primary key
- facilities_type (Field2) — varchar(50)
- latitude (Field3) — decimal(10,7)
- longitude (Field4) — decimal(10,7)
- park (Field5) — varchar(100)
- park_code (Field6) — varchar(20)
- facilities_name (Field7) — varchar(200)
- address (Field8) — varchar(200)
- Field9 — varchar(200)
- park_code (.) — varchar2(20BYTE) — Foreign key → parks.park_code — NOT NULL
- convenient_id (Field10) — int(11) — Foreign key → operations.convenient_id
operations (Untitled6)
- convenient_id (Field) — int(11) — Primary key
- facility_category (Field2) — varchar(100)
- operating_hours (Field3) — varchar(255)
- contact (Field4) — varchar(150)
- usage_method (Field5) — varchar(255)
park_visitors (Untitled2)
- stat_month (Field) — date — Primary key
- visitors_total (Field2) — int(11)
- visitors_nonlocal (Field3) — int(11)
- visitors_foreign (Field4) — int(11)
- visitors_bike (Field5) — int(11)
- fav_age_group (Field6) — varchar(20)
- fav_time_slot (Field7) — varchar(20)
- park_code (.) — varchar2(20BYTE) — Foreign key → parks.park_code — NOT NULL
parks (Untitled)
- park_code (.) — varchar2(20BYTE) — Primary key — NOT NULL
- park_name (Field) — varchar2(100BYTE)
- city_name (Field2) — varchar2(50BYTE)
- district _name (Field3) — varchar2(200BYTE)
- addr_jibun (Field4) — varchar(200)
- road_address \ (Field5) — varchar(200)
- park_lat (Field6) — decimal(10,6)
- park_lon (Field7) — decimal(10,6)