exapnsionPlan

Tables (5)

submarine_cable

  • submarine_cable_id — bigint — Primary key
  • cable_korean_name — varchar(255)
  • cable_name — varchar(255)
  • virtual — boolean — NOT NULL
  • priority — varchar(255)

submarine_cable_city

  • city_id — bigint — Primary key
  • korean_name — varchar(255)
  • name — varchar(255)
  • uuid — varchar(255)
  • country_id (country_id2) — bigint — Foreign key → submarine_cable_country.country_id

submarine_cable_country

  • country_id — bigint — Primary key
  • korean_name — varchar(255)
  • name — varchar(255)
  • uuid — varchar(255)

submarine_cable_point

  • submarine_cable_point_id — bigint — Primary key
  • altitude — numeric(20, 15)
  • latitude — numeric(20, 15)
  • longitude — numeric(20, 15)
  • point_korean_name — varchar(255)
  • point_name — varchar(255)
  • uuid — varchar(255)
  • virtual — boolean — NOT NULL
  • simple_altitude — numeric(20, 15)
  • simple_latitude — numeric(20, 15)
  • simple_longitude — numeric(20, 15)
  • address — varchar(255)
  • submarine_cable_id (submarine_cable_id2) — bigint — Foreign key → submarine_cable.submarine_cable_id
  • city_id (city_id2) — bigint — Foreign key → submarine_cable_city.city_id

submarine_cable_segment

  • submarine_cable_segment_id — bigint — Primary key
  • distance — double
  • segment_korean_name — varchar(255)
  • segment_name — varchar(255)
  • uuid — varchar(255)
  • version — varchar(255)
  • virtual — boolean — NOT NULL
  • coordinates — text
  • simple_coordinates — text
  • start_point_id (submarine_cable_point_id) — bigint — Foreign key → submarine_cable_point.submarine_cable_point_id
  • end_point_id (submarine_cable_point_id2) — bigint — Foreign key → submarine_cable_point.submarine_cable_point_id
  • submarine_cable_id (submarine_cable_id2) — bigint — Foreign key → submarine_cable.submarine_cable_id