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