ASDF

Tables (4)

AidsToNavigation (beacon)

  • AtoN Info (info) — varchar(60) — Primary key
  • ID Code (ID) — varchar(60) — Primary key — NOT NULL
  • Date end (date_end) — date
  • Date start (date_start) — date
  • Period end (period_end) — date
  • Infomation (Information) — varchar(60)
  • Infomation in national language (Language) — varchar(60)
  • Textual description in national language (description_lagnguage) — varchar(60)
  • Textual description (description) — varchar(60)
  • Scale minimum (scale) — integer
  • Source date (source) — integer
  • Source indication (soruce_indication) — integer
  • Pictorial representation (pictorial) — varchar(60)
  • Inspection frequency (inspection) — varchar(60)
  • Inspection requirement (inspection_requirment) — varchar(60)
  • Aton maintence record (aton) — varchar(60)
  • Installation date (installation) — date
  • Geometry (geometry) — varchar(60)

AtoN Info (beacon-info)

  • AtoN Info (info2) — varchar(60) — Foreign key → AidsToNavigation.AtoN Info
  • ID Code (ID) — varchar(60) — Foreign key → AidsToNavigation.ID Code — NOT NULL
  • AtoN Info (aton_info) — varchar(60)
  • Name (name) — varchar(60)
  • Latitude (latitude) — varchar(60)
  • LIngitude (tude) — varchar(60)

Generic Buoy (beacon-status)

  • Buoy shape (shape) — varchar(60) — Primary key — NOT NULL
  • Status (status) — varhcar(60) — Primary key
  • category of special purpose mark (mark) — varchar(60)
  • Colour (colour) — varchar(60)
  • Field — varchar(60)
  • Radar conspicuous (radar) — varchar(60)
  • Navigational system of marks (marks) — varchar(60)
  • AtoN Info (info) — varchar(60) — Foreign key → AidsToNavigation.AtoN Info
  • ID Code (ID) — varchar(60) — Foreign key → AidsToNavigation.ID Code — NOT NULL
  • Nature of construction (nature) — varchar(60)
  • Object name in national language (object_name) — varchar(60)
  • Object name (object) — varchar(60)
  • Vertical length (vertical_length) — varchar(60)
  • Vertical accuacy (vertical_accuacy) — varchar(60)
  • Type of buoy (buoy) — varchar(60)
  • Aid availability category (category) — varchar(60)

Light (beacon-light)

  • Buoy shape (shape) — varchar(60) — Foreign key → Generic Buoy.Buoy shape — NOT NULL
  • Status (status) — varhcar(60) — Foreign key → Generic Buoy.Status
  • Category of light (light) — integer
  • Colour (colour) — integer
  • Exhibition condition of light (exhibition) — varchar(60)
  • Height (height) — varchar(60)
  • Light characteristic (character) — varchar(60)
  • Light visbility (visbility) — varchar(60)
  • Navigtional system of marks (marks) — varchar(60)
  • Multiplicity of lights (lights) — integer
  • Object name in national language (national_language) — varchar(60)
  • Object name (object_name) — varchar(60)
  • Orientation (orientation) — varchar(60)
  • Sector limit one (limit_one) — integer
  • Sector limit two (limit_two) — integer
  • Signal group (group) — varchar(60)
  • Signal period (period) — timestamp
  • Signal sequence (sequence) — integer
  • Vertical accuracy (accuracy) — varchar(60)
  • Vertical length (vertical_length) — integer
  • Vertical datum (datum) — varchar(60)
  • Type of light (type_light) — varchar(60)
  • Type of battery (type_battery) — varchar(60)
  • Value of geographical range (range) — varchar(60)
  • Value of luminous range (value_range) — integer
  • Remote monitoring system (system) — varchar(60)
  • Remotely Monitored (monitored) — varchar(60)