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)